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

Report message to a moderator

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: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't.
You can just recover up to the latest archived log you have.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 03 13:13:15 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.