| ORA-00314 during enabling stabndby database [message #203034] |
Mon, 13 November 2006 11:45  |
manish mendiratta
Messages: 110
Registered: May 2002
|
Senior Member |
|
|
Hi All,
I am getting this error as soon as i enable my standby database on windows.
Mon Nov 13 12:32:50 2006
Errors in file c:\ora10g\product\10.2.0\admin\orcl\bdump\orcl_lgwr_5856.trc:
ORA-00314: log 3 of thread 1, expected sequence# 15 doesn't match 0
ORA-00312: online log 3 thread 1: 'C:\ORA10G\PRODUCT\10.2.0\ORADATA\ORCL\REDO3.LOG'
I am using oracle 10g. They are test dbs and both these databases reside on my pc.
Please help.
Thanks
Manish
|
|
|
|
|
|
| Re: ORA-00314 during enabling stabndby database [message #208637 is a reply to message #208173] |
Mon, 11 December 2006 11:00  |
manish mendiratta
Messages: 110
Registered: May 2002
|
Senior Member |
|
|
Hi Anurag,
Thanks for your reply. Well here are the steps
Since they are test DBs, I have a cold backup of my P1 database.
1. Config the parameter files as mentioned in document.
2. Created standby redologs on standby database(S1).
3. alter system mount standby database;
4. alter database recover managed standby database disconnect from session;
5. Now when i try to perform
However i discovered if i issue
alter database recover managed standby database using current logfile;
this problem doesnot occur.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
