RMAN Physical Standby Database backup is used to create another physical standby database.
I have already taken backup of one of my physical standby database.
Use following steps to restore physical standby backup to create a new physical standby database.
Step 1: Create the directory on the server for the restoration process of RMAN.
[oracle@localhost oradata]$ mkdir -p /u01/oracle/fast_recovery_area/STD_MGR [oracle@localhost oradata]$ mkdir -p /u01/oracle/oradata/mgr [oracle@localhost oradata]$ mkdir -p /u01/oracle/admin/mgr/adump [oracle@localhost oradata]$ mkdir -p /u01/arc/mgr
Step 2: Transfer backup.
[oracle@test1 STD_MGR]$ rsync -azvrh /u01/oracle/fast_recovery_area/STD_MGR/ 192.168.1.15:/u01/oracle/fast_recovery_area/STD_MGR/ oracle@192.168.1.15's password: sending incremental file list ./ autobackup/ autobackup/2018_05_10/ autobackup/2018_05_10/o1_mf_s_975797323_fh8zsonf_.bkp autobackup/2018_05_10/o1_mf_s_975797323_fh900ryq_.bkp autobackup/2018_05_10/o1_mf_s_975798042_fh90h60h_.bkp autobackup/2018_05_10/o1_mf_s_975798581_fh90z0s6_.bkp autobackup/2018_05_10/o1_mf_s_975798818_fh916g29_.bkp autobackup/2018_05_13/ autobackup/2018_05_13/o1_mf_s_976059769_fhk012z1_.bkp backupset/ backupset/2018_05_10/ backupset/2018_05_10/o1_mf_nnnd0_TAG20180510T224813_fh8zqorx_.bkp backupset/2018_05_10/o1_mf_nnnd1_TAG20180510T225957_fh90g313_.bkp backupset/2018_05_10/o1_mf_nnnd1_TAG20180510T230840_fh90yz8x_.bkp backupset/2018_05_10/o1_mf_nnnd1_TAG20180510T231238_fh916dc0_.bkp flashback/ onlinelog/ onlinelog/o1_mf_1_fhk00pqb_.log onlinelog/o1_mf_2_fhk00ql5_.log onlinelog/o1_mf_3_fhk00rlm_.log onlinelog/o1_mf_4_ffcsd29x_.log onlinelog/o1_mf_5_ffcsd3rh_.log onlinelog/o1_mf_6_ffcsd51f_.log sent 299.77M bytes received 347 bytes 1.04M bytes/sec total size is 1.49G speedup is 4.98 [oracle@test1 STD_MGR]$
Step 3: Transfer spfile and password file to a new server.
Step 4: Startup database in the nomount stage :
[oracle@localhost oradata]$ export ORACLE_SID=mgr [oracle@localhost oradata]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed May 23 22:33:59 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 392495104 bytes Fixed Size 2253584 bytes Variable Size 176164080 bytes Database Buffers 209715200 bytes Redo Buffers 4362240 bytes
Step 5: Restore the control file :
[oracle@localhost oradata]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed May 23 22:34:35 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: MGR (not mounted) RMAN> restore controlfile from '/u01/oracle/fast_recovery_area/STD_MGR/autobackup/2018_05_10/o1_mf_s_975798818_fh916g29_.bkp'; Starting restore at 23-MAY-18 using channel ORA_DISK_1 channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:05 output file name=/u01/oracle/oradata/mgr/control01.ctl output file name=/u01/oracle/oradata/mgr/control02.ctl Finished restore at 23-MAY-18
Step 6: Mount database
RMAN> alter database mount; database mounted released channel: ORA_DISK_1
Step 7: Restore Database
RMAN> restore database; Starting restore at 23-MAY-18 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=54 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /u01/oracle/oradata/mgr/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to /u01/oracle/oradata/mgr/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00003 to /u01/oracle/oradata/mgr/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00004 to /u01/oracle/oradata/mgr/users01.dbf channel ORA_DISK_1: reading from backup piece /u01/oracle/fast_recovery_area/STD_MGR/backupset/2018_05_10/o1_mf_nnnd0_TAG20180510T224813_fh8zqorx_.bkp channel ORA_DISK_1: piece handle=/u01/oracle/fast_recovery_area/STD_MGR/backupset/2018_05_10/o1_mf_nnnd0_TAG20180510T224813_fh8zqorx_.bkp tag=TAG20180510T224813 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:01:06 Finished restore at 23-MAY-18 RMAN>
Step 8: Recover Database
RMAN> recover database; Starting recover at 23-MAY-18 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:00 Finished recover at 23-MAY-18 RMAN>
Step 9: Check database role of physical standby database :
SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE --------- -------------------- ---------------- MGR MOUNTED PHYSICAL STANDBY
Stay tuned for More articles on Oracle DataGuard
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram CChannel:https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
