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: 63917
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: Moving Oracle 9i database on AIX
Next Topic: RMAN compare to TS in HOT backup mode
Goto Forum:

Current Time: Mon Oct 24 23:11:13 CDT 2016

Total time taken to generate the page: 0.13879 seconds