1 2 Previous Next 22 Replies Latest reply: Nov 19, 2012 4:24 PM by 975096 Go to original post RSS
      • 15. Re: ORA-01180: can not create datafile 1 during RMAN restore.
        Shivananda Rao
        Hello,

        I feel what Levi has mentioned is right. Can you do as :

        1. restore the controlfile from the backup piece which holds the SYSTEM datafile backup. Normally this backup would have the controlfile backup.
        RMAN>restore controlfile from '<backup piece which holds the SYSTEM datafile>';
        • 16. Re: ORA-01180: can not create datafile 1 during RMAN restore.
          martin.morono
          Thanks Shivananda Rao,
          I got issues while performing step 8:

          RMAN> startup nomount pfile='/u01/app/oracle/product/11.2.0.2/dbhome_1/dbs/initALEPHPR.ora';
          
          connected to target database (not started)
          RMAN-00571: ===========================================================
          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
          RMAN-00571: ===========================================================
          RMAN-03002: failure of startup command at 11/09/2012 16:13:27
          RMAN-04014: startup failed: ORA-01078: failure in processing system parameters
          RMAN-04017: startup error description: ORA-00439: feature not enabled: Real Application Clusters
          My production database (ALEPHPR) is a 2-Node RAC with two Stand by database. I don't have that infrastructure for QA, so I removed any reference to the DG configuracion and/or the other instance within the RAC,
          +ASM@argalephext01:/home/oracle>cat /u01/app/oracle/product/11.2.0.2/dbhome_1/dbs/initALEPHPR.ora
          #ALEPHPR1.__db_cache_size=13555990528
          #ALEPHPR1.__java_pool_size=134217728
          #ALEPHPR1.__large_pool_size=67108864
          ALEPHPR1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
          #ALEPHPR1.__pga_aggregate_target=8589934592
          #ALEPHPR1.__sga_target=16106127360
          #ALEPHPR1.__shared_io_pool_size=0
          #ALEPHPR1.__shared_pool_size=2147483648
          #ALEPHPR1.__streams_pool_size=67108864
          *.archive_lag_target=0
          *.audit_file_dest='/u01/app/oracle/admin/ALEPHPR/adump'
          *.audit_trail='DB_EXTENDED'
          *.cluster_database=true
          *.compatible='11.2.0.0.0'
          *.control_files='+DATA1/alephpr/control01.ctl','+FLASH/alephpr/control02.ctl'
          *.cursor_sharing='FORCE'
          *.db_block_size=8192
          *.db_create_file_dest='+DATA1'
          *.db_domain='turner.com'
          *.db_name='ALEPHPR'
          *.db_recovery_file_dest='+FLASH'
          *.db_recovery_file_dest_size=314572800000
          *.dg_broker_config_file1='+DATA1/alephpr/dr1alephpr.dat'
          *.dg_broker_config_file2='+FLASH/alephpr/dr2alephpr.dat'
          *.dg_broker_start=TRUE
          *.diagnostic_dest='/u01/app/oracle'
          *.dispatchers='(PROTOCOL=TCP) (SERVICE=ALEPHPRXDB)'
          *.event=''
          ALEPHPR1.instance_number=1
          *.job_queue_processes=1000
          *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
          *.log_archive_format='%t_%s_%r.dbf'
          ALEPHPR1.log_archive_format='%t_%s_%r.dbf'
          *.log_archive_max_processes=4
          *.log_archive_min_succeed_dest=1
          *.log_archive_trace=0
          ALEPHPR1.log_archive_trace=0
          *.memory_max_target=158662656
          *.memory_target=158662656
          *.open_cursors=300
          *.parallel_max_servers=160
          *.processes=1000
          *.remote_listener='argalephdbprod.mycompany.com:1530'
          *.remote_login_passwordfile='EXCLUSIVE'
          ALEPHPR1.resource_manager_plan='FORCE:'
          ALEPHPR2.resource_manager_plan='DEFAULT_PLAN'
          *.sessions=552
          *.sga_target=16106127360
          *.standby_file_management='AUTO'
          ALEPHPR1.thread=1
          ALEPHPR1.undo_tablespace='UNDOTBS1'
          *.utl_file_dir='/dir1','/dir2'
          Any suggestion?

          Thanks.

          Martin
          • 17. Re: ORA-01180: can not create datafile 1 during RMAN restore.
            Levi Pereira
            Hi,
            *.cluster_database=true
            *.remote_listener='argalephdbprod.mycompany.com:1530'
            Change parameter "cluster_database" to false and unset "remote_listener parameter".
            My production database (ALEPHPR) is a 2-Node RAC with two Stand by database. I don't have that infrastructure for QA, so I removed any reference to the DG configuracion and/or the other instance within the RAC,
            Are you restoring Backup taken from Standby database?

            If yes, assuming that the database is in recovery mode the controlfile and spfile MUST be backed up on the primary databases.

            Are you using backup of controlfile that was taken on primary database?
            • 18. Re: ORA-01180: can not create datafile 1 during RMAN restore.
              martin.morono
              Hello Levi,
              Thanks for your help.
              RMAN> shutdown immediate;
              
              database closed
              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-20121107-01';
              
              Starting restore at 09-NOV-12
              allocated channel: ORA_DISK_1
              channel ORA_DISK_1: SID=191 device type=DISK
              
              channel ORA_DISK_1: restoring control file
              channel ORA_DISK_1: restore complete, elapsed time: 00:00:10
              output file name=+DATA1/alephpr/controlfile/current.260.798914111
              output file name=+FLASH/alephpr/controlfile/current.284.798914111
              Finished restore at 09-NOV-12
              After restoring the controlfile you suggested, I mounted the DB and ran the query:
              SQL> alter database mount;
              
              Database altered.
              
              SQL> 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#;  2    3
              
                    DBID NAME      CREATED             CONTROLFILE_TIME    VERSION_TIME        RESETLOGS_TIME      PRIOR_RESETLOGS_TIM
              ---------- --------- ------------------- ------------------- ------------------- ------------------- -------------------
              3573460394 ALEPHPR   13-05-2010 14:31:06 07-11-2012 03:30:16 09-11-2012 17:02:07 28-06-2010 14:33:07 13-05-2010 14:31:06
              • 19. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                Levi Pereira
                Hi,

                ... and this query
                select CONTROLFILE_TYPE,CONTROLFILE_CONVERTED from v$database;
                • 20. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                  martin.morono
                  Levi,
                  both backups were taken from the Primary database. I'll change those parameter and try again the restore.

                  Thanks.
                  • 21. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                    martin.morono
                    Here it goes
                    SQL> select CONTROLFILE_TYPE,CONTROLFILE_CONVERTED from v$database;
                    
                    CONTROL CON
                    ------- ---
                    BACKUP  YES
                    
                    SQL>
                    • 22. Re: ORA-01180: can not create datafile 1 during RMAN restore.
                      975096
                      What you should remember when restoring to a different server from where the RMAN was taking is that if you are going to restore the database with the RMAn files in a different location from where they were dumped you will need to catalog the new location..catalog start with '/path of rman dumps'; so that this new location is registered in the control file and you can start you restore. Also keep in mind you will need to recreate control file if you plan to change the database name.
                      1 2 Previous Next