From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Performing point-in-time recovery of a PDB

Performing point-in-time recovery of a PDB - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Performing point-in-time recovery of a PDB

“

- [Instructor] Using RMAN, we can choose to recover a PDB to a specific point in time. Such as in the case something bad happen to our pluggable database at some point and we need to recover it to an earlier point in time. We can do all of that using RMAN. We'll start by obtaining the current database timestamp. So we'll open a SQL Plus connection as the sys DBA user to our Oracle instance. In your exercise file, you can find a sample SQL command to retriever the current timestamp from the database. So let's copy this command and paste it to our SQL Plus window. Remember that depending on when you will be executing this exercise, you will expect to find a different timestamp value than what you see on your screen right now. Let's copy this timestamp value as we're about to use it as part of an RMAN restore script. Let's quit our SQL Plus session and reconnect RMAN to our target database. So I'll type RMAN target equals and a backslash character. Going back to our exercise file, you…

Contents