Home » RDBMS Server » Backup & Recovery » datafile loss and not any backup
datafile loss and not any backup [message #319859] Tue, 13 May 2008 04:36 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

i have loss my datafile system01.dbf and i have also no any backup for that file .

what i will do ?

my database not start.
Re: datafile loss and not any backup [message #319860 is a reply to message #319859] Tue, 13 May 2008 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what i will do ?

Unfortunatly if you have no backup, nothing can be done, you lost your database.

Regards
Michel
Re: datafile loss and not any backup [message #319869 is a reply to message #319860] Tue, 13 May 2008 05:04 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

it is necessary to start any database have system.dbf .we can't recreate system.dbf .

[Updated on: Tue, 13 May 2008 05:05]

Report message to a moderator

Re: datafile loss and not any backup [message #319871 is a reply to message #319869] Tue, 13 May 2008 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it is necessary to start any database have system.dbf .we can't recreate system.dbf .

Exactly.

Regards
Michel
Re: datafile loss and not any backup [message #319873 is a reply to message #319871] Tue, 13 May 2008 05:16 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

if we have a system01.dbf but no its backup and media recovery required for that file at that time also we lost our database
Re: datafile loss and not any backup [message #319881 is a reply to message #319873] Tue, 13 May 2008 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use archived and online logs to recover.

Regards
Michel
Re: datafile loss and not any backup [message #320058 is a reply to message #319881] Tue, 13 May 2008 23:36 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

how recovery possible with log and archive log?

in primary database.
sql>alter system switch logfile

i do it but agian i get recovery need for system01.dbf in physical standby database.

what i can do ?
Re: datafile loss and not any backup [message #320078 is a reply to message #320058] Wed, 14 May 2008 01:01 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
User-Managed Backup and Recovery Guide

Regards
Michel
Previous Topic: backup table using rman
Next Topic: Rman scripts location
Goto Forum:
  


Current Time: Thu Dec 08 00:10:17 CST 2016

Total time taken to generate the page: 0.11382 seconds