Saturday, 14 December 2024

Rebuild Oracle Standby Database oracle 12c and later with archive GAP with single command

-- On standby

rman target /

shutdown immediate;

startup nomount;

restore standby controlfile from service PRIM;

alter database mount;

--restore datafile 4 from service PRIM; -- If new data files added to primary recently    

recover database from service PRIM noredo using compressed backupset

RECOVER MANAGED STANDBY DATABASE disconnect from session;


No comments:

Post a Comment

Number of Visitors