Home » Server Options » Data Guard » ORA-00314 during enabling stabndby database
ORA-00314 during enabling stabndby database [message #203034] Mon, 13 November 2006 11:45 Go to next message
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 #208173 is a reply to message #203034] Fri, 08 December 2006 07:29 Go to previous messageGo to next message
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
Member
could you tell us, what steps you followed in setting up/enabling standby database?
Re: ORA-00314 during enabling stabndby database [message #208637 is a reply to message #208173] Mon, 11 December 2006 11:00 Go to previous message
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.
Previous Topic: Perlglob problem with Data Guard
Next Topic: Data Guard Manager
Goto Forum:
  


Current Time: Fri Dec 02 14:35:39 CST 2016

Total time taken to generate the page: 0.34080 seconds