Wednesday, March 20, 2019

Recover a Broken DR

Situation scooter is a DR of wheels. Scooter lost a whole /dba0c mount point which included a lot of db files and controlfile.


As far as i can recall what I did was.

1. Shutdown scooter
2. Copy pfile from wheels to scooter /dbs
3. startup nomount wheels with pfile from wheels
4. connect to rman
'rman  target sys/password@ORAP_STBY  auxiliary  sys/password@ORAP'
5.




 DUPLICATE TARGET DATABASE
  FOR STANDBY
  FROM ACTIVE DATABASE
  NOFILENAMECHECK;


6. RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

7. --Checking Logs

select max(sequence#) from v$archived_log where applied='YES';
select sequence# from v$archived_log where applied='NO';
select SEQUENCE#,DELAY_MINS,STATUS,PROCESS FROM v$managed_standby;

No comments:

Post a Comment