Errors
in file
/u01/app/oracle/diag/rdbms/standby_db/standby_db/trace/standby_db_lgwr_393229.trc:
ORA-00313:
open failed for members of log group 12 of thread 2
ORA-00312:
online log 12 thread 2: '+FRA_DG/standby_db/redolog12_02.rdo'
ORA-17503:
ksfdopn:2 Failed to open file +FRA_DG/standby_db /redolog12_02.rdo |
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Sunday, October 29, 2017
ORA-00313 ORA-00312 ORA-17503 ORA-15173 in Standby Alert Log File
Monday, October 23, 2017
Creating a Real Application Cluster(RAC) 12c database using DBCA
After installing Oracle RAC, next step is to create a RAC database. Following is the process of creating a RAC database using dbca. Same method works on Windows or Unix based platforms.To invoke dbca, open a command line and run command “dbca”. On Windows, DBCA can also be invoked from Program Menu..
Tuesday, October 10, 2017
Oracle Flex Cluster
Oracle Real
Application Cluster is a feature that was first introduced in Oracle 9i (Oracle
Parallel Servers was a similar feature available before 9i, but not as robust
as RAC) and has been an essential part of Oracle’s Maximum Availability
Architecture. Since its advent in Oracle 9i, it has evolved a lot. Oracle 9i onward,
every new release of Oracle has introduced something new in RAC which made it
even more resilient, fault tolerant, and easy to manage architecture.
Subscribe to:
Posts (Atom)
Popular Posts - All Times
-
Finding space usage of tablespaces and database is what many DBAs want to find. In this article I will explain how to find out space usage ...
-
If you want to know how we upgrade an 11g database to 12c using DBUA, click here . For upgrading 12.1.0.1 to 12.1.0.2 using DBUA, ...
-
This error means that you are trying to perform some operation in the database which requires encryption wallet to be open, but wallet is ...
-
By default AWR snapshot interval is set to 60 minutes and retention of snapshots is set to 8 days. For better and precise investigation of...
-
SWAP space recommendation from Oracle corp. for Oracle 11g Release 2 If RAM is between 1 GB and 2 GB, SAWP should be 1.5 times the s...
-
This article explains how to install a 2 nodes Oracle 12cR1 Real Application Cluster (RAC) on Oracle Linux 7. I did this installation on O...
-
In this post I will be demonstrating the steps to upgrade Oracle Grid Infrastructure (GI) 11g (11.2.0.4) to Grid Infrastructure 12c (12.1....
-
ORA-01653: unable to extend table <SCHEMA_NAME>.<SEGMENT_NAME> by 8192 in tablespace <TABLESPACE_NAME> This error is q...
-
It is quite common to see the error ORA-01624 while dropping a redo log group. The full error text is similar to “log <log_group#> n...
-
Error PRCR-1065 and CRS-2529 can be returned while stopping the ASM using srvctl command on Grid Infrastructure 11.2 and above as can be s...
