Home » Server Options » Data Guard » standby
standby [message #223900] Mon, 12 March 2007 04:11 Go to next message
kumar_dba
Messages: 16
Registered: March 2005
Location: chandigarh
Junior Member

I am in process of configuring the stand by database and I am getting the following error in standby database

SQL> startup nomount pfile='/disk3/stand/initSTAND.ora';
ORACLE instance started.

Total System Global Area 314572800 bytes
Fixed Size 1978272 bytes
Variable Size 96473184 bytes
Database Buffers 205520896 bytes
Redo Buffers 10600448 bytes
SQL> alter database mount standby database;

Database altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;


Database altered.

SQL> SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/disk6/dbase/DSA/system01.dbf'

Re: standby [message #225534 is a reply to message #223900] Tue, 20 March 2007 04:46 Go to previous messageGo to next message
amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai
Member

hi,

c first u have to cancel the MRM mode..

sql> alter database recover managed standby database cancel;

then u go 4
sql>alter database open readonly;


Regards,
Amit
Re: standby [message #226986 is a reply to message #223900] Tue, 27 March 2007 01:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-16004: backup database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/disk6/dbase/DSA/system01.dbf'



Which type of backup are you using for standby database.

it is due to your backup used for standby database is not sync.


http://dbataj.blogspot.com/2007/03/standby-database.html
regards
Taj
Re: standby [message #230240 is a reply to message #223900] Wed, 11 April 2007 04:53 Go to previous message
raj_t_menon
Messages: 8
Registered: November 2006
Location: Ahmedabad
Junior Member
If you are using same machine /different directory structure for Dataguard, then specify the parameters

db_file_name_convert
log_file_name_convert

Example:
db_file_name_convert ='/oracle/oradata/primary/',
'/oracle/oradata/stby/','/bkup/primary/', '/oracle/oradata/stby/'
log_file_name_convert='/oracle/oradata/primary','/oracle/oradata/stby/'
Previous Topic: Observer server requirements
Next Topic: how to remove Data Gaurd from Primery
Goto Forum:
  


Current Time: Thu Dec 08 10:30:02 CST 2016

Total time taken to generate the page: 0.13306 seconds