OracleDBs.com

crsctl check Usage: crsctl check crs Check status of OHAS and CRS stack crsctl check cluster [[-all]|[-n <server>[...]]] Check status of CRS stack crsctl check ctss Check status of Cluster Time Synchronization Services crsctl check resource {<resName> [...]|-w <filter>} [-n <server>] [-k <cid>] [-d...

DB_LOST_WRITE_PROTECT is a new initialization parameter seen starting Oracle 11g Release 1. This enables or disables lost write detection. A data block lost write occurs when an I/O subsystem acknowledges the completion of the block write, while in fact the write did not occur in the persistent stor...

The error found in RAC with Dataguard configuration. Version: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit From standby database alert log: Fri Oct 05 03:38:33 2012 Hex dump of (file 24, block 3556091) in trace file /appl/oracle/diag/rdbms/stbydb/stbydb1/trace/stbydb1_pr02_31923...

This scenario assumes the following: Two networked machines, dgprim and dgstan , are running Red Hat Enterprise Linux AS release 4 Oracle version 10.2.0.5.0 is installed on both machine. A media management subsystem is accessible by both machines specifically Symantec Veritas NetBackup The directory...

This topic covers the steps in creating a Build Standby Database Using RMAN Duplicate. Primary Database Name: RENZ Hostname: dgprim.localdomain db_unique_name: RENZ Standby Database Name: RENZ Hostname: dgstan.localdomain db_unique_name: DRAKE Oracle 10.2.0.5.0 Red Hat Enterprise Linux AS release 4 ...

This topic will guide you how to create a Dataguard Broker Configuration using DGMGRL. Assuming that you already have configured the Primary and Physical Standby databases. Primary Database: MANILA Physical Standby: GENSAN Version: 11.2.0.1.0 The following parameters needs to be setup on both primar...

Primary Database: MANILA Physical Standby: GENSAN Oracle Database Version: 11.2.0.1.0 Dataguard Broker Configuration: DGCONF Issue: When doing switchover to standby database via Dataguard Broker, an error below has been encountered: DGMGRL for Linux: Version 11.2.0.1.0 - Production Copyright (c) 200...

SQL> alter database drop logfile group 4; alter database drop logfile group 4 * ERROR at line 1: ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 4 thread 1: '/u02/flash_recovery_area/AUX11G/onlinelog/o1_mf_4_83kw72wh_.log' ORA-27037: unable to obtain file status L...

Starting Windows 7, you can Share An Internet Connection using Wireless Hosted Networking. The wireless Hosted Network feature in Windows 7 lets anyone with a supported Wi-Fi adapter and driver become a wireless Access Point for other Wi-Fi users, while also having the ability to connect to another ...

Drop an Index

The syntax for dropping an index is:

DROP INDEX index_name;

For example:

DROP INDEX idx_contact;

In this example, we're dropping an index called idx_contact.