Hayat Kurtaran Komutlar – 6

Oracle RAC’te veritabanının crs tarafından otomatik olarak açılıp açılmadığının kontrol için aşağıdaki komut kullanılabilir.
Komut çıktısında,
POLICY:  manual
olarak görülüyor ise, bu durumda veritabanının crs tarafından otomatik başlatılmayacağından emin olunabilir.

 

-bash-3.00$ srvctl config database -d DBNAME -a
rachost1 DBNAME1 /u01/app/oracle/product/10.2.0/db_1
rachost2 DBNAME2 /u01/app/oracle/product/10.2.0/db_1
DB_UNIQUE_NAME: DBNAME
DB_NAME: DBNAME
ORACLE_HOME: /u01/app/oracle/product/10.2.0/db_1
SPFILE: null
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null
POLICY:  manual
ENABLE FLAG: DB ENABLED

 

Special Thanks to Hakan 🙂

 

srvctl usage:

Use the srvctl add database command with the following syntax:

srvctl add database -d db_unique_name -o oracle_home [-m domain_name]

[-n db_name] [-p spfile] [-s start_options] [-t stop_options]

[-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}]

[-y {automatic | manual}] [-a disk_group_list]

Table 4-11 srvctl add database Options

Syntax	Description
-d db_unique_name	Unique name for the database. Must match the DB_UNIQUE_NAME initialization parameter setting. If DB_UNIQUE_NAME is unspecified, then this option must match the DB_NAME initialization parameter setting. The default setting for DB_UNIQUE_NAME uses the setting for DB_NAME.
-o Oracle_home	The full path of Oracle home for the database.
-m domain_name	The domain for the database. Must match the DB_DOMAIN initialization parameter
-n db_name	If provided, must match the DB_NAME initialization parameter setting. You must include this option if DB_NAME is different from the unique name given by the -d option
-p spfile	The full path of the server parameter file for the database. If omitted, the default SPFILE is used.
-s start_options	Startup options for the database (OPEN, MOUNT, or NOMOUNT). If omitted, defaults to OPEN.
-t stop_options	Shutdown options for the database (NORMAL, IMMEDIATE, TRANSACTIONAL, or ABORT). If omitted, defaults to IMMEDIATE.
-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}	The current role of the database (PRIMARY, PHYSICAL_STANDBY, SNAPSHOT_STANDBY, or LOGICAL_STANDBY). Applicable in Oracle Data Guard environments only.
-y {AUTOMATIC | MANUAL}	Management policy for the database. If AUTOMATIC (the default), the database is automatically restored to its previous running condition (started or stopped) upon restart of the database host computer. If MANUAL, the database is never automatically restarted upon restart of the database host computer. A MANUAL setting does not prevent Oracle Restart from monitoring the database while it is running and restarting it if a failure occurs.
-a disk_group_list	List of disk groups upon which the database is dependent. When starting the database, Oracle Restart first ensures that these disk groups are mounted. This option is required only if the database instance and the Oracle ASM instance are not started when adding the database. Otherwise, the dependency is recorded automatically between the database and its disk groups.