This discussion is archived
3 Replies Latest reply: Dec 26, 2012 7:52 PM by Shivananda Rao RSS

RMAN Not able to find Controlfile autobackup.

678298 Newbie
Currently Being Moderated
Hi All, I am trying to restore DB from one server to another using RMAN. I took backup of source DB and mounted backup location on Traget server.

I allready created requried directory and pfile on the target server. I am facing problem during restore controlfile from autobackup. Below is what I was trying on my target sever.

oracle@mpbdb:/backup/TEST> . oraenv
ORACLE_SID = [TEST] ?
The Oracle base remains unchanged with value /u01/app/oracle

rman target /


RMAN> startup nomount;

Oracle instance started

Total System Global Area 785227776 bytes

Fixed Size 2106616 bytes
Variable Size 201333512 bytes
Database Buffers 578813952 bytes
Redo Buffers 2973696 bytes


RMAN> set DBID 3194512843

RMAN> restore controlfile from autobackup;

Starting restore at 27-DEC-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=537 device type=DISK

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121227
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121226
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121225
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121224
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121223
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121222
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121221
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 12/27/2012 12:46:13
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


Here is RMAN setting on my target server for this unmounted database.

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default



-------------------------

Rman setting on source sever.

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/%d/controlfile_backup_%d_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/%d/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/dbs/snapcf_TEST1.f'; # default


Can you pleae give some idea why my target DB is not able to see controlfile autobackup.

My source and Target DB is 11.1.0.7 But my source DB is under ASM, and I am trying to migrate from ASM to NonASM.

Thanks
  • 1. Re: RMAN Not able to find Controlfile autobackup.
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,
    RMAN> set DBID 3194512843
    
    RMAN> restore controlfile from autobackup;
    
    Starting restore at 27-DEC-12
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=537 device type=DISK
    
    channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121227
    channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121226
    channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121225
    channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121224
    channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121223
    channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121222
    channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121221
    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 12/27/2012 12:46:13
    RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
    Restore the controlfile from the backup piece by specifying the entire path along with the backup piece name. RMAN backs up controlfile by default and would have it placed in the backup piece of system datafile.

    You can also refer this http://www.oracle-ckpt.com/restore-spfile-no-autobackup-found-rman-06172/


    Regards,
    Shivananda
  • 2. Re: RMAN Not able to find Controlfile autobackup.
    678298 Newbie
    Currently Being Moderated
    Hi Shivananda,

    I tried but got below error.

    RMAN-03002: failure of restore command at 12/27/2012 13:17:51
    RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

    Regards.
  • 3. Re: RMAN Not able to find Controlfile autobackup.
    Shivananda Rao Guru
    Currently Being Moderated
    Your source database has the controlfile autobackup set to a non-default location.
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/%d/controlfile_backup_%d_%F';
    Set the controlfile autobackup format on the target and try to restore it.

    Refer this http://waseemslearning.blogspot.com/2011/03/rman-06563-control-file-or-spfile-must.html

    Suppose on the target server, you have copied the controlfile autobackup to location "/u01/autobackup/", then on the target server do as:
    RMAN>run
    {
    set controlfile autobackup format for device type disk to '/u01/autobackup/%F';
    restore controlfile from autobackup;
    }
    Hope it helps !!

    Regards,
    Shivananda

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points