Using RMAN on two node Solaris x86 with Oracle RAC 10g Enterprise Edition Release 10.2.0.3.0

From: <alex.berindei_at_gmail.com>
Date: Tue, 19 May 2009 15:07:18 -0700 (PDT)
Message-ID: <b3517576-8e46-4027-a969-ae67d60548fb_at_l32g2000vba.googlegroups.com>

Hello,

Maybe you can help me (new on RMAN backup) in doing this.

I have configured a single Oracle 10g database to have backup with RMAN with following steps:

1.  $ mkdir $ORACLE_BASE/rman_scripts
2.  $ mkdir $ORACLE_BASE/logs
3.  $ mkdir $ORACLE_BASE/tracking
4.  $ mkdir $ORACLE_BASE/c_backup
5.  $ sqlplus sys/<password> as sysdba
6.  SQL> alter system set db_recovery_file_dest_size = 50G

scope=both;
7. SQL> alter system set db_recovery_file_dest='${ ORACLE_BASE}/ flash_recovery_ area' scope=both;
8. SQL> alter system set log_archive_dest_10='location= use_db_recovery_file_dest';
9. SQL> shutdown immediate

10. SQL> startup nomount
11. SQL> alter database archivelog;
12. SQL> alter database open;
13. SQL> alter database enable block change tracking using file '$

{ORACLE_BASE}/tracking/rman_ change_track.f';

1. $ rman target /
2. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/var/opt/oracle/flash_ recovery_area/ORCL/c_backup/% F';
3. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
4. RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
5. RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
6. RMAN> exit

I need to configure incremental backup with RMAN on a two node Solaris x86 with Oracle RAC 10g Enterprise Edition Release 10.2.0.3.0 installation.
We also use ASM to store database files, and have Oracle software installed on separate file systems (two Oracle roots for Node1 and Node2).

I have following questions:
1) where to put Flash Recovery Area (FRA)? I saw recommendations to put FRA on the ASM, is this the best way to do it?
2) Can I put FRA on another file system (not on the ASM) which is available only from Node1? This way I can save space on the ASM. 3) Is it possible/recommended to run RMAN from Node1 only?

Below is the script used to run RMAN on the normal Oracle database (without RAC) which I need to change :

---

2.0 Oracle backup script: /opt/app/oracle/rman_scripts/backup.sh

    Use this for daily backups, possiblly as a cron job.

    Once a week run this: /opt/app/oracle/rman_scripts/ backup.sh FULL

    All other days of the week: /opt/app/oracle/rman_scripts/ backup.sh INCREMENTAL

    Note: You may have to change ORACLE_SID, ORACLE_BASE below to match your database.

---

#!/usr/bin/ksh

ORACLE_SID=orcl
ORACLE_BASE=/opt/app/oracle

ORACLE_HOME=${ORACLE_BASE}/product/10.2.0/db_1 PATH=${ORACLE_HOME}/bin:/usr/bin
LOGDIR=${ORACLE_BASE}/logs
LOGFILE=${LOGDIR}/rman.log

if [[ $# < 1 ]]
then

    echo "usage: backup.sh FULL|INCREMENTAL"     exit;
fi

BACKUPTYPE=${1}
full='FULL'
incremental='INCREMENTAL'

if [[ $BACKUPTYPE == $full ]]
then
$ORACLE_HOME/bin/rman target / nocatalog log ${LOGFILE} append << eof
run {
backup database;
SQL 'alter system archive log current';
backup archivelog all;
delete noprompt obsolete;
}
exit;
eof
echo ''
fi

if [[ $BACKUPTYPE == $incremental ]]
then
$ORACLE_HOME/bin/rman target / nocatalog log ${LOGFILE} append << eof
run {
backup database;
backup incremental level 1 database;
SQL 'alter system archive log current';
backup archivelog all;
delete noprompt obsolete;
}
exit;
eof
echo ''
fi Received on Tue May 19 2009 - 17:07:18 CDT