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
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,

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".

Pokhraj
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: 64131
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.

Regards
Michel
Previous Topic: Moving Oracle 9i database on AIX
Next Topic: RMAN compare to TS in HOT backup mode
Goto Forum:
  


Current Time: Wed Dec 07 14:41:40 CST 2016

Total time taken to generate the page: 0.12750 seconds