Oracle Database Restore from Cloud Object Store backup

Steps to Restore from Cloud Object Store backup

 

·         Assume that Tape backup is configured using Cloud backup module with Cloud Object Store and need to restore from Cloud Object Store.

 

·         Start the database in nomount state

 

SQL> startup nomount;

 

If the database is RAC, then set cluster_database parameter to “FALSE”

 

SQL> alter system set cluster_database=FALSE scope=SPFILE;

 

 

·         Verify the backup piece in Cloud object store.

 

Login into Cloud object store and verify the backup availability

Or

Using curl REST API verify the backup information

Backup is stored as file chunk, below is the Sample screenshot

 

 

 

 

·         Restore controlfile from backup piece

 

run

{

allocate channel t1 type 'sbt_tape' parms='SBT_LIBRARY=<Path to Library>/libopc.so, ENV=(OPC_PFILE=<Path to Config File>/opc<DB_NAME>.ora)';

RESTORE CONTROLFILE FROM 'c-2600717444-20200629-00' ;

release channel t1;

}

 

·         Mount database

 

RMAN > alter database mount

 

 

·         Restore database

run

{

allocate channel t1 type 'sbt_tape' parms='SBT_LIBRARY=<Path to Library>/libopc.so, ENV=(OPC_PFILE=<Path to Config File>/opc<DB_NAME>.ora)';

restore database;

release channel t1;

}

 

 

·         Recover database

 

 

run

{

allocate channel t1 type 'sbt_tape' parms='SBT_LIBRARY=<Path to Library>/libopc.so, ENV=(OPC_PFILE=<Path to Config File>/opc<DB_NAME>.ora)';

recover database;

release channel t1;

}

 

                                               

·         Open the database

 

RMAN > alter database open resetlogs;

 

·         Verify the Database

 

SQL> select name,open_mode from v$database;