ORA-01669: standby database control file not consistent [message #204964] |
Wed, 22 November 2006 23:28 |
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 |
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 #205066 is a reply to message #204977] |
Thu, 23 November 2006 03:52 |
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 |
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)
|
|
|