Home » RDBMS Server » Backup & Recovery » Interview question on recovery
Interview question on recovery [message #145569] Thu, 03 November 2005 19:28 Go to next message
dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore
Member

Hi

Any one plz let me know the answer for this question. The scenario is as follows:

My database always run in archive log mode. On 1-Nov-05 at 9:00PM i took cold backup of my database. on 2-Nov-05 at 9:00PM i took hot backup of my database. 3-Nov-05 at 10AM i created a new database for an existing tablespace. By 11:00AM my datafile has got corrupted or it has got deleted. In my previous backup that datafile backup is not available but database is running in archive log mode. Now is it possible to retrieve the data? If its possible what is the procedure?

Plz let me know.

Thanks,
Praveen
Re: Interview question on recovery [message #145732 is a reply to message #145569] Sat, 05 November 2005 10:22 Go to previous messageGo to next message
Steve Callan
Messages: 44
Registered: January 2004
Member
1) Can you not experiment with this scenario and see for yourself what happens?

2) You added a datafile. When does (or did) this get added to the backup in archivelog mode? In taking a hot backup, what are the three major steps you have to take? (Offline the tablespace, copy the datafiles, online the tablespace.) When did that happen since you added the datafile?

3) How do you add a database to a tablespace?
Re: Interview question on recovery [message #145793 is a reply to message #145732] Sun, 06 November 2005 19:42 Go to previous messageGo to next message
dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore
Member

As i said my database is running in archive log mode, 2nd nov night 21:00PM i took hot backup, on 3rd Nov by 10:00AM i added the datafile to an existing tablespace and i though to take hot backup as usual at 21:00PM at night. But unfortunately this datafile has got deleted by 11:00AM itself. Now is it possible to get my one hour (in between 10:00AM to 11:00AM) data?

Regards,
Praveen
Re: Interview question on recovery [message #145825 is a reply to message #145793] Mon, 07 November 2005 01:35 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
You can recover a datafile even if you dont have its backup , provided the database should be in archive log mode.

see this

http://www.orafaq.com/forum/mv/msg/22932/131215/72347/#msg_131254

[Updated on: Mon, 07 November 2005 01:37]

Report message to a moderator

Previous Topic: while taking backup
Next Topic: rman recovery is very slow
Goto Forum:
  


Current Time: Fri Mar 29 06:35:33 CDT 2024