27 min read
1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11 we need to install the...
asrblogger
27 min read
6 min read
As an “Oracle DBA ” normally interviewer ask about ORA-01555 snapshot too old error. What is Undo? Oracle Database maintain information that is used...
7 min read
Source Database Name is PRODDB Target (duplicate) Database name is MYDB Source Host Name : server1.localdomain Target Host Name : server2.localdomain...
6 min read
Check the status of ASM instance . SQL> SELECT INSTANCE_NAME,VERSION,STATUS FROM V$INSTANCE; INSTANCE_NAME VERSION STATUS ------------- -------- ---------------- +ASM 12.1.0.2.0 STARTED...
13 min read
This content is password protected. To view it please enter your password below: Password:
2 min read
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done...
3 min read
This content is password protected. To view it please enter your password below: Password:
This content is password protected. To view it please enter your password below: Password:
1 min read
vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh #!/bin/ksh export ORACLE_SID=<Target_ORACLE_SID> export ORACLE_HOME=/u01/oracle/product/11.2.0.4/db /u01/oracle/product/11.2.0.4/db/bin/sqlplus -s / as sysdba << NACHO > /tmp/standbylag.log set feedback off select...
3 min read
Add the Target Database TNS entry to the Source's tnsnames.ora file(s) (all of them if it's a clustered Source) Set...
1 min read
On Source, as Oracle user: export ORACLE_SID=<source_sid> sqlplus '/as sysdba' alter system set log_archive_dest_state_<whatever_#_used>='DEFER' scope=both sid='*'; alter system set log_archive_dest_<whatever_#_used>=''...
Overview:As we are already aware that the rolling forward an physical standby database via an incremental SCN based backup method is one of the easiest way of getting your standby database with lag into sync with the primary database.The lag...
5 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
INFO INFO MANAGER Provides details of the Manager process INFO MGR Also provides details of the Manager process STATUS MANAGER...
3 min read
What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. The block...
5 min read
Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t...
4 min read
RMAN recovery catalog is separate DB/ Server and which will save only the details of your backups in terms of...
9 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
The ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query. ROW_NUMBER is an analytic function....
2 min read
OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can...
8 min read
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats....
9 min read
Check the status of the cluster $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready...
4 min read
1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To...
The Data Buffer Hit Ratio Oracle metric is a measure of the effectiveness of the Oracle data block buffer. The higher the...
