Installation/Configurations10g
CRS Administration
|
CRS Administration |
|
| starting | ## Starting CRS using Oracle 10g R1 not possible ## Starting CRS using Oracle 10g R2 $ORA_CRS_HOME/bin/crsctl start crs |
| stopping | ## Stopping CRS using Oracle 10g R1 srvctl stop database -d <database> srvctl stop asm -n <node> srvctl stop nodeapps -n <node> /etc/init.d/init.crs stop ## Stopping CRS using Oracle 10g R2 |
| disabling/enabling | ## use to stop CRS restarting after a reboot
## Oracle 10g R1 ## Oracle 10g R2 |
| checking | $ORA_CRS_HOME/bin/crsctl check crs $ORA_CRS_HOME/bin/crsctl check evmd $ORA_CRS_HOME/bin/crsctl check cssd $ORA_CRS_HOME/bin/crsctl check crsd $ORA_CRS_HOME/bin/crsctl check install -wait 600 |
|
Resource Applications (CRS Utilities) |
|
| status | $ORA_CRS_HOME/bin/crs_stat |
| create profile | $ORA_CRS_HOME/bin/crs_profile |
| register/unregister application | $ORA_CRS_HOME/bin/crs_register $ORA_CRS_HOME/bin/crs_unregister |
| Start/Stop an application | $ORA_CRS_HOME/bin/crs_start $ORA_CRS_HOME/bin/crs_stop |
| Resource permissions | $ORA_CRS_HOME/bin/crs_getparam $ORA_CRS_HOME/bin/crs_setparam |
| Relocate a resource | $ORA_CRS_HOME/bin/crs_relocate |
|
Nodes |
|
| member number/name | olsnodes -n |
| local node name | olsnodes -l |
| activates logging | olsnodes -g |
|
Oracle Interfaces |
|
| display | oifcfg getif |
| delete | oicfg delig -global |
| set | oicfg setif -global <interface name>/<subnet>:public oicfg setif -global <interface name>/<subnet>:cluster_interconnect |
|
Global Services Daemon Control |
|
| starting | gsdctl start |
| stopping | gsdctl stop |
| status | gsdctl status |
|
Cluster Configuration (clscfg is used during installation) |
|
| create a new configuration | clscfg -install |
| upgrade or downgrade and existing configuration | clscfg -upgrade clscfg -downgrade |
| add or delete a node from the configuration | clscfg -add clscfg -delete |
| create a special single-node configuration for ASM | clscfg -local |
| brief listing of terminology used in the other nodes | clscfg -concepts |
| used for tracing | clscfg -trace |
| help | clscfg -h |
|
Cluster Name Check |
|
| print cluster name | cemulto -n
Note: in Oracle 9i the ulity was called “cemutls” |
| print the clusterware version | cemulto -w
Note: in Oracle 9i the ulity was called “cemutls” |
|
Node Scripts |
|
| Add Node | addnode.sh
Note: see adding and deleting nodes |
| Delete Node | deletenode.sh
Note: see adding and deleting nodes |
|
En queues |
|
| displaying statistics | SQL> column current_utilization heading current SQL> column max_utilization heading max_usage SQL> column initial_allocation heading initial SQL> column resource_limit format a23; SQL> select * from v$resource_limit; |
|
Messaging (tickets) |
|
| ticket usage | select local_nid local, remote_nid remote, tckt_avail avail, tckt_limit limit, snd_q_len send_queue, tckt_wait waiting from v$ges_traffic_controller; |
| dump ticket information | SQL> oradebug setmypid SQL> oradebug unlimit SQL> oradebug lkdebug -t |
|
Lighwork Rule and Fairness Threshold |
|
| downconvert | select cr_requests, light_works, data_requests, fairness_down_converts from v$cr_block_server;
Note: lower the _fairness_threshold if the ratio goes above 40%, set to 0 if the instance is a query only instance. |
|
Remastering |
|
| force dynamic remastering (DRM) | ## Obtain the OBJECT_ID form the below table SQL> select * from v$gcspfmaster_info; ## Determine who masters it SQL> oradebug setmypid SQL> oradebug lkdebug -a <OBJECT_ID> ## Now remaster the resource |
|
GRD, SRVCTL, GSD and SRVCONFIG Tracing |
|
| Enable tracing | $ export SRVM_TRACE=true |
| Disable tracing | $ export SRVM_TRACE=”” |
How To Add Redo Logfiles In Standby Database
Step 1. First, Check MEMBER present in Standby Database.
SQL> select member from v$logfile;
MEMBER
———————————-
E:\STANDBYLOGS\REDO03.LOG
E:\STANDBYLOGS\REDO02.LOG
E:\STANDBYLOGS\REDO01.LOG
Step 2. Cancel the recovery Process.
SQL> alter database recover managed standby database cancel;
Step 3. Check the standby_file_management parameter and set the parameter to MANUAL.
SQL> show parameter standby_file_management
NAME TYPE VALUE
———————————— ———– ——
standby_file_management string AUTO
SQL> alter system set standby_file_management=manual scope=both;
SQL> show parameter standby_file_standby_file_management;
NAME TYPE VALUE
———————————— ———– ——
standby_file_management string MANUAL
Step 4. Add Redo Logfiles in Standby Database.
SQL> alter database add logfile group 4 ‘E:\STANDBYLOGS\REDO04.LOG’ size 250M;
SQL> alter database add logfile group 5 ‘E:\STANDBYLOGS\REDO05.LOG’ size 250M;
SQL> alter database add logfile group 6 ‘E:\STANDBYLOGS\REDO06.LOG’ size 250M;
SQL> alter database add standby logfile group 7 ‘E:\STANDBYLOGS\STDREDO07.LOG’ size 250M;
SQL> alter database add standby logfile group 8 ‘E:\STANDBYLOGS\STDREDO08.LOG’ size 250M;
SQL> alter database add standby logfile group 9 ‘E:\STANDBYLOGS\STdREDO09.LOG’ size 250M;
SQL> alter database add standby logfile group 10 ‘E:\STANDBYLOGS\STdREDO10.LOG’ size 250M;
Step 5. Check the Redo Logfiles.
SQL> col members for 999999999
SQL> set lines 120 pages 1000
SQL> select group#,members,status from v$log;
GROUP# MEMBERS STATUS
———- ———- —————-
1 1 CLEARING
2 1 CLEARING
3 1 CLEARING
4 1 UNUSED
5 1 CLEARING_CURRENT
6 1 UNUSED
SQL> select member from v$logfile;
MEMBER
————————
E:\STANDBYLOGS\REDO03.LOG
E:\STANDBYLOGS\REDO02.LOG
E:\STANDBYLOGS\REDO01.LOG
E:\STANDBYLOGS\REDO04.LOG
E:\STANDBYLOGS\REDO05.LOG
E:\STANDBYLOGS\REDO06.LOG
E:\STANDBYLOGS\STDREDO07.LOG
E:\STANDBYLOGS\STDREDO08.LOG
E:\STANDBYLOGS\STDREDO09.LOG
E:\STANDBYLOGS\STDREDO10.LOG
10 rows selected.
Step 6. Check the standby_file_management parameter and set the parameter to AUTO.
SQL> alter system set standby_file_management=auto scope=both;
Step 7. Finally, Activate the Recovery Process.
SQL> alter database recover managed standby database disconnect from session;
How To Drop Redo Logfiles on Physical Standby Database
Step 1. First, Cancel the Standby Recovery Process.
SQL> alter database recover managed standby database cancel;
Step 2. Check the standby_file_management parameter and set the parameter to MANUAL.
SQL> alter system set standby_file_management=manual scope=both;
Step 3. Check the status of the Logfiles Before Dropping them.
SQL> select group#,status from v$log;
GROUP# STATUS
———- —————-
1 CLEARING
2 CLEARING
3 CLEARING
4 UNUSED
5 CLEARING_CURRENT
6 UNUSED
6 rows selected.
NOTE: If the status is CLEARING or CURRENT_CLEARING or ACTIVE sync the logfiles with the primary. If you proceed without sync then the following error occurs.
SQL> alter database drop logfile group 1;
alter database drop logfile group 1
ERROR at line 1:
ORA-01156: recovery in progress may need access to files
3A. To sync the logfiles issue the following command.,
SQL> alter database clear logfile group 1;
SQL> alter database clear logfile group 2;
SQL> alter database clear logfile group 3;
3B. Check the status of the logfiles.
SQL> select group#, status from v$log;
GROUP# STATUS
———- —————-
1 UNUSED
2 UNUSED
3 UNUSED
4 UNUSED
5 CLEARING_CURRENT
6 UNUSED
6 rows selected.
3C. Drop the Logfiles accordingly.
SQL> alter database drop logfile group 1;
SQL> alter database drop logfile group 2;
SQL> alter database drop logfile group 3;
3D. Check the status of logfiles.
SQL> select group#, status from v$log;
GROUP# STATUS
———- —————-
4 UNUSED
5 CLEARING_CURRENT
6 UNUSED
SQL> select group#, members, status from v$log;
GROUP# MEMBERS STATUS
———- ———- —————-
4 1 UNUSED
5 1 CLEARING_CURRENT
6 1 UNUSED
Step 4. Check the standby_file_management parameter and set the parameter to AUTO.
SQL> alter system set standby_file_management=auto scope=both;
Step 5. Activate the Recovery Process.
SQL> alter database recover managed standby database disconnect from session;
RAC General Administration
Managing the Cluster |
|
| starting | /etc/init.d/init.crs start
crsctl start crs |
| stopping | /etc/init.d/init.crs stop
crsctl stop crs |
| enable/disable at boot time | /etc/init.d/init.crs enable /etc/init.d/init.crs disable crsctl enable crs |
Managing the database configuration with SRVCTL |
|
| start all instances | srvctl start database -d <database> -o <option>
Note: starts listeners if not already running, you can use the -o option to specify startup/shutdown options force |
| stop all instances | srvctl stop database -d <database> -o <option>
Note: the listeners are not stopped, you can use the -o option to specify startup/shutdown options immediate |
| start/stop particular instance | srvctl [start|stop] database -d <database> -i <instance>,<instance> |
| display the registered databases | srvctl config database |
| status | srvctl status database -d <database> srvctl status instance -d <database> -i <instance>,<instance> srvctl status service -d <database> srvctl status nodeapps -n <node> srvctl status asm -n <node> |
| stopping/starting | srvctl stop database -d <database> srvctl stop instance -d <database> -i <instance>,<instance> srvctl stop service -d <database> -s <service>,<service> -i <instance>,<instance> srvctl stop nodeapps -n <node> srvctl stop asm -n <node> srvctl start database -d <database> |
| adding/removing | srvctl add database -d <database> -o <oracle_home> srvctl add instance -d <database> -i <instance> -n <node> srvctl add service -d <database> -s <service> -r <preferred_list> srvctl add nodeapps -n <node> -o <oracle_home> -A <name|ip>/network srvctl add asm -n <node> -i <asm_instance> -o <oracle_home> srvctl remove database -d <database> -o <oracle_home> |
OCR utilities |
|
| log file | $ORA_HOME/log/<hostname>/client/ocrconfig_<pid>.log |
| checking | ocrcheck
Note: will return the OCR version, total space allocated, space used, free space, location of each device and the result of the integrity check |
| dump contents | ocrdump -backupfile <file>
Note: by default it dumps the contents into a file named OCRDUMP in the current directory |
| export/import | ocrconfig -export <file>
ocrconfig -restore <file> |
| backup/restore | # show backups ocrconfig -showbackup # to change the location of the backup, you can even specify a ASM disk # perform a backup, will use the location specified by the -backuploc location # perform a restore # delete a backup Note: there are many more option so see the ocrconfig man page |
| add/remove/replace | ## add/relocate the ocrmirror file to the specified location ocrconfig -replace ocrmirror ‘/ocfs2/ocr2.dbf’ ## relocate an existing OCR file ## remove the OCR or OCRMirror file |