Home » RDBMS Server » Backup & Recovery » RMAN hot backup no archive logs (10.2.3 Solaris 10)
RMAN hot backup no archive logs [message #392908] Thu, 19 March 2009 11:13 Go to next message
lotusdeva
Messages: 201
Registered: March 2005
Senior Member
I have a disk space issue with my PROD db. I have backed up half of the archive logs to tape and deleted them. I now need to backup db online (hot). If I do backup database plus archievelog, I obvioulsy get errors:
ORA-19625: error identifying file /arc/prod/prod_1_11166.arc
ORA-27037: unable to obtain file status


If I just use backup database command in RMAN, would I be able to restore if I have my archives on tape?
Re: RMAN hot backup no archive logs [message #392917 is a reply to message #392908] Thu, 19 March 2009 11:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I would first do a CROSSCHECK and then RESYNC
Re: RMAN hot backup no archive logs [message #393913 is a reply to message #392908] Tue, 24 March 2009 21:24 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
hi,

I have a suggestion to avoid this problem next time: using rman to delete archive logs.

Regards,
Alex

[Updated on: Wed, 25 March 2009 02:08] by Moderator

Report message to a moderator

Re: RMAN hot backup no archive logs [message #393960 is a reply to message #392908] Wed, 25 March 2009 03:41 Go to previous message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,

You can run the folowing command;-
------------
RMAN> run
{allocate channel ch1 type disk;
crosscheck archivelog all;
backup database plus archivelog;
release channel ch1;
}

Please let me know it working or not.

Pokhraj.
Previous Topic: backup backupset porblem; urgent please
Next Topic: save RMAN to TSM
Goto Forum:
  


Current Time: Fri Apr 19 17:24:53 CDT 2024