Database Software

Got stuck with restore an archivelog on this 10.2.0.4 database. The backup piece was created on primary and scp'ed to this standby followed by catalog backuppiece '/tmp/ssmgme7s_1_1'. It contains the archivelog.

RMAN> list backup of archivelog sequence 44424 thread 1;


List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -----------------
18597 1.52M DISK 00:00:00 20110705 15:30:04
BP Key: 18599 Status: AVAILABLE Compressed: NO Tag: TAG20110705T153002
Piece Name: /tmp/ssmgme7s_1_1

List of Archived Logs in backup set 18597
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ----------------- ---------- ---------
1 44424 47606086607 20110619 09:30:05 47606253357 20110619 09:35:40


But trying to restore the log failed:

RMAN> run {
2> allocate channel c device type disk;
3> restore archivelog sequence 44424 thread 1 until sequence 44424 thread 1;
4> }

using target database control file instead of recovery catalog
allocated channel: c
channel c: sid=2180 instance=oracp21 devtype=DISK

Starting restore at 20110705 15:57:46

released channel: c
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/05/2011 15:58:50
RMAN-06027: no archive logs found that match specification

What I want is to extract the archive log either to the expected location (+FRA/<DBuniquename>), or anywhere on the filesystem so I can alter database register.

Thanks for help.

Edited by: user11989003 on Jul 5, 2011 2:06 PM