Oracle Database 12c Release 2

Posted on by Osama Mustafa in News
Oracle Database 12c Release 2 is now available for Linux, Oracle Solaris SPARC, Oracle Solaris Intel 

To Download Just access here 

Published by Osama Mustafa

Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers. In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases. Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.

4 thoughts on “Oracle Database 12c Release 2”

  3. 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

    Reply

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Facebook photo

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

Cancel

Connecting to %s

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