OraFAQ Forum: Data Guard » oracle 9i logical standby database

Home » Server Options » Data Guard » oracle 9i logical standby database (9.0.2.0.0,windows server 2003)

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

oracle 9i logical standby database [message #284320]

Thu, 29 November 2007 06:31

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Dear All,

I am trying to create logical standby Database by using the follwowing link

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ls.htm

i had followed all the steps accordingly and had taken the closed backup of primary DB with a clean shutdown

but when i try to open the logical standby DB at step 4.2.13
and got the following error

SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\STDY1\SYSTEM01.DBF'

Report message to a moderator

Re: oracle 9i logical standby database [message #284500 is a reply to message #284320]

Thu, 29 November 2007 22:26

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Did you create the STANDBY CONTROLFILE before or after you shutdown to backup the database?

Report message to a moderator

Re: oracle 9i logical standby database [message #284642 is a reply to message #284500]

Fri, 30 November 2007 06:34

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

As Described in documentation
At primary DB

SQL> STARTUP MOUNT;

SQL>ALTER DATABASE BACKUP CONTROLFILE TO
'/disk1/oracle/oradata/payroll/standby/payroll3.ctl';

Report message to a moderator

Previous Topic:	How to change a database_mode from primary to standby
Next Topic:	switchover b/w primary db to standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 22:18:21 CST 2024