Home » RDBMS Server » Backup & Recovery » Loss due to media failure
Loss due to media failure [message #238904] Sun, 20 May 2007 22:45 Go to next message
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


Re: Loss due to media failure [message #238907 is a reply to message #238904] Sun, 20 May 2007 23:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Basics
Backup and Recovery Concepts

Regards
Michel
Re: Loss due to media failure [message #239170 is a reply to message #238907] Mon, 21 May 2007 11:56 Go to previous messageGo to next message
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.
Re: Loss due to media failure [message #239290 is a reply to message #239170] Mon, 21 May 2007 23:26 Go to previous messageGo to next message
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.
Re: Loss due to media failure [message #239292 is a reply to message #238904] Mon, 21 May 2007 23:49 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: Loss due to media failure [message #239350 is a reply to message #239292] Tue, 22 May 2007 01:50 Go to previous messageGo to next message
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
Re: Loss due to media failure [message #239529 is a reply to message #239350] Tue, 22 May 2007 10:42 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm
Previous Topic: User Managed Backups
Next Topic: Backup and Recovery strategy
Goto Forum:
  


Current Time: Sun Dec 04 06:39:06 CST 2016

Total time taken to generate the page: 0.04838 seconds