| Need to recover SYSTEM file [message #433230] |
Mon, 30 November 2009 15:51  |
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
|
Junior Member |
|
|
Hi,
How to recover the system.dbf file on physical stnadby server? i had created a non-system datafile on primary server but on standby it was created with different system generated name in ORACLE_HOME/database folder. I came know this is due to STANDBY_FILE_MANAGEMENT parameter not set/manual on standby server. i did tried to rename the non-system datafile but not worked. During this also i tried to open the database but now it is giving error msg " ORA-01196: file 1 is inconsistent due to a failed media recovery session". Even i do not have any backup of system file.
Please help on this.
Regards,
Vish
|
|
|
|
|
|
| Re: Need to recover SYSTEM file [message #433528 is a reply to message #433230] |
Wed, 02 December 2009 14:45  |
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
|
Junior Member |
|
|
BlackSwan,
I followed below mentioned step and it worked. NO need to rebuild physical standby server from primary.
1. alter database create datafile 'missingXXX.dbf' as '<new path>';
2. recover standby database;
3. Alter database open;
4. recover managed standby database disconnect from session;
Regards,
Vish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
