This content is password protected. To view it please enter your password below: Password:
Year: 2022
1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11 we need to install the...
As an “Oracle DBA ” normally interviewer ask about ORA-01555 snapshot too old error. What is Undo? Oracle Database maintain information that is used...
Source Database Name is PRODDB Target (duplicate) Database name is MYDB Source Host Name : server1.localdomain Target Host Name : server2.localdomain...
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...
This content is password protected. To view it please enter your password below: Password:
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done...
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:
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:
This content is password protected. To view it please enter your password below: Password:
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...
This content is password protected. To view it please enter your password below: Password:
INFO INFO MANAGER Provides details of the Manager process INFO MGR Also provides details of the Manager process STATUS MANAGER...
What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. The block...
Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t...
RMAN recovery catalog is separate DB/ Server and which will save only the details of your backups in terms of...
The ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query. ROW_NUMBER is an analytic function....
PROBLEM: When DGMGRL is used to create DG broker configuration it fails with below error : DGMGRL> connect sys Password:...
OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can...
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats....
Check the status of the cluster $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready...
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...