Home » RDBMS Server » Backup & Recovery » Need to recover SYSTEM file (ORACLE 10gR2,win2003 server)
Need to recover SYSTEM file [message #433230] Mon, 30 November 2009 15:51 Go to next message
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 #433233 is a reply to message #433230] Mon, 30 November 2009 17:19 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
rebuild physical standby server from primary
Re: Need to recover SYSTEM file [message #433528 is a reply to message #433230] Wed, 02 December 2009 14:45 Go to previous message
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
Previous Topic: Hot backups without archive logs
Next Topic: backup portal only
Goto Forum:
  


Current Time: Mon Dec 05 02:54:48 CST 2016

Total time taken to generate the page: 0.10916 seconds