1 2 Previous Next 22 Replies Latest reply: Nov 19, 2012 4:24 PM by 975096 RSS

    ORA-01180: can not create datafile 1 during RMAN restore.

    martin.morono
      Hello,
      I am trying to refresh one of our QA environments and I am getting this error message:
      RMAN> run
      2> {
      3> allocate channel c1 device type disk;
      4> allocate channel c2 device type disk;
      5> restore database;
      6> recover database;
      7> }
      
      allocated channel: c1
      channel c1: SID=5 device type=DISK
      
      allocated channel: c2
      channel c2: SID=131 device type=DISK
      
      Starting restore at 08-NOV-12
      using channel ORA_DISK_1
      
      creating datafile file number=1 name=+DATA1/alephpr/datafile/system.269.722874729
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 11/08/2012 16:27:40
      ORA-01180: can not create datafile 1
      ORA-01110: data file 1: '+DATA1/alephpr/datafile/system.269.722874729' 
      I created a new database from scratch with the same name as is in Production, later on I will proceed to rename it to the right one. I started the steps for refreshing the PRD copy:
      RMAN> shutdown immediate
      
      using target database control file instead of recovery catalog
      database dismounted
      Oracle instance shut down
      
      RMAN> startup nomount
      
      connected to target database (not started)
      Oracle instance started
      
      Total System Global Area 534462464 bytes
      
      Fixed Size 2228200 bytes
      Variable Size 176160792 bytes
      Database Buffers 348127232 bytes
      Redo Buffers 7946240 bytes
      
      RMAN> set dbid=3573460394
      
      executing command: SET DBID
      
      RMAN> restore controlfile from '/restorealeph/c-3573460394-20121106-01';
      
      Starting restore at 08-NOV-12
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=130 device type=DISK
      
      channel ORA_DISK_1: restoring control file
      channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
      +output file name=+DATA1/alephpr/controlfile/current.260.798747585+
      +output file name=+FLASH/alephpr/controlfile/current.276.798747585+
      Finished restore at 08-NOV-12
      
      RMAN> alter database mount;
      
      database mounted
      released channel: ORA_DISK_1
      Once the control file is restored, I need to crosscheck, delete expired and catalog the backups at the new server:
      RMAN> crosscheck backup;
      
      ...
      Crosschecked 48 objects
      
      RMAN> delete noprompt expired backup;
      ...
      Deleted 48 EXPIRED objects
      
      RMAN> list backup summary;
      
      specification does not match any backup in the repository
      I need now to catalog the backups we transferred from Prod into the QA server's directory /restorealeph:
      RMAN> catalog start with '/restorealeph/';
      
      searching for all files that match the pattern /restorealeph/
      
      List of Files Unknown to the Database
      =====================================
      File Name: /restorealeph/9cnpm51u_1_1
      File Name: /restorealeph/9enpm6lj_1_1
      File Name: /restorealeph/c-3573460394-20121107-00
      File Name: /restorealeph/c-3573460394-20121107-01
      File Name: /restorealeph/c-3573460394-20121106-01
      
      Do you really want to catalog the above files (enter YES or NO)? YES
      cataloging files...
      cataloging done
      
      List of Cataloged Files
      =======================
      File Name: /restorealeph/9cnpm51u_1_1
      File Name: /restorealeph/9enpm6lj_1_1
      File Name: /restorealeph/c-3573460394-20121107-00
      File Name: /restorealeph/c-3573460394-20121107-01
      File Name: /restorealeph/c-3573460394-20121106-01
      
      RMAN> list backup summary;
      
      
      List of Backups
      ===============
      Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
      ------- -- -- - ----------- --------------- ------- ------- ---------- ---
      4097    B  F  A DISK        07-NOV-12       1       1       NO         BACKUP_ALEPHPR.TUR_110712030000
      4098    B  A  A DISK        07-NOV-12       1       1       NO         BACKUP_ALEPHPR.TUR_110712030000
      
      RMAN> list backup tag="BACKUP_ALEPHPR.TUR_110712030000";
      
      
      List of Backup Sets
      ===================
      
      
      BS Key  Type LV Size       Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      4097    Full    178.04G    DISK        00:00:00     07-NOV-12
              BP Key: 4097   Status: AVAILABLE  Compressed: NO  Tag: BACKUP_ALEPHPR.TUR_110712030000
              Piece Name: /restorealeph/9cnpm51u_1_1
        List of Datafiles in backup set 4097
        File LV Type Ckp SCN    Ckp Time  Name
        ---- -- ---- ---------- --------- ----
        1       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/system.269.722874729
        2       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/sysaux.266.722874731
        3       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs1.289.722874727
        4       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs2.257.722874727
        5       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/users.298.722874731
        6       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/audit.299.723372305
        7       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/case_datos.260.723372307
        8       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/case_indices.261.723372307
        9       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_hist.262.723372309
        10      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_l.264.723372319
        11      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_long.265.723372349
        12      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_md.270.723372355
        13      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_sm.271.723372369
        14      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_xl.272.723372375
        15      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_l.273.723372401
        16      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_md.274.723372427
        17      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_sm.275.723372455
        18      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_xl.276.723372473
        19      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/tools.278.723372501
        26      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_sm.300.736088959
        27      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_ptm5_meta.301.746385117
        28      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_pstore.302.746385119
        29      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_ptm5_cache.304.746385121
        30      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs1.305.796391931
        31      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs2.306.796392185
      
      BS Key  Size       Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      4098    16.89G     DISK        00:00:00     07-NOV-12
              BP Key: 4098   Status: AVAILABLE  Compressed: NO  Tag: BACKUP_ALEPHPR.TUR_110712030000
              Piece Name: /restorealeph/9enpm6lj_1_1
      
        List of Archived Logs in backup set 4098
        Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
        ---- ------- ---------- --------- ---------- ---------
        1    35722   6919870864350 06-NOV-12 6919871887697 06-NOV-12
        1    35723   6919871887697 06-NOV-12 6919872372211 06-NOV-12
        1    35724   6919872372211 06-NOV-12 6919872410158 06-NOV-12
        1    35725   6919872410158 06-NOV-12 6919872447301 06-NOV-12
        1    35726   6919872447301 06-NOV-12 6919872503332 06-NOV-12
        1    35727   6919872503332 06-NOV-12 6919872551564 06-NOV-12
        1    35728   6919872551564 06-NOV-12 6919872603881 06-NOV-12
        1    35729   6919872603881 06-NOV-12 6919872655942 06-NOV-12
        1    35730   6919872655942 06-NOV-12 6919872698722 06-NOV-12
        1    35731   6919872698722 06-NOV-12 6919872741655 06-NOV-12
        1    35732   6919872741655 06-NOV-12 6919872782284 06-NOV-12
        1    35733   6919872782284 06-NOV-12 6919872872302 06-NOV-12
        1    35734   6919872872302 06-NOV-12 6919872910206 06-NOV-12
        1    35735   6919872910206 06-NOV-12 6919872945577 06-NOV-12
        1    35736   6919872945577 06-NOV-12 6919872980056 06-NOV-12
        1    35737   6919872980056 06-NOV-12 6919873013411 06-NOV-12
        1    35738   6919873013411 06-NOV-12 6919873050761 06-NOV-12
        1    35739   6919873050761 06-NOV-12 6919873084996 06-NOV-12
        1    35740   6919873084996 06-NOV-12 6919873122049 06-NOV-12
        1    35741   6919873122049 06-NOV-12 6919873521767 06-NOV-12
        1    35742   6919873521767 06-NOV-12 6919873952773 06-NOV-12
        1    35743   6919873952773 06-NOV-12 6919874258549 06-NOV-12
        1    35744   6919874258549 06-NOV-12 6919874472213 06-NOV-12
        1    35745   6919874472213 06-NOV-12 6919874744856 06-NOV-12
        1    35746   6919874744856 06-NOV-12 6919875113086 06-NOV-12
        1    35747   6919875113086 06-NOV-12 6919875733337 06-NOV-12
        1    35748   6919875733337 06-NOV-12 6919876139061 06-NOV-12
        1    35749   6919876139061 06-NOV-12 6919876707162 06-NOV-12
        1    35750   6919876707162 06-NOV-12 6919877706313 06-NOV-12
        1    35751   6919877706313 06-NOV-12 6919877919039 06-NOV-12
        1    35752   6919877919039 06-NOV-12 6919878024429 06-NOV-12
        1    35753   6919878024429 06-NOV-12 6919878107673 06-NOV-12
        1    35754   6919878107673 06-NOV-12 6919878258511 06-NOV-12
        1    35755   6919878258511 06-NOV-12 6919878308336 06-NOV-12
        1    35756   6919878308336 06-NOV-12 6919878424419 06-NOV-12
        1    35757   6919878424419 06-NOV-12 6919878488485 06-NOV-12
        1    35758   6919878488485 06-NOV-12 6919878827092 06-NOV-12
        1    35759   6919878827092 06-NOV-12 6919879350098 07-NOV-12
        1    35760   6919879350098 07-NOV-12 6919879675556 07-NOV-12
        2    35949   6919870864360 06-NOV-12 6919871494640 06-NOV-12
        2    35950   6919871494640 06-NOV-12 6919871887487 06-NOV-12
        2    35951   6919871887487 06-NOV-12 6919872410655 06-NOV-12
        2    35952   6919872410655 06-NOV-12 6919872552468 06-NOV-12
        2    35953   6919872552468 06-NOV-12 6919872698940 06-NOV-12
        2    35954   6919872698940 06-NOV-12 6919872872690 06-NOV-12
        2    35955   6919872872690 06-NOV-12 6919872980371 06-NOV-12
        2    35956   6919872980371 06-NOV-12 6919873085902 06-NOV-12
        2    35957   6919873085902 06-NOV-12 6919873569082 06-NOV-12
        2    35958   6919873569082 06-NOV-12 6919873949096 06-NOV-12
        2    35959   6919873949096 06-NOV-12 6919874404640 06-NOV-12
        2    35960   6919874404640 06-NOV-12 6919875011814 06-NOV-12
        2    35961   6919875011814 06-NOV-12 6919875631429 06-NOV-12
        2    35962   6919875631429 06-NOV-12 6919876324885 06-NOV-12
        2    35963   6919876324885 06-NOV-12 6919876363526 06-NOV-12
        2    35964   6919876363526 06-NOV-12 6919876748508 06-NOV-12
        2    35965   6919876748508 06-NOV-12 6919877741784 06-NOV-12
        2    35966   6919877741784 06-NOV-12 6919878108943 06-NOV-12
        2    35967   6919878108943 06-NOV-12 6919878424477 06-NOV-12
        2    35968   6919878424477 06-NOV-12 6919879012111 06-NOV-12
        2    35969   6919879012111 06-NOV-12 6919879260589 07-NOV-12
        2    35970   6919879260589 07-NOV-12 6919879350086 07-NOV-12
        2    35971   6919879350086 07-NOV-12 6919879464935 07-NOV-12
        2    35972   6919879464935 07-NOV-12 6919879548399 07-NOV-12
        2    35973   6919879548399 07-NOV-12 6919879675564 07-NOV-12
      
        
      RMAN> list incarnation;
      
      
      List of Database Incarnations
      DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
      ------- ------- -------- ---------------- --- ---------- ----------
      1       1       ALEPHPR  3573460394       PARENT  1          13-MAY-10
      2       2       ALEPHPR  3573460394       PARENT  2229467    28-JUN-10
      3       3       ALEPHPR  3573460394       CURRENT 6918261828355 26-SEP-12
      The ASM structure is created...
      ASMCMD> lsdg
      State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
      MOUNTED EXTERN N 512 4096 1048576 509282 507421 0 507421 0 N DATA1/
      MOUNTED EXTERN N 512 4096 1048576 50641 42850 0 42850 0 N FLASH/
      ASMCMD> cd DATA1/ALEPHPR/DATAFILE
      ASMCMD> pwd
      +DATA1/ALEPHPR/DATAFILE
      Both source and target databases are 11.2.0.2 PSU 6 running on Linux x64. I cannot use RMAN Duplicate since there is no visibility among different environments (PROD - QA in this case).

      Any idea?

      Thanks

      Martin

      Edited by: martin.morono on Nov 8, 2012 11:19 AM

      Edited by: martin.morono on Nov 8, 2012 11:49 AM
        • 1. Re: ORA-01180: can not create datafile 1 during RMAN restore.
          mseberg
          Hello;

          What I think it is

          Use the "set newname for datafile/tablespace/database" with giving a new location.



          Things to check :

          it may be some directory permission issue.

          backups on new server in different location.

          SET UNTIL SCN/TIME is less than SCN/TIME of datafile backup

          status EXPIRED no FULL/LEVEL 0 backups AVAILABLE


          Would CATALOG the backups from proper location on the new server

          Best Regards

          mseberg

          Edited by: mseberg on Nov 8, 2012 1:27 PM
          • 2. Re: ORA-01180: can not create datafile 1 during RMAN restore.
            Levi Pereira
            ORA-01180: can not create datafile 1
            ORA-01110: data file 1: '+DATA1/alephpr/datafile/system.269.722874729' 
            Put here relevant info of alert_log of ASM and DB.

            Q1: Are you using same HOST (ASM) and DISKGROUP of PROD env?


            You can format text using tag
             at begin and end of output
            
            Edited by: Levi Pereira on Nov 8, 2012 5:42 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
            • 3. Re: ORA-01180: can not create datafile 1 during RMAN restore.
              martin.morono
              Thanks Levi

              These are the entries from Today in alert_+ASM.log file:
              Wed Nov 07 19:22:02 2012
              NOTE: client ALEPHPR:ALEPHPR registered, osid 32606, mbr 0x1
              NOTE: ASMB process exiting due to lack of ASM file activity for 5 seconds
              Thu Nov 08 13:17:13 2012
              NOTE: client ALEPHPR:ALEPHPR deregistered
              Thu Nov 08 13:17:32 2012
              Starting background process ASMB
              Thu Nov 08 13:17:32 2012
              ASMB started with pid=19, OS id=9354
              Thu Nov 08 13:17:32 2012
              NOTE: client +ASM:+ASM registered, osid 9356, mbr 0x0
              Thu Nov 08 13:17:34 2012
              NOTE: client ALEPHPR:ALEPHPR registered, osid 9399, mbr 0x1
              NOTE: ASMB process exiting due to lack of ASM file activity for 5 seconds
              It's not logging anything from the restore operation.

              No, I am not using the same host nor the same +ASM instance than in PROD but ASM paths and Diskgroup names are equals.

              Datafiles within backup set 4097 (each showing its original location at the +ASM production instance):
               List of Datafiles in backup set 4097
                File LV Type Ckp SCN    Ckp Time  Name
                ---- -- ---- ---------- --------- ----
                1       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/system.269.722874729
                2       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/sysaux.266.722874731
                3       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs1.289.722874727
                4       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs2.257.722874727
                5       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/users.298.722874731
                6       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/audit.299.723372305
                7       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/case_datos.260.723372307
                8       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/case_indices.261.723372307
                9       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_hist.262.723372309
                10      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_l.264.723372319
                11      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_long.265.723372349
                12      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_md.270.723372355
                13      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_sm.271.723372369
                14      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_xl.272.723372375
                15      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_l.273.723372401
                16      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_md.274.723372427
                17      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_sm.275.723372455
                18      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_xl.276.723372473
                19      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/tools.278.723372501
                26      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_sm.300.736088959
                27      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_ptm5_meta.301.746385117
                28      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_pstore.302.746385119
                29      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_ptm5_cache.304.746385121
                30      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs1.305.796391931
                31      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs2.306.796392185
              Data files within production ASM instance:
              ASMCMD> ls SYS*
              SYSAUX.266.722874731
              SYSTEM.269.722874729
              ASMCMD> pwd
              +DATA1/ALEPHPR/DATAFILE
              ASMCMD> !echo $ORACLE_SID
              +ASM1
              ASMCMD> !hostname
              dbprod1.mycompany.com
              And at QA:
              ASMCMD> pwd
              +DATA1/alephpr/datafile
              ASMCMD> ls SYS*
              SYSAUX.257.798747521
              SYSTEM.256.798747521
              ASMCMD> !echo $ORACLE_SID
              +ASM
              ASMCMD> !hostname
              qa01.mycompany.com
              ASMCMD>
              Any suggestion?
              • 4. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                Shivananda Rao
                Can you try out removing the directories you have manually created under the DATA1 diskgroup (/alephpr/datafile) and let RMAN handle it.
                Also, have you set the value of parameter "db_create_file_dest" on the QA database pfile ?

                Take a look at this
                http://shivanandarao.wordpress.com/2012/04/19/duplicating-primary-database-to-a-new-host-without-connecting-to-the-primary-database-in-oracle-10g11g/
                Here the auxiliary database uses the same diskgroup names as the production but on different server.
                This might help you out !!
                • 5. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                  martin.morono
                  Thanks mseberg.

                  It doesn't seem a permission issue. Datafiles are stored into an ASM instance and I had no issues to create the ALEPHPR database there.

                  Even though backups are stored on a different location at the QA server (/restorealeph) when their original location at PROD is (/home/oracle/bk), this should not be impacting the restore operation once I execute the CATALOG START WITH '<new_location_directory>'

                  The error pops up either if I include the SET UNTIL SEQ or not.

                  Status is A (Available) and LV (level) is Full.
                  RMAN> list backup summary;
                  
                  
                  List of Backups
                  ===============
                  Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
                  ------- -- -- - ----------- --------------- ------- ------- ---------- ---
                  4097    B  F  A DISK        07-NOV-12       1       1       NO         BACKUP_ALEPHPR.TUR_110712030000
                  4098    B  A  A DISK        07-NOV-12       1       1       NO         BACKUP_ALEPHPR.TUR_110712030000
                  Cataloging the backups from the new directory does not change anything.

                  Any other suggestion?

                  Edited by: martin.morono on Nov 8, 2012 12:59 PM
                  • 6. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                    mseberg
                    Its a simple test.

                    Try to restore just the system file ( number 1 ) and use "set newname"

                    It either works or it does not.

                    Best Regards

                    mseberg
                    • 7. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                      Levi Pereira
                      RMAN is trying create datafile 1 instead restore this file.
                      creating datafile file number=1 name=+DATA1/alephpr/datafile/system.269.722874729
                      RMAN-00571: ===========================================================
                      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                      RMAN-00571: ===========================================================
                      RMAN-03002: failure of restore command at 11/08/2012 16:27:40
                      ORA-01180: can not create datafile 1
                      ORA-01110: data file 1: '+DATA1/alephpr/datafile/system.269.722874729'
                      Try this note below, it cover same issue as your:
                      *THERE ARE AVAILABLE BACKUPS BUT RESTORE FAILS WITH RMAN-03002:ORA-01180: CAN NOT CREATE DATAFILE 1 [ID 727655.1]*

                      Edited by: Levi Pereira on Nov 8, 2012 7:11 PM
                      • 8. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                        martin.morono
                        Thanks Levi,
                        Sorry but that's not the problem. I included the incarnation information above in a previous post within this thread showing that there is no duplicate incarnation entry since reset SCN are differente among the entries:
                        RMAN> list incarnation;
                        
                        using target database control file instead of recovery catalog
                        
                        List of Database Incarnations
                        DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
                        ------- ------- -------- ---------------- --- ---------- ----------
                        1       1       ALEPHPR  3573460394       PARENT  1          13-MAY-10
                        2       2       ALEPHPR  3573460394       PARENT  2229467    28-JUN-10
                        3       3       ALEPHPR  3573460394       CURRENT 6918261828355 26-SEP-12
                        • 9. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                          martin.morono
                          Thanks for your help!

                          It didn't work either.
                          RMAN> run
                          2> {
                          3> allocate channel c1 device type disk;
                          4> set newname for datafile 1 to '+DATA1/alephpr/datafile/system.dbf';
                          5> restore datafile 1;
                          6> }
                          
                          allocated channel: c1
                          channel c1: SID=6 device type=DISK
                          
                          executing command: SET NEWNAME
                          
                          Starting restore at 09-NOV-12
                          
                          creating datafile file number=1 name=+DATA1/alephpr/datafile/system.dbf
                          released channel: c1
                          RMAN-00571: ===========================================================
                          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                          RMAN-00571: ===========================================================
                          RMAN-03002: failure of restore command at 11/09/2012 11:43:34
                          ORA-01180: can not create datafile 1
                          ORA-01110: data file 1: '+DATA1/alephpr/datafile/system.269.722874729'
                          • 10. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                            Shivananda Rao
                            With reference to my previous post on this thread
                            Can you try out removing the directories you have manually created under the DATA1 diskgroup (/alephpr/datafile) and let RMAN handle it.
                            Also, have you set the value of parameter "db_create_file_dest" on the QA database pfile ?
                            
                            Take a look at this 
                            http://shivanandarao.wordpress.com/2012/04/19/duplicating-primary-database-to-a-new-host-without-connecting-to-the-primary-database-in-oracle-10g11g/ 
                            Here the auxiliary database uses the same diskgroup names as the production but on different server.
                            This might help you out !!
                            Did you get in any chance to look at the above post ?
                            • 11. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                              Levi Pereira
                              Hi,

                              Try restore this controlfile "/restorealeph/c-3573460394-20121107-01"

                              Then issue:
                              RMAN>  run {
                                allocate channel c1 device type disk;
                                allocate channel c2 device type disk;
                                restore controlfile from '/restorealeph/c-3573460394-20121107-01';
                                startup mount;
                                restore database from tag 'BACKUP_ALEPHPR.TUR_110712030000';
                                }
                              • 12. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                                martin.morono
                                Sorry for my belated answer... I am now reading and going thru it. I reply you back soon.
                                • 13. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                                  martin.morono
                                  Thanks Levi,
                                  I slightly modified your script to recatalog the backup pieces since they are note stored at the same location in PR and QA.

                                  No luck. The error message is different but the result is the same... it keeps failing.
                                  RMAN> run {
                                  2> allocate channel c1 device type disk;
                                  3> allocate channel c2 device type disk;
                                  4> restore controlfile from '/restorealeph/c-3573460394-20121107-01';
                                  5> startup mount;
                                  6> catalog start with '/restorealeph/';
                                  7> restore database from tag 'BACKUP_ALEPHPR.TUR_110712030000';
                                  8> }
                                  
                                  allocated channel: c1
                                  channel c1: SID=191 device type=DISK
                                  
                                  allocated channel: c2
                                  channel c2: SID=131 device type=DISK
                                  
                                  Starting restore at 09 NOV 2012 13:11:09
                                  
                                  channel c2: skipped, AUTOBACKUP already found
                                  channel c1: restoring control file
                                  channel c1: restore complete, elapsed time: 00:00:15
                                  output file name=+DATA1/alephpr/controlfile/current.260.798747585
                                  output file name=+FLASH/alephpr/controlfile/current.276.798747585
                                  Finished restore at 09 NOV 2012 13:11:24
                                  
                                  database is already started
                                  database mounted
                                  
                                  Starting implicit crosscheck backup at 09 NOV 2012 13:11:31
                                  Crosschecked 52 objects
                                  Finished implicit crosscheck backup at 09 NOV 2012 13:11:39
                                  
                                  Starting implicit crosscheck copy at 09 NOV 2012 13:11:39
                                  Crosschecked 2 objects
                                  Finished implicit crosscheck copy at 09 NOV 2012 13:11:40
                                  
                                  searching for all files in the recovery area
                                  cataloging files...
                                  cataloging done
                                  
                                  List of Cataloged Files
                                  =======================
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_2_seq_1.279.795017193
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_2_seq_34950.273.795014469
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_1_seq_1.281.795017413
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_1_seq_2.283.795017519
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_1_seq_3.290.795018411
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_1_seq_4.291.795018559
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_1_seq_5.292.795018707
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_1_seq_6.293.795018811
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_1_seq_7.294.795018899
                                  File Name: +flash/ALEPHPR/ARCHIVELOG/2012_09_26/thread_1_seq_8.295.795020509
                                  File Name: +flash/ALEPHPR/CONTROLFILE/Current.268.798725123
                                  
                                  searching for all files that match the pattern /restorealeph/
                                  
                                  List of Files Unknown to the Database
                                  =====================================
                                  File Name: /restorealeph/9cnpm51u_1_1
                                  File Name: /restorealeph/9enpm6lj_1_1
                                  File Name: /restorealeph/c-3573460394-20121107-00
                                  File Name: /restorealeph/c-3573460394-20121107-01
                                  File Name: /restorealeph/c-3573460394-20121106-01
                                  
                                  Do you really want to catalog the above files (enter YES or NO)? YEs
                                  cataloging files...
                                  cataloging done
                                  
                                  List of Cataloged Files
                                  =======================
                                  File Name: /restorealeph/9cnpm51u_1_1
                                  File Name: /restorealeph/9enpm6lj_1_1
                                  File Name: /restorealeph/c-3573460394-20121107-00
                                  File Name: /restorealeph/c-3573460394-20121107-01
                                  File Name: /restorealeph/c-3573460394-20121106-01
                                  
                                  Starting restore at 09 NOV 2012 13:11:48
                                  
                                  released channel: c1
                                  released channel: c2
                                  RMAN-00571: ===========================================================
                                  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                                  RMAN-00571: ===========================================================
                                  RMAN-03002: failure of restore command at 11/09/2012 13:11:48
                                  RMAN-06026: some targets not found - aborting restore
                                  RMAN-06023: no backup or copy of datafile 31 found to restore
                                  RMAN-06023: no backup or copy of datafile 30 found to restore
                                  RMAN-06023: no backup or copy of datafile 29 found to restore
                                  RMAN-06023: no backup or copy of datafile 28 found to restore
                                  RMAN-06023: no backup or copy of datafile 27 found to restore
                                  RMAN-06023: no backup or copy of datafile 26 found to restore
                                  RMAN-06023: no backup or copy of datafile 19 found to restore
                                  RMAN-06023: no backup or copy of datafile 18 found to restore
                                  RMAN-06023: no backup or copy of datafile 17 found to restore
                                  RMAN-06023: no backup or copy of datafile 16 found to restore
                                  RMAN-06023: no backup or copy of datafile 15 found to restore
                                  RMAN-06023: no backup or copy of datafile 14 found to restore
                                  RMAN-06023: no backup or copy of datafile 13 found to restore
                                  RMAN-06023: no backup or copy of datafile 12 found to restore
                                  RMAN-06023: no backup or copy of datafile 11 found to restore
                                  RMAN-06023: no backup or copy of datafile 10 found to restore
                                  RMAN-06023: no backup or copy of datafile 9 found to restore
                                  RMAN-06023: no backup or copy of datafile 8 found to restore
                                  RMAN-06023: no backup or copy of datafile 7 found to restore
                                  RMAN-06023: no backup or copy of datafile 6 found to restore
                                  RMAN-06023: no backup or copy of datafile 5 found to restore
                                  RMAN-06023: no backup or copy of datafile 4 found to restore
                                  RMAN-06023: no backup or copy of datafile 3 found to restore
                                  RMAN-06023: no backup or copy of datafile 2 found to restore
                                  RMAN-06023: no backup or copy of datafile 1 found to restore
                                  
                                  RMAN>
                                  Just in case, I re-run this script including the crosscheck backup and the delete noprompt expired backups before restoring an the error messages were the same.

                                  THanks again for your help.

                                  Regards.

                                  Martin

                                  Edited by: martin.morono on Nov 9, 2012 7:21 AM
                                  • 14. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                                    Levi Pereira
                                    Hi,
                                    My guess: You are using oldest controlfile. Oracle is trying create a datafile 1 (system) instead restore it, but create datafile 1 (system) is NOT allowed if the file belongs to the SYSTEM tablespace.
                                    Orace is trying create this file because the backup tag 'BACKUP_ALEPHPR.TUR_110712030000' does not belong to current incarnation on controlfile.

                                    This is not ASM or RMAN issue, but CONTROLFILE issue.


                                    Are you using RMAN CATALOG?

                                    Restore only controlfile from '/restorealeph/c-3573460394-20121107-01', then mount database and issue query below using SQLPLUS.

                                    Put here output of:
                                     alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';
                                    
                                    set linesize 200
                                    
                                    select db.DBID,NAME,db.CREATED,db.CONTROLFILE_TIME, db.VERSION_TIME,dbinc.RESETLOGS_TIME, dbinc.PRIOR_RESETLOGS_TIME
                                    from v$database db, v$database_incarnation dbinc
                                    where dbinc.INCARNATION# = db.LAST_OPEN_INCARNATION#;
                                    RMAN restore fails with ORA-01180: can not create datafile 1 [ID 1265151.1]

                                    RMAN restore of database fails with ORA-01180: Cannot create datafile 1 [ID 392237.1]

                                    Edited by: Levi Pereira on Nov 9, 2012 2:27 PM
                                    1 2 Previous Next