Home » RDBMS Server » Backup & Recovery » backupset issue (11.2.0.1 windows xp)
backupset issue [message #529777] Wed, 02 November 2011 22:12 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I have backup my db using rman, it generate two backupsets,why not one?i want to know whether there is a rule about generate how many backupsets?

[code]
RMAN> run
2> {
3> allocate channel t1 type disk;
4> backup database format 'E:\rman_bak\20111103\df_%t_%s_%p.bak';
5> }run

allocated channel: t1
channel t1: SID=133 device type=DISK

Starting backup at 03-NOV-11
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00004 name=D:\ORACLE\ORADATA\ORCL\USERS01.DBF
input datafile file number=00001 name=D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
input datafile file number=00005 name=D:\ORACLE\ORADATA\ORCL\TEST01.DBF
input datafile file number=00006 name=D:\ORACLE\ORADATA\ORCL\UNDOTBS02.DBF
input datafile file number=00002 name=D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
channel t1: starting piece 1 at 03-NOV-11
channel t1: finished piece 1 at 03-NOV-11
piece handle=E:\RMAN_BAK\20111103\DF_766235030_5_1.BAK tag=TAG20111103T110349 comment=NONE
channel t1: backup set complete, elapsed time: 00:01:55
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel t1: starting piece 1 at 03-NOV-11
channel t1: finished piece 1 at 03-NOV-11
piece handle=E:\RMAN_BAK\20111103\DF_766235145_6_1.BAK tag=TAG20111103T110349 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:01
Finished backup at 03-NOV-11
released channel: t1
[code]
Re: backupset issue [message #529779 is a reply to message #529777] Wed, 02 November 2011 22:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#i1016352
Re: backupset issue [message #529800 is a reply to message #529777] Thu, 03 November 2011 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it generate two backupsets,

No, there is ONE backup set including 2 backup pieces.

Regards
Michel
Re: backupset issue [message #530212 is a reply to message #529800] Mon, 07 November 2011 03:12 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
Michel, how to check whether there is ONE backup set?
Re: backupset issue [message #530219 is a reply to message #530212] Mon, 07 November 2011 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
list backupset;

Regards
Michel
Re: backupset issue [message #531276 is a reply to message #530219] Mon, 14 November 2011 20:56 Go to previous message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
Please check my comments on http://www.orafaq.com/forum/t/176361/154836/ about "Why Oracle generates one more backup piece on one backupset?"

Try using DISKRATIO=0 to disable advanced algorithm on backup set to only generate one backup piece in one backup set.

Edgy
Previous Topic: Oracle RMAN Recovery
Next Topic: Why Oracle generates one more backup piece on one backupset?
Goto Forum:
  


Current Time: Tue Oct 21 00:50:59 CDT 2014

Total time taken to generate the page: 0.05782 seconds