This discussion is archived
1 2 Previous Next 22 Replies Latest reply: Nov 19, 2012 2:24 PM by 975096 Go to original post RSS
  • 15. Re: ORA-01180: can not create datafile 1 during RMAN restore.
    Shivananda Rao Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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