Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 53
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.
Report message to a moderator
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: 17716
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Quote:
what i will do ?

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

Regards
Michel
Report message to a moderator
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: 53
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: 17716
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Quote:
it is necessary to start any database have system.dbf .we can't recreate system.dbf .

Exactly.

Regards
Michel
Report message to a moderator
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: 53
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
Report message to a moderator
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: 17716
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
You can use archived and online logs to recover.

Regards
Michel
Report message to a moderator
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: 53
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 ?
Report message to a moderator
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: 17716
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
User-Managed Backup and Recovery Guide

Regards
Michel
Report message to a moderator
Previous Topic:backup table using rman
Next Topic:how to create auxiliary instance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sun Jul 27 04:51:17 CDT 2008

Total time taken to generate the page: 0.03241 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.