Home » RDBMS Server » Backup & Recovery » Daily database backup runnig on RAC 10.2.0.3 with two Solaris nodes & ASM (Oracle RAC, 10.2.0.3, Solaris)
Daily database backup runnig on RAC 10.2.0.3 with two Solaris nodes & ASM [message #407568] Wed, 10 June 2009 09:52 Go to next message
alexberi
Messages: 16
Registered: May 2009
Junior Member
Hello,

I'm confused about making daily incremental RMAN backup of a database runnig on Oracle RAC 10.2.0.3 on two Solaris nodes and ASM.
Databases cannot be stopped for backup and point in time recovery is needed.
Please correct me if I am doing wrong:
1) Backup must be Weekly database Level 0 and Daily database Level 1 is appropriate.
2) Is best to use a Flash Recovery Area (FRA) - I've setup one on a separate ASM volume. I have enough space to do the backup on FRA.
3) I am confused about the number channels I need to use. Do I need to use separate RMAN backup channels for each node or I can just leave the default:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
4) Below are the RMAN scripts I plan to use for

- Weekly database backup Level 0:
#!/usr/bin/ksh
echo BACKUP FULL: $ORACLE_HOME/bin/rman target / nocatalog log ${LOGFILE} append
$ORACLE_HOME/bin/rman target / nocatalog log ${LOGFILE} append << eof
run {
backup incremental level 0 database TAG bkp_level0_200906010;
SQL 'alter system archive log current';
backup archivelog all;
delete noprompt obsolete;
}
exit;
eof

- Daily database backup Level 1:
#!/usr/bin/ksh
echo BACKUP INCREMENTAL: $ORACLE_HOME/bin/rman target / nocatalog log ${LOGFILE} append
$ORACLE_HOME/bin/rman target / nocatalog log ${LOGFILE} append << eof
run {
backup incremental level 1 database TAG bkp_level1_20090611;
SQL 'alter system archive log current';
backup archivelog all;
delete noprompt obsolete;
}
exit;
eof

I'm I doing things wrong?
Re: Daily database backup runnig on RAC 10.2.0.3 with two Solaris nodes & ASM [message #407571 is a reply to message #407568] Wed, 10 June 2009 09:56 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>I'm I doing things wrong?
I do not see any error.
Re: Daily database backup runnig on RAC 10.2.0.3 with two Solaris nodes & ASM [message #407603 is a reply to message #407571] Wed, 10 June 2009 11:46 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Yes. Your backup script & logic is correct. Then gohead to implement ..

Babu
Re: Daily database backup runnig on RAC 10.2.0.3 with two Solaris nodes & ASM [message #407615 is a reply to message #407568] Wed, 10 June 2009 13:15 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you really want to do this right, you should schedule this thru DBMS_SCHEDULER and have a connection (channel) to each node to parallelize the backup.
Previous Topic: ORA-01092 Oracle instance terminated, disconnection forced (merged)
Next Topic: offline
Goto Forum:
  


Current Time: Tue Dec 06 04:53:31 CST 2016

Total time taken to generate the page: 0.10166 seconds