Home » RDBMS Server » Backup & Recovery » Archive log files accidentally deleted (9i R2, solaris 10)
Archive log files accidentally deleted [message #415521] Tue, 28 July 2009 03:03 Go to next message
Messages: 117
Registered: December 2007
Senior Member

At my test environment , I was taking HOT backups by "ALTER TABLESPACE <<TS_NAME>> begin backup;" command.

During the time of backup UNIX admin guys accidentally deleted some archive log files generated at the time of backups.

Could anyone please suggest as how to recover the tablespace as I am getting error "Need latest archive file to recover".

Re: Archive log files accidentally deleted [message #415529 is a reply to message #415521] Tue, 28 July 2009 03:27 Go to previous message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
You can just recover up to the latest archived log you have.

Previous Topic: RMAN compare to TS in HOT backup mode
Next Topic: point in time recovery in oracle 10g.
Goto Forum:

Current Time: Mon Aug 21 03:31:39 CDT 2017

Total time taken to generate the page: 0.01965 seconds