Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RMAN and RAC

Status
Not open for further replies.

diepa

Programmer
Dec 28, 1998
16
0
0
US
Hello,
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top