Trying to restore RMAN backup in new server, got error RMAN-06172

From: Big George <jbeteta_at_gmail.com>
Date: Tue, 21 Jun 2011 13:29:13 -0700 (PDT)
Message-ID: <1912298f-07dc-445d-afcd-86af0e847389_at_y19g2000prd.googlegroups.com>

Hello,
We are using Oracle 10g R2 in Windows Server 2003. I'm trying to restore a database in a new server, using RMAN backups. Our external consultant configured RMAN scripts for full and incremental backups but never tested them . Since he just doesn't show up, I'm forced to tested them, restoring the whole database in a new server.
My instance is named MTDPROD, and I will create all from scratch.

At new server, I run all these commands:

C:\>oradim -new -sid MTDPROD -intpwd mtdprod Instance created

• I created the relevant folder hierarchy under <ORACLE_BASE> directory
• Then, I created the relevant directories for Oracle Database, as follows:
  --a. Create BDUMP, CDUMP, and UDUMP directories under '<ORACLE_ BASE>
  \admin'
• directory,
• b. Create <DATABASE_NAME> directory under '<ORACLE_BASE>\oradata' directory; in my
• case MTDPROD

C:\> set oracle_sid=MTDPROD

C:\> rman

RMAN> connect target sys
connected to target database (not started)

• My DBID is 2169285856 RMAN> set dbid=2169285856

RMAN> startup force nomount;

RMAN> restore spfile from autobackup db_recovery_file_dest='// 192.168.1.149/g$/XXXSRV4-ArcLogs/MTDPROD/RMAN' db_name='MTDPROD';

Messages:

Starting restore at 21-JUN-11
using channel ORA_DISK_1

recovery area destination: //192.168.1.149/g$/XXXSRV4-ArcLogs/MTDPROD/ RMAN
database name (or database unique name) used for search: MTDPROD

channel ORA_DISK_1: no autobackups found in the recovery area
channel ORA_DISK_1: looking for autobackup on day: 20110621
channel ORA_DISK_1: looking for autobackup on day: 20110620
channel ORA_DISK_1: looking for autobackup on day: 20110619
channel ORA_DISK_1: looking for autobackup on day: 20110618
channel ORA_DISK_1: looking for autobackup on day: 20110617
channel ORA_DISK_1: looking for autobackup on day: 20110616
channel ORA_DISK_1: looking for autobackup on day: 20110615
channel ORA_DISK_1: no autobackup in 7 days found

RMAN-00571:

---

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

---

RMAN-00571:

---

RMAN-03002: failure of restore command at 06/21/2011 12:50:28 RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

The RMAN backups are generating in //192.168.1.149/g$/XXXSRV4-ArcLogs/ MTDPROD/RMAN.
By instance, I see a lot of this kind of files: - FULL_MTDPROD_20110529_386_1.BAK
- INCR_MTDPROD_20110621_480_7.BAK And only see these two files:
- C-2169285856-20110527-03
- C-2169285856-20110527-04
It seems that this C-2169285856-.... files only were on 27/05/2011 and then no more.

However, the FULL_... and INCR_.. files are generated every day. The FULL is generated at the end of each month and INCR is generated every day.

This is the backfull.sql:
run {

        allocate channel c1 type disk maxpiecesize=4G;
        CROSSCHECK archivelog all;
        backup
         incremental level 0
         format '\\192.168.1.149\g$\XXXSRV4-arclogs\MTDPROD\RMAN\FULL_
%d_%T_%s_%p.bak'
         filesperset 8
         database include current controlfile;
        SQL 'alter system archive log current';
        backup
         format '\\192.168.1.149\g$\XXXSRV4-arclogs\MTDPROD\RMAN\ARC_
%d_%T_%s_%p.bak'
         archivelog all delete all input;
       }

This is the backincr.sql:

run {

        allocate channel c1 type disk maxpiecesize=4G;
        CROSSCHECK archivelog all;
        backup
         incremental level 1 cumulative
         format '\\192.168.1.149\g$\XXXSRV4-arclogs\MTDPROD\RMAN\INCR_
%d_%T_%s_%p.bak'
         filesperset 8
         database include current controlfile;
        SQL 'alter system archive log current';
        backup
          format '\\192.168.1.149\g$\XXXSRV4-arclogs\MTDPROD\RMAN\ARC_
%d_%T_%s_%p.bak'
          archivelog all delete all input;
       }

Received on Tue Jun 21 2011 - 15:29:13 CDT