Home » RDBMS Server » Backup & Recovery » Recover db on standby server
Recover db on standby server [message #253474] Tue, 24 July 2007 01:33 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Hi all,

I tried to enable archive log and take a cold backup on pri server and then i copied all files (datafiles,control files,redo logs,archive )to the stand by server.I tried to updated on any table and commited on pri server and then i tried to start stand by server as below step.

1. SQL> ALTER SYSTEM ARCHIVE LOG CURRENT; (Pri)
2.copy archive log files to stand by server
3.SQL> startup mount
4.SQL> recover database until cancel;
5.SQL> alter database open resetlogs;

I tried to query on standby server and found data did not up-to-date.
What happended? Pls advice me.
Oracle 8i,Windows 2000

Thanks for advance
Chara
Re: Recover db on standby server [message #253480 is a reply to message #253474] Tue, 24 July 2007 01:48 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use Recover Database
Re: Recover db on standby server [message #253492 is a reply to message #253474] Tue, 24 July 2007 02:15 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Thank you for your replied ,I got this error

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

Any idea ?
Rgds,
Chara
Re: Recover db on standby server [message #253498 is a reply to message #253474] Tue, 24 July 2007 02:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Database already recovered. No action needed.
Re: Recover db on standby server [message #253502 is a reply to message #253474] Tue, 24 July 2007 02:34 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member

Could you pls advise me why my data did not up-to-date ?

Rdgs,
Chara
Re: Recover db on standby server [message #253507 is a reply to message #253474] Tue, 24 July 2007 02:40 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Hope this will help you.

http://www.oracle-base.com/articles/8i/StandbyDatabase.php
Re: Recover db on standby server [message #253681 is a reply to message #253507] Tue, 24 July 2007 10:52 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
4.SQL> recover database until cancel;


Why you using until cancel clause?
is there any file missing?
Do you know the sequnece no where you made changes?
Previous Topic: how to recover after lost of currnet redo log file (merged)
Next Topic: Export database into script
Goto Forum:
  


Current Time: Wed Dec 07 10:22:32 CST 2016

Total time taken to generate the page: 0.11470 seconds