Hello All,
My DG was out of sync and I was trying to perform "recovery standby database using service" on 19c database and it hits me below errors and before it throwed errors , it restored many datafiles on standby. The mentioned datafile in error logs exist on primary and standby both locations.
Your help is highly appreciated .
datafile 504 switched to datafile copy
input datafile copy RECID=413 STAMP=1126973853 file name=+DATA/T000202/F1D4286073061917E0532A05E50A4C9E/DATAFILE/ptaudit.1304.1126973851
datafile 505 switched to datafile copy
input datafile copy RECID=414 STAMP=1126973853 file name=+DATA/T000202/F1D4286073061917E0532A05E50A4C9E/DATAFILE/ptlock.1305.1126973853
datafile 506 switched to datafile copy
input datafile copy RECID=415 STAMP=1126973855 file name=+DATA/T000202/F1D4286073061917E0532A05E50A4C9E/DATAFILE/ptprc.1306.1126973853
datafile 507 switched to datafile copy
input datafile copy RECID=416 STAMP=1126973855 file name=+DATA/T000202/F1D4286073061917E0532A05E50A4C9E/DATAFILE/ptprjwk.1307.1126973855
datafile 508 switched to datafile copy
input datafile copy RECID=417 STAMP=1126973858 file name=+DATA/T000202/F1D4286073061917E0532A05E50A4C9E/DATAFILE/ptrpts.1308.1126973857
datafile 509 switched to datafile copy
input datafile copy RECID=418 STAMP=1126973860 file name=+DATA/T000202/F1D4286073061917E0532A05E50A4C9E/DATAFILE/pttbl.1309.1126973857
datafile 510 switched to datafile copy
input datafile copy RECID=422 STAMP=1126973864 file name=+DATA/T000202/F1D4286073061917E0532A05E50A4C9E/DATAFILE/pttlrg.1310.1126973859
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/24/2023 16:21:23
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of switch command on default channel at 01/24/2023 16:21:23
ORA-01121: cannot rename database file 511 - file is in use or recovery
ORA-01110: data file 511: '+DATA/T000201/F1D4286073061917E0532A05E50A4C9E/DATAFILE/pttree.746.1125662051'
On Standby.
SYS:T0002023>select name , status from v$datafile where file#=511;
NAME
--------------------------------------------------------------------------------
STATUS
-------
+DATA/T000201/F1D4286073061917E0532A05E50A4C9E/DATAFILE/pttree.746.1125662051
ONLINE
Regards