OraFAQ Forum: Backup & Recovery » Plese suggest the solution for following test cases of recovery

Home » RDBMS Server » Backup & Recovery » Plese suggest the solution for following test cases of recovery

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

Plese suggest the solution for following test cases of recovery [message #238930]

Mon, 21 May 2007 00:58

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Hi,

Please let me know in Oracle 9i

1)if it is possible to recover control file where all copies in NAS or SAN has been lost.The databse is up.
Would ALTER DATBASE BACKUP CONTROL FILE TO file.bkp ; work?

2) To recover full database using RMAN in 9i-if all archive logs not present (eg. Some archive files have been deleted which were expired)

Thanks

Report message to a moderator

Re: Plese suggest the solution for following test cases of recovery [message #238935 is a reply to message #238930]

Mon, 21 May 2007 01:02

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

if it is possible to recover control file where all copies in NAS or SAN has been lost.
Yes, it is possible through control file backup if backup is also not available then you have to recreate control file.

.The databse is up.
No,when you lost control file due to any reason then database goes to shutdown.

To recover full database using RMAN in 9i-if all archive logs not present

YOu have to perform incomplete recovery.

Regards
Taj

Report message to a moderator

Re: Plese suggest the solution for following test cases of recovery [message #238955 is a reply to message #238930]

Mon, 21 May 2007 01:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1) Have a look at thread named Loss of Controlfile started this week-end.
Please search or AT LEAST read the last topic subjects before posting.

Regards
Michel

Report message to a moderator

Re: Plese suggest the solution for following test cases of recovery [message #238963 is a reply to message #238930]

Mon, 21 May 2007 01:28

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Hi Taj,

Thanks for your suggestion.It is very helpful.

For the second point can you clarify if my latest archive files are present but expired has been deleted .Can i perform incomplete recovery of whole database ??
Eg : full database online backup was taken on Sunday.Archive files of monday deleted But tuesday to friday available

Report message to a moderator

Re: Plese suggest the solution for following test cases of recovery [message #239172 is a reply to message #238963]

Mon, 21 May 2007 12:04

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

you cant recover controlfile .controlfile always restore not recover
if archivelogs are missing then you have to perfrom incomplete recovery using CANCEL clause.

Report message to a moderator

Previous Topic:	ORA-19511: Error received from media manager layer, error text:
Next Topic:	IMP-00017 problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:40:19 CST 2024