Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Monday, August 30, 2010

Recreate SPFILE dropped accidently from ASM

Today we had a situation where user accidentally dropped the SPFILE from ASM diskgroup on RAC.

Since this is RAC we had the pfile pointing to ASM diskgroup not a physical file.

Method I used to retore the SPFILE.

RMAN> list backup of SPFILE;
List of Backup Pieces for backup set 11456205 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
11456219 1 AVAILABLE +DB_FRA_01/DBNAME/autobackup/2010_08_30/s_728389367.386.728389369

Backup Set Copy #2 of backup set 11456205
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
SBT_TAPE 00:00:01 08/30/2010 11:47:18 NO TAG20100830T102247

List of Backup Pieces for backup set 11456205 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
11458334 1 AVAILABLE 202210 c-3704148265-20100830-02


Above clearly shows we have the copy SPFILE in disk and in TAPE and I use the disk rather tape copy for restore.

RMAN> Restore spfile to ',location> from <+DB_FRA_01/DBNAME/autobackup/2010_08_30/s_728389367.386.728389369>;

Restore Complete

SQL> create pfile='/export/home/oracle/sshaik/shaik1.ora' from spfile='/export/home/oracle/sshaik/sshaik.ora';

File created.



SQL> create spfile='+DB_DATA_01/DBNAME/spfileaadp1.ora' from pfile='/export/home/oracle/sshaik/sshaik1.ora';

File created.


Now bounce the instance to see the new created SPFILE :-)

Thursday, August 19, 2010

RAC Best Practices

For RAC newbies and who are eager to know more about RAC and the best practices follow the below metalink doc.


RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) [ID 810394.1]

Configuring Diagwait & Miss count in 10g RAC

To set the diagwait in RAC:
1)shutdown RAC database if running
srvctl stop database -d
2) shutdown ASM if running
srvctl stop asm -n
login as root now:
3) shutdown crs
root@fwrkqrdb01cdp # /fwrk03/u0001/oracle/product/crs/bin/crsctl stop crs
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

root@# /fwrk03/u0001/oracle/product/crs/bin/crsctl get css diagwait
Configuration parameter diagwait is not defined.

root@fwrkqrdb01cdp # /fwrk03/u0001/oracle/product/crs/bin/crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly

root@fwrkqrdb01cdp # /fwrk03/u0001/oracle/product/crs/bin/crsctl set css diagwait 13 -force
Configuration parameter diagwait is now set to 13.
root@fwrkqrdb01cdp # /fwrk03/u0001/oracle/product/crs/bin/crsctl get css diagwait
13
root@fwrkqrdb01cdp #

Refer to the below doc for the latest:
10g RAC: Steps To Increase CSS Misscount, Reboottime and Disktimeout [ID 284752.1]
set css misscount
Misscount: Network Latencies in second from node-to-node (Interconnect)

root@fwrkqrdb01cdp # /fwrk03/u0001/oracle/product/crs/bin/crsctl set css misscount 45
Configuration parameter misscount is now set to 45.

fwrkqrdb02cdp(CRS) /export/home/oracle
>crsctl get css misscount
45