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

Thread: RECOVER DATABASE, RECOVER gave ORA-01547

  1. #1
    Join Date
    Jul 2010
    Posts
    2

    RECOVER DATABASE, RECOVER gave ORA-01547

    Hi,
    i'm triying to create a 10g database copy from another one in the same machine.. so this is what i done:

    1- i stop the database source and copy the directories used by the database source (redo , ctl,index..)
    2-i restart the database source and erase the ctl files from the new database directories.
    3-i ran :
    sqlplus "/ as sysdba"
    create database backup controlefile to trace ;

    4-i delete the cdump,bdump, udump files from the new database directory.

    5- i open the latest version of the trc file under udump of the database source and use the paragraph Set#2 . RESETLOGS until the end of the trc file ,to create the new database.
    so in this step , i used :

    STARTUP NOMOUNT
    CREATE CONTROLFILE SET DATABASE "R11110" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 30
    MAXINSTANCES 1
    MAXLOGHISTORY 584
    LOGFILE
    GROUP 1 (
    '/data01/oracle/r11110/redo1/redo1a.log',
    '/index01/oracle/r11110/redo2/redo1b.log'
    ) SIZE 50M,
    GROUP 2 (
    '/data01/oracle/r11110/redo1/redo2a.log',
    '/index01/oracle/r11110/redo2/redo2b.log'
    ) SIZE 50M,
    GROUP 3 (
    '/data01/oracle/r11110/redo1/redo3a.log',
    '/index01/oracle/r11110/redo2/redo3b.log'
    ) SIZE 50M
    -- STANDBY LOGFILE
    DATAFILE
    '/data01/oracle/r11110/data/SYSTEM01.dbf',
    '/data01/oracle/r11110/data/UNDO01.dbf',
    '/data01/oracle/r11110/data/SYSAUX01.dbf',
    '/data01/oracle/r11110/data/tbsfauser.dbf',
    '/data01/oracle/r11110/data/tbsfamsg.dbf',
    '/data01/oracle/r11110/data/tbsfauser1_1.dbf',
    '/data01/oracle/r11110/data/tbsfauser2_1.dbf',
    '/data01/oracle/r11110/data/tbsfauser3_1.dbf',
    '/data01/oracle/r11110/data/tbsfauser4_1.dbf',
    '/index01/oracle/r11110/index/tbsfaindx1_1.dbf',
    '/index01/oracle/r11110/index/tbsfaindx2_1.dbf',
    '/index01/oracle/r11110/index/tbsfaindx3_1.dbf',
    '/index01/oracle/r11110/index/tbsfaindx4_1.dbf',
    '/data01/oracle/r11110/data/tbsfaref.dbf',
    '/index01/oracle/r11110/index/tbsfaref.dbf',
    '/index01/oracle/r11110/index/tbsfvindx1_1.dbf',
    '/data01/oracle/r11110/data/tbsfvuser1_1.dbf'
    CHARACTER SET WE8ISO8859P15
    ;

    the controlefile was created successfully

    and then i tried :

    RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
    ORA-00279: change 7866782806751 generated at 07/12/2010 19:39:23 needed for thread 1
    ORA-00289: suggestion : /moteurs/oracle/r11110/R11110/archivelog/2010_07_13/o1_mf_1_1158_%u_.arc
    ORA-00280: change 7866782806751 for thread 1 is in sequence #1158


    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: '/data01/oracle/r11110/data/SYSTEM01.dbf'

    and then the command: ALTER DATABASE OPEN RESETLOGS; dose'nt work..

    Thanks for your help

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Copy archive logs

    Copy the archive logs from the source database starting with o1_mf_1_1158_%u_.arc into the /moteurs/oracle/r11110/R11110/archivelog/2010_07_13 directory and try the recover again.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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