Step 3

Now type the following script at RMAN prompt to recover the loss datafile

RMAN> run {
          restore datafile '/u02/oracle/testdb/test/users01.dbf';
          recover datafile '/u02/oracle/testdb/test/users01.dbf';
          sql 'alter database open';
         }

In the above command

restore datafile ....

Line will restore the datafile. Since we were taking backup using RMAN, RMAN knows about all the backups and it will automatically restores the file from the most recent backup

recover datafile ....

Line will apply transactions from archive files to perform complete recovery

sql 'alter database open';

Line will open the database after recovery.

The output is shown below when we execute the above script

Step 4

We can now go to SQL Plus to check the database is open and we can access the contents of this file

Back to Previous Page