DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Clone db and recreate controlfile errors

  1. #1
    Join Date
    Dec 2000
    Posts
    75
    Hi,

    I restored cold backup datafiles to a new database and then recreated controlfiles. However, I got a little bit of problem during the process. Then I shutdown db and tried to recreate the control files again, but Oracle generated more errors on system datafile needed recovery.

    SVRMGR> startup;
    ORACLE instance started.
    Total System Global Area 73374740 bytes
    Fixed Size 76820 bytes
    Variable Size 56348672 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes
    Database mounted.
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
    SVRMGR> alter database open resetlogs;
    alter database open resetlogs
    *
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: '/backup2/oradata/PS8DEV/system01.dbf'
    SVRMGR> recover database until cancel;
    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
    SVRMGR> recover database until cancel using BACKUP CONTROLFILE;
    ORA-00279: change 1008370 generated at 05/18/2001 10:20:54 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/product/8.1.7/dbs/arch/1_1.dbf
    ORA-00280: change 1008370 for thread 1 is in sequence #1
    Specify log: {=suggested | filename | AUTO | CANCEL}
    CANCEL
    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: '/backup2/oradata/PS8DEV/system01.dbf'
    goodhealth

  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    What kind of problem did you get after you created control file? It looks like you have inconsistent database backup.

    Sergey.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width