Home » RDBMS Server » Backup & Recovery » Archive files deleted during HOT backup (oracle 9i, Solaris)
Archive files deleted during HOT backup [message #453484] Thu, 29 April 2010 04:47 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,

I have taken one HOT backup by using the below command:-

SQL> ALTER TABLESPACE <TABLESPACE_NAME> BEGIN BACKUP;

During the backup lot of archive files are generated as at the time of backup insert and update is being performed.

Now I accidentally removed those archived logs.

When I make the above tablespace out of backup mode, how can I recover the tablespace as all the archives are being deleted.

Please help.

Regards-
p

Report message to a moderator

Re: Archive files deleted during HOT backup [message #453502 is a reply to message #453484] Thu, 29 April 2010 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't, this is why you have to restart a new backup and this time don't delete archived logs.

Regards
Michel

Report message to a moderator

Re: Archive files deleted during HOT backup [message #453508 is a reply to message #453484] Thu, 29 April 2010 05:31 Go to previous message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Thanks for your advice.

Thanks-
P

Report message to a moderator

Previous Topic: asm
Next Topic: rman duplicate
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 17:28:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.