-
RMAN backup
Hi Friends,
Oracle 8.1.7.4, solaris 2.7
I am doing a backup using RMAN with multiple channels and filesperset 2.
Total no of datafiles to be backed are 56.Each datafiles are 1GB of size.Once the backup was over successfully, the total no. of files in the backup drive was only 30.Some backup files were 2 GB in size.
Is this a norman process, if yes then during restore will RMAN identifiy these as two seperate files and do the recovery, please help me in understanding.
This is the backup script
run {
allocate channel d1 type disk format='/disk/bckup/db_t%t_s%s_p%p';
allocate channel d2 type disk format='/disk/bckup/db_t%t_s%s_p%p';
allocate channel d3 type disk format='/disk/bckup/db_t%t_s%s_p%p';
allocate channel d4 type disk format='/disk/bckup/db_t%t_s%s_p%p';
set maxcorrupt for datafile
212,1,2,3,4,5,6,7,8,9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35
, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53 to 100;
backup (datafile 212,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 3
4, 35 , 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53 filesperset 2);
release channel d4;
release channel d3;
release channel d2;
release channel d1;
regards
anandkl
Last edited by anandkl; 01-08-2004 at 06:33 AM.
anandkl
-
How many channels are you allocating?
Don't compare size of your datafiles to the RMAN backup files. RMAN backs-up only used blocks. As long as RMAN doean't give any error you should be safe BUT again doing a test restore-recover is always recommended.
HTH
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Hi Sanjay,
As u can see the script, i am allocating 4 channels.
anandkl
-
You need not worry about no. of backup pieces. RMAN calculates it internally based on no. of channels parallaly backing-up and filesperset.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|