1 Reply Latest reply on Apr 17, 2013 5:42 PM by user9087711


      Hello everyone,

      I have a production database in which it is performed daily backups. From time to time i use to restore the backup from the production to a development database.

      I used to do it frequently and very easily with 2 simple Rman scripts (just below). I use Backup.rman at the production server and Recover.rman at the development server.
      Recently i needed to install a new development database server but now, when i try to restore the controlfile using the same scripts i get the RMAN-06172 error.
      I am confused because both databases have autobackup set to off.

      I saw some other articles about this error but with no clue about what is happening to me. Can anyone give me a tip about what i am doing wrong this time?

      Thanks in advance!

      Backup and recover scripts:


      delete noprompt archivelog until time 'SYSDATE-60';
      crosscheck backup;
      delete expired backup;

      allocate channel t1 type disk;
      backup AS COMPRESSED BACKUPSET format '/home/oracle/rman/database_%d_%Y%M%D_%s.bkp' database;
      backup AS COMPRESSED BACKUPSET format '/home/oracle/rman/arch_%d_%Y%M%D_%s.bkp' archivelog from time 'SYSDATE-3';
      backup AS COMPRESSED BACKUPSET format '/home/oracle/rman/controlfile_%d_%Y%M%D_%s.bkp' current controlfile;
      release channel t1;


      shutdown immediate;
      startup nomount;
      restore controlfile from '/home/oracle/rman/controlfile_MYDATABASE_20130417_256.bkp'; # Here and below i change the file location accordingly
      alter database mount;
      crosscheck backup;
      delete expired backup;
      CATALOG backuppiece '/home/oracle/rman/database_MYDATABASE_20130417_251.bkp';
      CATALOG backuppiece '/home/oracle/rman/database_MYDATABASE_20130417_252.bkp';
      CATALOG backuppiece '/home/oracle/rman/arch_MYDATABASE_20130417_253.bkp';
      CATALOG backuppiece '/home/oracle/rman/arch_MYDATABASE_20130417_254.bkp';
      CATALOG backuppiece '/home/oracle/rman/arch_MYDATABASE_20130417_255.bkp';
      restore database;
      recover database;
      alter database open resetlogs;

      Here is a piece of the output:

      using target database control file instead of recovery catalog
      Oracle instance shut down

      connected to target database (not started)
      Oracle instance started

      Total System Global Area 11992252416 bytes

      Fixed Size 2239336 bytes
      Variable Size 3590325400 bytes
      Database Buffers 8388608000 bytes
      Redo Buffers 11079680 bytes

      Starting restore at 17-APR-13
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=258 device type=DISK

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 04/17/2013 09:43:25
      RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

      Edited by: user9087711 on 17/04/2013 08:55