| RMAN Backup for 10g [message #152943] |
Wed, 28 December 2005 01:00  |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
Hi
In Oracle 10g,
For the command backup database format='c:\%d_%s_%t.data', RMAN is creating two backup sets. can we configure the number of backup sets to be created ?. If so, how to configure it. Will the number of backupsets depends on database size.
With Regards
Vara Prasad
|
|
|
|
| Re: RMAN Backup for 10g [message #152954 is a reply to message #152943] |
Wed, 28 December 2005 01:55  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
The number and size of backupsets depends on the values of following parameters:
-- Fileperset
-- Maxsetsize
-- Number of channels you allocate during backup
-- Maxopenfiles .
Lets take a small example
Total no. of files in database=16
RMAN values
Channels allocated=2
Fileperset=4
Now RMAN will create 4 backupsets on the basis of above values.
So it would be better to read the documentation for these parameters.
regards,
tarun
|
|
|
|
| Re: RMAN Backup for 10g [message #153223 is a reply to message #152943] |
Fri, 30 December 2005 01:51 |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
Hi,
Iam having 4 datafiles,
I set the filesperset to 10 and maxsetsize to 1G (my database is less than 1GB, it is 946MB).
when executed the RMAN backup command iam getting two backup sets.
First one includes the datafiles and the second one includes the spfile and current controlfile.Backup is taken by using 1 default channel.(I didnt allocated manually).
How can i get the datafiles,spfile and current controlfile in one backupset.
With Regards,
Vara Prasad
|
|
|
|
| Re: RMAN Backup for 10g [message #153227 is a reply to message #153223] |
Fri, 30 December 2005 02:58 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
You can club the control file backup command with the backup command so that it comes under a single backup set.
for eg:
BAckup tablespace TOOLS include current controlfile;
now the backupset for both the tablespace and controlfile is same.
For more info read the manuals on "Backing up the Control File".
And for futher discussion post your RMAN backup command.
|
|
|
|
| Re: RMAN Backup for 10g [message #153234 is a reply to message #152943] |
Fri, 30 December 2005 03:51 |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
Hi,
I tried two commands
1.backup database format='c:\%d_%s_%t.data'
2.backup database format-'c:\%d_%s_%t.data' include current controlfile for standby
For the both commands, its creating two backup sets.
With Regards,
Vara Prasad.
|
|
|
|
| Re: RMAN Backup for 10g [message #153236 is a reply to message #153234] |
Fri, 30 December 2005 04:12 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
1. backup database format='c:\%d_%s_%t.data'
This command will not backup control file unless the Autobackup feature is enabled.
2. backup database format-'c:\%d_%s_%t.data' include current controlfile for standby
Why you wrote "for standby"?
Loook when i tried, i got a single backupset.
RMAN> backup database format='/data1/%d_%t_%sfull.bkp' include current controlfile;
Starting backup at 30-DEC-05
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=/data1/u01/app/oracle/oradata/testdb/datafile/system01.dbf
input datafile fno=00003 name=/data1/u01/app/oracle/oradata/testdb/datafile/exam_sh01.dbf
input datafile fno=00002 name=/data1/u01/app/oracle/oradata/testdb/datafile/undotbs01.dbf
input datafile fno=00004 name=/data1/u01/app/oracle/oradata/testdb/datafile/tanu_tb01.dbf
input datafile fno=00005 name=/data1/u01/app/oracle/oradata/testdb/datafile/raj_tb01.dbf
channel ORA_DISK_1: starting piece 1 at 30-DEC-05
channel ORA_DISK_1: finished piece 1 at 30-DEC-05
piece handle=/data1/TESTDB_578379777_17full.bkp comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:27
Finished backup at 30-DEC-05
RMAN> exit
Recovery Manager complete.
[ /data1 ]
dogmatix:SID=testdb=>ls
TESTDB_578379777_17full.bkp
[ /data1 ]
for the next time paste the output like i did .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
