Home » Server Options » Data Guard » oracle 9i logical standby database (9.0.2.0.0,windows server 2003)
oracle 9i logical standby database [message #284320] Thu, 29 November 2007 06:31 Go to next message
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'
Re: oracle 9i logical standby database [message #284500 is a reply to message #284320] Thu, 29 November 2007 22:26 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you create the STANDBY CONTROLFILE before or after you shutdown to backup the database?
Re: oracle 9i logical standby database [message #284642 is a reply to message #284500] Fri, 30 November 2007 06:34 Go to previous message
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';


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


Current Time: Thu Mar 28 04:00:12 CDT 2024