Lost archive log on Standby database (Urgent) [message #60173] |
Tue, 20 January 2004 17:27 |
Parto
Messages: 1 Registered: January 2004
|
Junior Member |
|
|
Hai All,
Can anyone help me !!
I have Physical Standby Database and Manual Recovery Mode , my problems are , i lost my Archive log file that should be used to Recovery from Primay database to Standby database !
I already try to used the command Alter system Archive log change <sequence number> , but the command did not create Archive Log File !
Any suggest for my problem without recreate my standby database !!
Tanks for Your Info !!
|
|
|
Re: Lost archive log on Standby database (Urgent) [message #60182 is a reply to message #60173] |
Wed, 21 January 2004 04:51 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Hi,
When you loose an archived redolog file( and no backups), your recovery cannot proceed beyond that (ie redo log stream is broken and further rollforward process is not possible ) , in a physical standby environment.
You may need to recreate the standby database and continue the sync up.
-Thiru
|
|
|