| 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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
