Home » RDBMS Server » Server Administration » ORA-01669: standby database control file not consistent
ORA-01669: standby database control file not consistent [message #204964] Wed, 22 November 2006 23:28 Go to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Friends,

I did a hot backup from a live server and re-stored it on the backup server but prior to the hot backup, i created a standby control file and put it on the standby server.

These commands worked well:

SVRMGR> startup nomount pfile=/pdata1/mnp/initmnp.ora

SVRMGR> alter database mount standby database;

SVRMGR> recover standby database

But when i typed this command, i have this error
SVRMGR> alter database activate standby database
2> ;
alter database activate standby database
*
ORA-01669: standby database control file not consistent

Do you think that the standby control file should have been created after I did the hot backup?

Thank you,

Dirish
Re: ORA-01669: standby database control file not consistent [message #204965 is a reply to message #204964] Wed, 22 November 2006 23:29 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi Dirish,

Oracle Version ?


Before that you have to configure Primary database. see reference link.
3.2.1 Create a Backup Copy of the Primary Database Datafiles
You can use any backup copy of the primary database to create the physical standby database, as long as you have the necessary archived redo log files to completely recover the database. Oracle recommends that you use the Recovery Manager utility (RMAN).

See Oracle High Availability Architecture and Best Practices for backup recommendations and Oracle Database Backup and Recovery Advanced User's Guide to perform an RMAN backup operation.

3.2.2 Create a Control File for the Standby Database
If the backup procedure required you to shut down the primary database, issue the following SQL*Plus statement to start the primary database:

SQL> STARTUP MOUNT;

Then, create the control file for the standby database, and open the primary database to user access, as shown in the following example:

SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/boston.ctl';
SQL> ALTER DATABASE OPEN;

Note:

You cannot use a single control file for both the primary and standby databases. 



If Oracle 10g. fellow below procedure.

For Physical Standby Database.
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i63561


For Logical Standby database.
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ls.htm#g105412




hope this helps
taj

[Updated on: Wed, 22 November 2006 23:34]

Report message to a moderator

Re: ORA-01669: standby database control file not consistent [message #204967 is a reply to message #204965] Wed, 22 November 2006 23:36 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Oracle7 Server Release 7.3.4.0.0 - Production
PL/SQL Release 2.3.4.0.0 - Production
Re: ORA-01669: standby database control file not consistent [message #204968 is a reply to message #204967] Wed, 22 November 2006 23:41 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi ,


Oracle 7
Read Heading : Database Design and Implmentation.

Step : You have to first start archiving in primary site.
In primary site you have to take init.ora or datafiles bkp.
After database you have to create Control files. for standby database.
Read reference link for more info.


http://www.geocities.com/kgkrish/download/standby_73.pdf



hope this helps
Taj
Re: ORA-01669: standby database control file not consistent [message #204973 is a reply to message #204968] Wed, 22 November 2006 23:47 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Taj,

means that first I should do the hot backup then create the standby control file?


Thanks,

Dirish
Re: ORA-01669: standby database control file not consistent [message #204977 is a reply to message #204973] Wed, 22 November 2006 23:52 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi dirish

First configure primary site database.


means that first I should do the hot backup then create the standby control file
Yes







Taj
Re: ORA-01669: standby database control file not consistent [message #204979 is a reply to message #204977] Wed, 22 November 2006 23:55 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Thanks Taj, I will do the following and revert back to you,

...Dirish
Re: ORA-01669: standby database control file not consistent [message #205066 is a reply to message #204977] Thu, 23 November 2006 03:52 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi,

I did the hot backup first then created a standby control file.
I re-stored the backup files and control file.

SVRMGR> startup nomount pfile=/pdata1/mnp/initmnp.ora is ok

SVRMGR> alter database mount standby database is ok

SVRMGR> recover standby database is ok

BUT
SVRMGR> alter database activate standby database;
alter database activate standby database
*
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/pdata1/mnp/DATA/system01_mnp.dbf'

what should I do?
ORA-07360: sfifi: stat error, unable to obtain information about file [message #205260 is a reply to message #204977] Fri, 24 November 2006 01:35 Go to previous message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi friends,

am still struggling with my problem to activate my standby database.

SVRMGR> alter database activate standby database
2> ;
alter database activate standby database
*
ORA-07360: sfifi: stat error, unable to obtain information about file.
IBM AIX RISC System/6000 Error: 2: No such file or directory

Can you please help me,

Dirish (From Mauritius)
Previous Topic: oracle 10g in sun solaris 10 - Prequirment for installation
Next Topic: Error
Goto Forum:
  


Current Time: Fri Sep 20 07:00:42 CDT 2024