OraFAQ Forum: Backup & Recovery » Recover db on standby server

Home » RDBMS Server » Backup & Recovery » Recover db on standby server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recover db on standby server [message #253474]

Tue, 24 July 2007 01:33

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

Report message to a moderator

Re: Recover db on standby server [message #253480 is a reply to message #253474]

Tue, 24 July 2007 01:48

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Use Recover Database

Report message to a moderator

Re: Recover db on standby server [message #253492 is a reply to message #253474]

Tue, 24 July 2007 02:15

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

Report message to a moderator