Missing an arch log on fail over database

[dbstudent]

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

 

[dbstudent]

One more question. How do i take an export of my primary database?

 

[Scunningham99]

you can check the alert log on your primary database to see your archives .

If the log is missing you will need to refresh your datafiles from primary as you cannot skip logs.

hth

simon

Sy UK