Hi Everyone!!
This is one of the typical scenario occurs in DB world where DR database goes out of synch, procedure that was followed earlier is something we had to restore archivelogs from tape backup to roll forward the standby databases. Other option was to take incremental backup that has to be applied on Standby. Worst option would be perform full copy from primary. With latest releases 18c and beyond we can use the single command to synch the out of synched DR databases.
steps would be cancel the recovery on DR database and launch the 'recovery standby database from service' comamnd.
[oracle@ip-10-92-56-34 trace]$ rman target sys@sbxproddr
Recovery
Manager: Release 19.0.0.0.0 - Production on Wed Jul 19 14:45:17 2023
Version
19.13.0.0.0
Copyright
(c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
target
database Password:
connected
to target database: SBXPROD (DBID=3064676985, not open)
RMAN>
recover standby database from service sbxprod;
Starting
recover at 19-JUL-23
Oracle
instance started
Total
System Global Area 9663673920 bytes
Fixed
Size
8906304 bytes
Variable
Size
1577058304 bytes
Database
Buffers
8053063680 bytes
Redo
Buffers
24645632 bytes
contents
of Memory Script:
{
restore standby controlfile from service 'sbxprod';
alter database mount standby database;
}
executing
Memory Script
Starting
restore at 19-JUL-23
using
target database control file instead of recovery catalog
allocated
channel: ORA_DISK_1
channel
ORA_DISK_1: SID=739 device type=DISK
channel
ORA_DISK_1: starting datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
channel
ORA_DISK_1: restoring control file
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:04
output
file name=/u01/app/oracle/oradata/SBXPROD/control01.ctl
output
file name=/u01/app/oracle/fast_recovery_area/SBXPROD/control02.ctl
Finished
restore at 19-JUL-23
released
channel: ORA_DISK_1
Statement
processed
For
record type BACKUP PIECE RECIDS from 258 to 17274 are re-used before resync
For
record type BACKUP SET RECIDS from 258 to 17012 are re-used before resync
For
record type DELETED OBJECT RECIDS from 2673 to 31230 are re-used before resync
Executing:
alter system set standby_file_management=manual
contents
of Memory Script:
{
recover database from service 'sbxprod';
}
executing
Memory Script
Starting
recover at 19-JUL-23
Starting
implicit crosscheck backup at 19-JUL-23
allocated
channel: ORA_DISK_1
channel
ORA_DISK_1: SID=503 device type=DISK
Finished
implicit crosscheck backup at 19-JUL-23
Starting
implicit crosscheck copy at 19-JUL-23
using
channel ORA_DISK_1
Finished
implicit crosscheck copy at 19-JUL-23
searching
for all files in the recovery area
cataloging
files...
cataloging
done
List
of Cataloged Files
=======================
File
Name: /flash/SBXPRODDR/archivelog/2023_01_28/o1_mf_1_3168_kxbwvhox_.arc
File
Name: /flash/SBXPRODDR/archivelog/2023_07_17/o1_mf_1_2167_lcckmywy_.arc
File
Name: /flash/SBXPRODDR/archivelog/2023_07_17/o1_mf_1_2168_lcckmz43_.arc
File
Name: /flash/SBXPRODDR/archivelog/2023_07_17/o1_mf_1_2169_lcckmz5m_.arc
File
Name: /flash/SBXPRODDR/archivelog/2023_07_17/o1_mf_1_5882_lcckqhdz_.arc
File
Name: /flash/SBXPRODDR/archivelog/2023_07_17/o1_mf_1_5883_lcckqjy2_.arc
File
Name: /flash/SBXPRODDR/archivelog/2023_07_17/o1_mf_1_5884_lcckqmoc_.arc
File
Name: /flash/SBXPRODDR/archivelog/2023_07_17/o1_mf_1_5885_lccm793k_.arc
File
Name: /flash/SBXPRODDR/autobackup/2022_07_21/o1_mf_s_1110618925_kflyzkt6_.bkp
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 sbxprod
destination
for restore of datafile 00001: /data/SBXPROD/system01.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00002: /data/SBXPROD/sbxtax01.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00003: /data/SBXPROD/sysaux01.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:46
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00004: /data/SBXPROD/undotbs01.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00005: /data/SBXPROD/sbxaud01.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:56
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00007: /data/SBXPROD/users01.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:02
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00008: /data/SBXPROD/sbxaud02.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:01:06
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00009: /data/SBXPROD/sbxaud03.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:01:06
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00010: /data/SBXPROD/sbxaud04.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:01:06
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00011: /data/SBXPROD/sbxaud05.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:56
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00012: /data/SBXPROD/sbxaud06.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:56
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00013: /data/SBXPROD/sbxaud07.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:01:06
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00014: /data/SBXPROD/sbxaud08.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:01:06
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00015: /data/SBXPROD/sbxaud09.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:56
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00016: /data/SBXPROD/sbxaud10.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:01:05
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00017: /data/SBXPROD/sbxaud11.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:56
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: using network backup set from service sbxprod
destination
for restore of datafile 00018: /data/SBXPROD/sbxaud12.dbf
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:55
starting
media recovery
media
recovery complete, elapsed time: 00:00:00
Finished
recover at 19-JUL-23
Executing:
alter system set standby_file_management=auto
Finished
recover at 19-JUL-23
RMAN>
RMAN>
RMAN>
RMAN>
No comments:
Post a Comment