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...
Oracle
6 min read
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
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...
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...
1 min read
Relocating enabl database for oracle 19c 1:- After the upgrade add this hosting members as below $GRID_HOME/bin/crsctl modify resource ora.enabl.db...
2 min read
Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time...
2 min read
Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown - rename to...
2 min read
This content is password protected. To view it please enter your password below: Password:
2 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:
