Oracle Database 12c Release 2

Oracle Database 12c Release 2 is now available for Linux, Oracle Solaris SPARC, Oracle Solaris Intel 

To Download Just access here 

4 thoughts on “Oracle Database 12c Release 2

  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 1ORA-00289: suggestion :/home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_1599_%u_.arcORA-00280: change 28854617 for thread 1 is in sequence #1599Specify log: {=suggested | filename | AUTO | CANCEL}AUTOORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01152: file 1 was not restored from a sufficiently old backupORA-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 1ORA-00289: suggestion :/home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_1599_%u_.arcORA-00280: change 28854617 for thread 1 is in sequence #1599Specify log: {=suggested | filename | AUTO | CANCEL}AUTOORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-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 statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3SQL> ARCHIVE LOG LISTDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 1740Next log sequence to archive 1742Current log sequence 1742SQL> ALTER DATABASE OPEN;ALTER DATABASE OPEN*ERROR at line 1:ORA-01589: must use RESETLOGS or NORESETLOGS option for database openSQL> ALTER DATABASE OPEN RESETLOGS;ALTER DATABASE OPEN RESETLOGS*ERROR at line 1:ORA-01245: offline file 1 will be lost if RESETLOGS is doneORA-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 recoveryORA-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 1ORA-00289: suggestion :/home/oracle/app/u01/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_1599_%u_.arcORA-00280: change 28854617 for thread 1 is in sequence #1599

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.