OraFAQ Forum: Backup & Recovery » datafile loss and not any backup

Home » RDBMS Server » Backup & Recovery » datafile loss and not any backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

datafile loss and not any backup [message #319859]

Tue, 13 May 2008 04:36

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.

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

Michel Cadot
Messages: 68650
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

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

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

Michel Cadot
Messages: 68650
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

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

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

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

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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

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 ?

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

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

User-Managed Backup and Recovery Guide

Regards
Michel

Report message to a moderator

Previous Topic:	backup table using rman
Next Topic:	Rman scripts location

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 08:36:33 CDT 2024