Friday, June 7, 2013

Manual Switchover in Databguard

Primary :
SQL>select switchover_status from v$database;
SQL>alter database commit to switchover to physical standby with session shutdown;
SQL>shutdown immediate
SQL>startup nomount
SQL>alter database mount standby database;
Standby :
SQL>select switchover_status from v$database;
SQL>alter database commit to switchover to primary;
SQL>shutdown immediate
SQL>startup
New standby:SQL>alter database recover managed standby database disconnect from session;

Wednesday, June 5, 2013

pre-upgrade check for GI home

Pre-upgrade check tool

Syntax : runcluvfy.sh stage -pre crsinst -upgrade [-n ] [-rolling] -src_crshome -dest_crshome -dest_version [-fixup [-fixupdir]] [-verbose]

For example, to upgrade a 3-node Oracle Clusterware in /u01/app/11.1 to 11.2.0.3 in /u01/app/grid in
rolling fashion, execute the following:
$ runcluvfy.sh stage -pre crsinst -upgrade -n ,, - rolling -src_crshome /u01/app/11.1 -dest_crshome /u01/app/grid -dest_version 11.2.0.3.0 -fixup -fixupdir /tmp -verbose