10G Data Guard (09)

Thursday 07 August, 2008 - 11:01

Success (Almost)

I have managed to duplicate the example database onto the botany cluster using RMAN. The standby database has been registered to Grid Control.

However, I am having difficulty in getting Grid Control to manage the Standby configuration because of mismatched service names - the standby database has BOTANY.yaocm.id.au whereas Grid Control is expecting example2.yaocm.id.au.

The rough procedure is:

    • Replicate the directory structure for $ORACLE_BASE/admin/example/[abcu]dump on both nodes

    • Create the directory structure in ASM via ASMCMD mkdir command for:

      • +DATA/example

      • +DATA/BOTANY

      • +FRA/example

      • +FRA/BOTANY

    • Create a directory called /u00/backup on padstow2 and botany2 (these nodes have more disk space because the installation software was not loaded there)

    • Fiddle around with the listener configurations (need to clarify this in my next attempt)

    • Using RMAN on padstow2,

rman target / catalog rman@rmancat
backup validate database; /* checks integrity of database */
blockrecover corruption list; /* repairs any damaged blocks */
backup format="/u00/backup/%U.dbf" database;
backup format="/u00/backup/%U.dbf" current controlfile for standby;
sql "alter system switch logfile"; /* also done on padstow1 */
backup format="/u00/backup/%U.dbf" archivelog all; /* wrong order, but it works? */
sql "create pfile='/u00/backup/initexample2.ora' from spfile";
restore validate database; /* checks the integrity of the backup */
exit

    • Run the following command to copy the backup files to the physical standby site:

scp /u00/backup/* botany2:/u00/backup/

    • On botany2, update /etc/oratab with

example2:/u00/app/oracle/product/10.2.0/db_1:N

    • Run the following commands:

export ORACLE_HOME=/u00/app/oracle/product/10.2.0/db_1
export ORACLE_SID=example2
export PATH=$ORACLE_HOME/bin:$PATH # or I could use . oraenv

    • Update /u00/backup/initexample2.ora to:

      1. change the DB_UNIQUE_NAME to BOTANY

      2. add:

spfile='+DATA/example/spfileexample'

    • Run the following commands:

sqlplus / as sysdba
startup nomount pfile='/u00/backup/initexample2.ora'
create spfile='+DATA/example/spfileexample' from pfile='/u00/backup/initexample2.ora';
shutdown immediate
exit
rman target sys@padstow2 catalog rman@rmancat auxiliary /
startup clone nomount duplicate target database for standby dorecover;

    • ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

At this point, the standby database appears to be up and running.

To get Grid Control to recognise the new database, I had to open the database as read-only:

sqlplus / as sysdba
shutdown immediate
startup mount
alter database open read only;

Now the Grid Control is able to connect to the database and is thus able to be registered.