This discussion is archived
7 Replies Latest reply: Dec 3, 2012 5:01 AM by Sunny kichloo RSS

Which backupset has control file

951027 Newbie
Currently Being Moderated
Hello All,

I took an RMAN backup using

rman> backup database plus archivelog;

now i've deleted my oradata files,


when im trying to do restore control file

1) How do i know which file contains control file in the backup set .

2) When I tried to restore using all 6 files in this backupset it's giving me error

RMAN> RESTORE CONTROLFILE FROM '
2> E:\app\User\flash_recovery_area\orcl\BACKUPSET\2012_11_26\O1_MF_ANNNN_TAG201
21126T160306_8C6PMX3O_.BKP';

Starting restore at 03-DEC-12
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/03/2012 15:09:36
ORA-19870: error while restoring backup piece E:\APP\User\FLASH_RECOVERY_AREA\O
RCL\BACKUPSET\2012_11_26\O1_MF_ANNNN_TAG20121126T160306_8C6PMX3O_.BKP
ORA-19626: backup set type is archived log - can not be processed by this conver
sation


3) For one particular file its giving this error:


RMAN> RESTORE CONTROLFILE FROM 'E:\app\User\flash_recovery_area\orcl\BACKUPSET\
2012_11_26\O1_MF_NCSNF_TAG20121126T160404_8C6PR17J_.BKP';

Starting restore at 03-DEC-12
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/03/2012 15:12:28
ORA-19870: error while restoring backup piece E:\APP\User\FLASH_RECOVERY_AREA\O
RCL\BACKUPSET\2012_11_26\O1_MF_NCSNF_TAG20121126T160404_8C6PR17J_.BKP
ORA-19504: failed to create file "E:\APP\User\ORADATA\ORCL\CONTROL01.CTL"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
  • 1. Re: Which backupset has control file
    Sunny kichloo Expert
    Currently Being Moderated
    list backup command will help

    http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm#i1008733

    Also for error that you are getting is of backup-piece containing controlfile
    3) For one particular file its giving this error:
    
    RMAN> RESTORE CONTROLFILE FROM 'E:\app\User\flash_recovery_area\orcl\BACKUPSET\
    2012_11_26\O1_MF_NCSNF_TAG20121126T160404_8C6PR17J_.BKP';
    
    Starting restore at 03-DEC-12
    using channel ORA_DISK_1
    
    channel ORA_DISK_1: restoring control file
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 12/03/2012 15:12:28
    ORA-19870: error while restoring backup piece E:\APP\User\FLASH_RECOVERY_AREA\O
    RCL\BACKUPSET\2012_11_26\O1_MF_NCSNF_TAG20121126T160404_8C6PR17J_.BKP
    ORA-19504: failed to create file "E:\APP\User\ORADATA\ORCL\CONTROL01.CTL"
    ORA-27040: file create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    Have you checked on the permission of location E:\APP\User\ORADATA\ORCL\

    RMAN error
  • 2. Re: Which backupset has control file
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,
    ORA-19504: failed to create file "E:\APP\User\ORADATA\ORCL\CONTROL01.CTL"
    Make sure the path "E:\APP\User\ORADATA\ORCL" exists and is the correct path. RMAN is trying to restore the controlfile to the above path and it is not able to find it.

    Regarding the right backuppiece question, "O1_MF_NCSNF_TAG20121126T160404_8C6PR17J_.BKP" is the backuppiece which contains the controlfile backup.

    Regards,
    Shivananda
  • 3. Re: Which backupset has control file
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    The system cannot find the path

    ORA-27040: file create error, unable to create file
    Cause: create system call returned an error, unable to create file
    Action: verify filename, and permissions
  • 4. Re: Which backupset has control file
    951027 Newbie
    Currently Being Moderated
    list backup command doesn't return anything as database files have been delted
  • 5. Re: Which backupset has control file
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    948024 wrote:
    list backup command doesn't return anything as database files have been delted
    ORA-19504: failed to create file "E:\APP\User\ORADATA\ORCL\CONTROL01.CTL"
    ORA-27040: file create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.

    The error is clear and if you are trying to duplicate your database please refer to Oracle Document
  • 6. Re: Which backupset has control file
    951027 Newbie
    Currently Being Moderated
    ya actually ORCL folder was not there that's y it was unable to create the controlfile,

    I was crosschecking the recvovery folder and got confused

    Thanks guys

    bt still hw do we knw tis particular piece has controlfile
  • 7. Re: Which backupset has control file
    Sunny kichloo Expert
    Currently Being Moderated
    If you have RMAN Backup logs then from that you can know which backup-set contains Control files

Legend

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