Thursday, December 15, 2016

Oracle Database 12c Release 2





4 comments:

  1. I am trying to recover the test database facing issue please help to to resolve the issue.


    SQL> recover database until cancel using backup controlfile;
    ORA-00279: change 28854617 generated at 03/25/2018 11:35:41 needed for thread 1
    ORA-00289: suggestion :
    /home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_
    1_1599_%u_.arc
    ORA-00280: change 28854617 for thread 1 is in sequence #1599


    Specify log: {=suggested | filename | AUTO | CANCEL}
    AUTO
    ORA-00308: cannot open archived log
    '/home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf
    _1_1599_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    ORA-00308: cannot open archived log
    '/home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf
    _1_1599_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01152: file 1 was not restored from a sufficiently old backup
    ORA-01110: data file 1:
    '/home/oracle/app/u01/oracle/oradata/ORCL/datafile/o1_mf_system_cjb7k1bh_.dbf'


    SQL> alter database datafile 1 offline drop;

    Database altered.

    SQL> recover database using backup controlfile ;
    ORA-00279: change 28854617 generated at 03/25/2018 11:35:41 needed for thread 1
    ORA-00289: suggestion :
    /home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_
    1_1599_%u_.arc
    ORA-00280: change 28854617 for thread 1 is in sequence #1599


    Specify log: {=suggested | filename | AUTO | CANCEL}
    AUTO
    ORA-00308: cannot open archived log
    '/home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf
    _1_1599_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    ORA-00308: cannot open archived log
    '/home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf
    _1_1599_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    SQL> ARCHIVE LOG LIST
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 1740
    Next log sequence to archive 1742
    Current log sequence 1742
    SQL> ALTER DATABASE OPEN;
    ALTER DATABASE OPEN
    *
    ERROR at line 1:
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


    SQL> ALTER DATABASE OPEN RESETLOGS;
    ALTER DATABASE OPEN RESETLOGS
    *
    ERROR at line 1:
    ORA-01245: offline file 1 will be lost if RESETLOGS is done
    ORA-01110: data file 1:
    '/home/oracle/app/u01/oracle/oradata/ORCL/datafile/o1_mf_system_cjb7k1bh_.dbf'


    SQL> alter database datafile '/home/oracle/app/u01/oracle/oradata/ORCL/datafile/o1_mf_system_cjb7k1bh_.dbf' ONLINE;

    Database altered.

    SQL> ALTER DATABASE OPEN RESETLOGS;
    ALTER DATABASE OPEN RESETLOGS
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1:
    '/home/oracle/app/u01/oracle/oradata/ORCL/datafile/o1_mf_system_cjb7k1bh_.dbf'


    SQL> recover database using backup controlfile ;
    ORA-00279: change 28854617 generated at 03/25/2018 11:35:41 needed for thread 1
    ORA-00289: suggestion :
    /home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_
    1_1599_%u_.arc
    ORA-00280: change 28854617 for thread 1 is in sequence #1599



    ReplyDelete