Oracle Database Administration

Ref: http://youroracledba.wordpress.com/2012/11/23/rac-commands-srvctl-in-detail/ display the registered databases srvctl config database status srvctl status database -d <database srvctl status instance -d <database> -i <instance> srvctl status nodeapps -n <node> srvctl status service -d <database> 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> srvctl start instance -d <database> -i <instance>,<instance> srvctl start service -d <database> -s <service><service> -i <instance>,<instance> ...

Moving a datafile from a ASM disk group to another disk group and move database from one Disk group to another disk group This is for full database move. This will move all datafiles under ASM to a new disk group First place the database in mount mode SQL>startup mount; Then switch to RMAN ... RMAN> backup as copy database format '+NEW_DISC_GROUP' ; RMAN> switch database to copy ; SQL> alter database open; move the database from one disk group to another disk group 1. Backup the spfile and identify the spfile location, 2. start the database in mount mode SQL> select name from v$database; NAME --------- TEST SQL> select open_mode from V$database; OPEN_MODE ---------- MOUNTED connect RMAN  RMAN> connect target / connected to target database: TEST (DBID=1868766554, not open) RMAN> backup as copy database format '+FRA'; Starting backup at 07-APR-14 using target database control file instead of recovery catalo...

http://vijaydbacorner.blogspot.com.au/ http://select-star-from.blogspot.com.au/

Ref:http://select-star-from.blogspot.com.au/search/label/PATCHING Patch 13621679 - 11.1.0.7.11 Patch Set Update Patchset/PSU    Patch Number    Description 11.1.0.7.11    13621679    DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012) Patch 13621679 - 11.1.0.7.11 Patch Set Update ============================================= http://bbs.dbsupport.cn/thread-160-1-1.html Patch InformationPatch Set Update (PSU) patches are cumulative. That is, the content of all previous PSUs is included in the latest PSU patch. PSU 11.1.0.7.11 includes all fixes previously included in PSU 11.1.0.7.10 and those listed in . To install the PSU 11.1.0.7.11 patch, the Oracle home must have the 11.1.0.7.0 Database installed. Subsequent PSU patches can be installed on Oracle Database 11.1.0.7.0 or any PSU with a lower 5th numeral version than the one being installed. OPatch Utility ============== You must use the OPatch utility version 11.1.0.8.2...