yeh y'all,
My production database automatically archives to the standby. I tried to shutdown the standby, it hang on me. So i did the shutdown abort and there after startup and shutdown immediate.Then brought it backup ALTER DATABASE MOUNT STANDBY DATABASE; followed by ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE. Am getting the error below when i try to recover the standby. I looked for the log in the primary DB and it wasn't there.
Media Recovery Log /u01/app/oracle/admin/afpdbsp2/arch/arch_1_6431.arc
Errors with log /u01/app/oracle/admin/afpdbsp2/arch/arch_1_6431.arc.
ORA-279 signalled during: ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE...
Wed Jul 12 21:30:01 2006
ALTER DATABASE RECOVER CANCEL
Media Recovery Cancelled
How do i check for the logs that the primary try to push over while the the standby was down?My other question is if my primary database goes down will the fail over work with the missing logfile? I have read that to avoid this problem i should have stopped the primary then the standby and vice verse when bringing them backup. What if i cannot bring the prod db because it's should be up 24/7. Thanks in advance.
Mende
My production database automatically archives to the standby. I tried to shutdown the standby, it hang on me. So i did the shutdown abort and there after startup and shutdown immediate.Then brought it backup ALTER DATABASE MOUNT STANDBY DATABASE; followed by ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE. Am getting the error below when i try to recover the standby. I looked for the log in the primary DB and it wasn't there.
Media Recovery Log /u01/app/oracle/admin/afpdbsp2/arch/arch_1_6431.arc
Errors with log /u01/app/oracle/admin/afpdbsp2/arch/arch_1_6431.arc.
ORA-279 signalled during: ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE...
Wed Jul 12 21:30:01 2006
ALTER DATABASE RECOVER CANCEL
Media Recovery Cancelled
How do i check for the logs that the primary try to push over while the the standby was down?My other question is if my primary database goes down will the fail over work with the missing logfile? I have read that to avoid this problem i should have stopped the primary then the standby and vice verse when bringing them backup. What if i cannot bring the prod db because it's should be up 24/7. Thanks in advance.
Mende