OraFAQ Forum: Backup & Recovery » Loss due to media failure

Home » RDBMS Server » Backup & Recovery » Loss due to media failure

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

Loss due to media failure [message #238904]

Sun, 20 May 2007 22:45

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello All,

I'm attending for DBA interviews , and I was asked this question.

The scenario is that I've the last night backup of my database. And today morning my users since 9 am started doing their transactions and suddenly one of the datafile has been lost due to media failure.There are no archivelogs or any redologs also to issue recover database statement.

Can somebody help me in giving out a solution for this and also all the possibilities and scenarios of Backup and Recovery using user level backups.

I'll be glad if someone can help me in this regard.

Regards,

Raj

Report message to a moderator

Re: Loss due to media failure [message #238907 is a reply to message #238904]

Sun, 20 May 2007 23:12

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

Senior Member
Account Moderator

Database Backup and Recovery Basics
Backup and Recovery Concepts

Regards
Michel

Report message to a moderator

Re: Loss due to media failure [message #239170 is a reply to message #238907]

Mon, 21 May 2007 11:56

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

if your database was in Noarchivelog mode then you can't recover database to the point of failure.
however you will simply restore your whole pervious backup.

Report message to a moderator

Re: Loss due to media failure [message #239290 is a reply to message #239170]

Mon, 21 May 2007 23:26

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hi,

Thanks for the reply. I can go even for the data loss but I want to restore and recover my database.

My database is archivelog mode. But even the archive logs which are there on the disk have been lost due to media failure.

I've lost my datafiles and the archivelogs.

Report message to a moderator

Re: Loss due to media failure [message #239292 is a reply to message #238904]

Mon, 21 May 2007 23:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I've lost my datafiles and the archivelogs.
Either you have good backups or you get to start over from scratch.

Report message to a moderator

Re: Loss due to media failure [message #239350 is a reply to message #239292]

Tue, 22 May 2007 01:50

balaji1010
Messages: 35
Registered: March 2006
Location: London

Member

If your database is in archive log mode and you have lost your datafiles and archive log files, the simple answer is....

database can be recovered until point of failure.

point of failure means restore the whole database and go for recovery until available archive logs.

then open the database with resetlogs, implies log sequence number is set to 0 in the redologs.

This termed as incomplete recovery.

Hope this helps.

thanx

Report message to a moderator

Re: Loss due to media failure [message #239529 is a reply to message #239350]

Tue, 22 May 2007 10:42

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm

Report message to a moderator

Previous Topic:	User Managed Backups
Next Topic:	Backup and Recovery strategy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 23:17:22 CDT 2024