Anderson_R__Gom
13 years agoLevel 5
Restoring an entire Oracle database
Hi,
I'm working in an POC of NBU with Oracle environment. I made the backup and it's working fine.
Now I need to make a restore and I'm lost for begin these tests.
The database is in restore s...
- 13 years ago
Hi Anderson,
The Database was open ?.(DBID=1834298670, not open)
This script from Netbackup Admin Guide For Oracle 7.1 page 104
Start up the database in a nomount state.
On UNIX and Linux, the following is the output:SQL> startup nomount pfile=$ORACLE_HOME/dbs/inittest.ora%rman catalog rman/rman@rcatRMAN> set dbid=<dbid of source database on camelRMAN> connect target/RMAN> run {RMAN> ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';RMAN> SEND 'NB_ORA_SERV=lion, NB_ORA_CLIENT=camel';RMAN> restore controlfile;RMAN> }SQL> alter database mount;%orapwd file=$ORACLE_HOME/dbs/orapwtest password=<oracle>%rman catalog rman/rman@RCVCATRMAN>set dbid=<Saved dbID of Source Target>RMAN>connect target/RMAN>run {RMAN> ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';RMAN> ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';RMAN> SEND 'NB_ORA_SERV=lion, NB_ORA_CLIENT=camel';RMAN> restore database;RMAN> restore archivelog all;RMAN> }SQL>recover database until cancel using backup controlfile;Regards