Home » RDBMS Server » Backup & Recovery » Solaris x86 with Oracle RAC 10g Enterprise Edition Release 10.2.0.3.0
Solaris x86 with Oracle RAC 10g Enterprise Edition Release 10.2.0.3.0 [message #403971] Tue, 19 May 2009 22:59 Go to next message
alexberi
Messages: 16
Registered: May 2009
Junior Member
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';

14. $ rman target /
15. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO '/var/opt/oracle/flash_ recovery_area/ORCL/c_backup/% F';
16. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
17. RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
18. RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
19. 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
Re: Solaris x86 with Oracle RAC 10g Enterprise Edition Release 10.2.0.3.0 [message #403977 is a reply to message #403971] Tue, 19 May 2009 23:15 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
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?

It has to be in a shared area.
Instead of going through and maintaining a separate shared area,
I would just use ASM itself.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/rac006.htm#BHCBAFGF

Quote:
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.

No.
See above.

3) Is it possible/recommended to run RMAN from Node1 only?

It is most common way.
Nothing good or bad.
RMAN can backup from anywhere. No point in calling from both Nodes.
This way, you can even dedicate a node for rman jobs (parallelize etc). Just maintain an identical environment/scripts so that if Node 1 is down, you can continue to backup
from Node 2 also (with very minor changes).
Previous Topic: Incomplete recovery for truncate table situation
Next Topic: RMAN-06004: ORACLE error from recovery catalog database
Goto Forum:
  


Current Time: Fri Dec 09 00:04:20 CST 2016

Total time taken to generate the page: 0.14532 seconds