| standby [message #223900] |
Mon, 12 March 2007 04:11  |
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 #230240 is a reply to message #223900] |
Wed, 11 April 2007 04:53  |
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/'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
