If you have DataGuard or standby database in your organization you probably will love that new RMAN feature. Since 12c it is possible to catchup standby database using incremental backup using one command. Additional space and time need to run incremental backup, copy over to standby and restore can be limited to time required to run incremental backup over network.
See short example:
Stopping recovery on standby
Running incremental backup:
For anyone who spend night trying to catch up standby database above solution looks brilliant.
regards,
Marcin
See short example:
Stopping recovery on standby
[oracle@ip-10-0-1-79 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 7 12:56:24 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel; Database altered. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Running incremental backup:
[oracle@ip-10-0-1-79 ~]$ rman target / Recovery Manager: Release 12.1.0.1.0 - Production on Sun Jul 7 12:56:39 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST12C (DBID=1424547711, not open) RMAN> recover database from service test12c_b using compressed backupset; Starting recover at 07-JUL-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service test12c_b destination for restore of datafile 00001: /u01/app/oracle/oradata/test12c/system01.dbf channel ORA_DISK_1: restore complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service test12c_b destination for restore of datafile 00002: /u01/app/oracle/oradata/test12c/sysaux01.dbf channel ORA_DISK_1: restore complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service test12c_b destination for restore of datafile 00003: /u01/app/oracle/oradata/test12c/undotbs01.dbf channel ORA_DISK_1: restore complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service test12c_b destination for restore of datafile 00004: /u01/app/oracle/oradata/test12c/users01.dbf channel ORA_DISK_1: restore complete, elapsed time: 00:00:07 ... RMAN>; exit Recovery Manager complete.
For anyone who spend night trying to catch up standby database above solution looks brilliant.
regards,
Marcin
2 comments:
Hi Marcin,
have you tried to recover standby which data file names different from primary? BTW, will it work with easy naming connection string - FROM SERVICE '//host/db'?
short answer for both queries is yes.
Primary has system in this location
/u01/app/oracle/oradata/test12c/system01.dbf
Standby recovering it to
/u01/app/oracle/oradata/test_move/system01.dbf
RMAN> recover database from service '//10.215.1.20:1522/dc1test12c' using compressed backupset;
Starting recover at 10-JUL-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service //10.215.1.20:1522/dc1test12c
destination for restore of datafile 00001: /u01/app/oracle/oradata/test_move/system01.dbf
Post a Comment