Home » RDBMS Server » Backup & Recovery » RMAN and RAC
RMAN and RAC [message #189720] Fri, 25 August 2006 18:21 Go to next message
Diego Pafumi
Messages: 12
Registered: July 2004
Junior Member
I was reading a lot about RMAN but I have some questions about my configuration, I appreciate any help.
I'm using on Linux, RAC with 2 nodes. I setup another box to use RMAN.
My Flash Recovery Area is in my cluster and is located /u03/flash_recovery_area/OLTP4R/archivelog, there I'm archiving files from both nodes.

I'm trying to make my backups on another directory wich is NFS mounted: '/backup_oltp/'.

These are my RMAN settings:
configure retention policy to redundancy 3;
configure default device type to disk;
configure controlfile autobackup on;
configure device type disk parallelism 2;
configure controlfile autobackup format for device type disk to '/backup_oltp/%F';
configure snapshot controlfile name to '$ORACLE_HOME/dbs/snapcf_ORACLE_SID';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup_oltp/backup_db_%d_S_%s_P_%p_T_%t';
configure channel 1 device type disk connect 'SYS/redclust@oltp4r1';
configure channel 2 device type disk connect 'SYS/redclust@oltp4r2';

After I executed:
backup database plus archivelog tag="Full_Database";

I get the following files in each directory:
ls -latr /backup_oltp
-rw-r----- 1 oracle oinstall 18907136 Aug 25 2006 c-3939414311-20060825-00

ls -latr /u03/flash_recovery_area/OLTP4R/backupset/2006_08_25/
-rw-r----- 1 oracle oinstall 141458432 Aug 25 16:03 o1_mf_annnn_FULL_DATABASE_2gz0fhx4_.bkp
-rw-r----- 1 oracle oinstall 150778368 Aug 25 16:03 o1_mf_annnn_FULL_DATABASE_2gz0fhvj_.bkp
-rw-r----- 1 oracle oinstall 1238573056 Aug 25 16:04 o1_mf_nnndf_TAG20060825T160319_2gz0frkm_.bkp
-rw-r----- 1 oracle oinstall 1112940544 Aug 25 16:05 o1_mf_nnndf_TAG20060825T160319_2gz0j44n_.bkp
-rw-r----- 1 oracle oinstall 15475359744 Aug 25 16:16 o1_mf_nnndf_TAG20060825T160319_2gz0frl5_.bkp
drwxr-x--- 2 oracle oinstall 4096 Aug 25 16:16 .
-rw-r----- 1 oracle oinstall 667648 Aug 25 16:16 o1_mf_annnn_FULL_DATABASE_2gz15w4r_.bkp
-rw-r----- 1 oracle oinstall 564224 Aug 25 16:16 o1_mf_annnn_FULL_DATABASE_2gz15w58_.bkp

So here are my questions:
- Is my configuration correct? What about my RMAN parameters?
- I expected to see my backuped files on '/backup_oltp/', why they are not there?
- Can someone explain to me what are those files on each location?

Any help is appreciated
Re: RMAN and RAC [message #189748 is a reply to message #189720] Sat, 26 August 2006 07:15 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>- I expected to see my backuped files on '/backup_oltp/', why they are not there?
In your backup script, where did you instruct the RMAN to write the backupsets to /backup_oltp?
You have not! ( you have done only for controlfile).
One method is to include it in your channels.

... #Comment: connect to catalog and your target database
connect target xxx/xxx@xxx;
connect rcvcat xxx/xxx@xx;
#Comment: allocate channels as you want. Depends on your parllelism, available CPU etc.
# check documentation for more information.
allocate channel ch1 type disk format '/backup_direcotorty_you_want/file_format_you_want';
allocate channel ch2 type disk format '/backup_direcotorty_you_want/file_format_you_want';
backup database plus archivelog; #comment: use tags if you want
resync catalog;

>> Can someone explain to me what are those files on each location?
Already available in the documentation

>>Is my configuration correct? What about my RMAN parameters?
First please understand RAC mode here.
RMAN has no idea whether the database it is backing up is RAC or single instance.
It will treat the backup as if from single instance and will restore/duplicate only as single instance.
So make provisions to create the additional threads etc.
Look into the RAC documentation. There are clear guidelines.

Previous Topic: Please give me idea now I compile all branch data in head office only new record and modify record
Next Topic: RMAN execution fails with TNS:Lost contact
Goto Forum:

Current Time: Fri Mar 24 09:04:38 CDT 2017

Total time taken to generate the page: 0.17648 seconds