|RMAN and RAC [message #189720]
||Fri, 25 August 2006 18:21
Registered: July 2004
I was reading a lot about RMAN but I have some questions about my configuration, I appreciate any help.
I'm using 10.2.0.1 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
Registered: March 2002
>>- 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
>> 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.