Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need help with RMAN archive destination error while hot backup

ateeqrahmanMar 26 2011 — edited Mar 27 2011
Hi,

Oracle 8.0.6, Win 2000 server.

We take daily cold backup as our backup strategy. We wanted to implement hot backup. So one day, i turned on the archive log mode and set the archive directory in F:\drive to store all archived generated. I took the backup and set the database again in noarchive log mode. We contined with offline backup.

After few days, i wanted to test the hot backup again. I created the archive directory in E:\archive\ instead of F:\archive\ . When i started the hot backup, all the files were copied except the archives.

The error was:

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter system archive log current
RMAN-03023: executing command: sql

RMAN-03022: compiling command: backup
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-08031: released channel: c2
RMAN-00569: ================error message stack follows================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log F:\ARCHIVE\ARCH1_0000327116.ARC not found or out of sync with catalog

Recovery Manager complete.

Rman is looking for old archive log destination i.e. "f:\archive\ ". I dont have the backup of old destination archives. I had set the new archive destination to E:\archive\ in initorcl.ora file, still rman is looking for F:\archive\ destination.

Please suggest what to do. How can i remove old archive information from controlfile and tell rman to look in new archive destination i.e. E:\archive\
This post has been answered by tychos on Mar 26 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2011
Added on Mar 26 2011
2 comments
179 views