To start the instance: # check status of instance $ $CRS_HOME/bin/crs_stat # seen cases when CRS says OFFLINE but pmon is still running so double checking here $ ps -ef | grep <instance_name> | grep pmon # start one of the instance on one of the nodes if not running $ srvctl start database -d … Continue reading How to start/stop an instance on a RAC?
Tag: RAC
How to migrate from single instance to RAC 10gR2
Move from single instance to RAC 1- Install CRS 2- Install new RDBMS binaries rac enable 3- Make sure there is enough space for the new online redo logs for new nodes 4- Make modifications to the pfile for RAC configuration 5- Add the listener configurations to tnsnames file in both nodes 6- Run rconfig … Continue reading How to migrate from single instance to RAC 10gR2
How to create a NetApp FlexClone RAC Database
In the past I used these procedures to create a FlexClone Oracle RAC database. Mainly for refreshing a data-warehouse from production. 1- Create pfile from spfile production create pfile='/home/oracle/create_clone/initCDWD.ora' from spfile; create pfile='/home/oracle/create_clone/initCDWQ.ora' from spfile; 2- Create backup control file to trace alter database backup controlfile to trace as '/home/oracle/backup_controlfile/ct_CDWP_resetlogs_151106.sql' resetlogs; (WE USE THIS ONE … Continue reading How to create a NetApp FlexClone RAC Database
alexlima.com 