Home » RDBMS Server » Backup & Recovery » FILESPERSET Parameter of RMAN
FILESPERSET Parameter of RMAN [message #154267] Fri, 06 January 2006 09:07 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
How do I see the current setting of FILESPERSET of RMAN, I did show all but it does not show it.

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/test/hot/fulldb_%u%s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/10.1.0.2/dbs/snapcf_test.f'; # default

How do I change the parameter FILESPERSET

Please help

Thanks

Report message to a moderator

Re: FILESPERSET Parameter of RMAN [message #154275 is a reply to message #154267] Fri, 06 January 2006 09:53 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:

The maximum number of datafiles in each backup set is determined by the FILESPERSET parameter of the BACKUP command.
The default value is calculated by RMAN as follows: RMAN compares the value 64 to the rounded-up ratio of number of files
divided by the number of channels, and sets FILESPERSET to
the lower value. For example, if you back up 70 files with one channel, then RMAN takes 70 divided by÷ 1, compares
70 to 64, and sets FILESPERSET to 64 because it is lower.


http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconc1.htm#458507

Report message to a moderator

Previous Topic: How does one put a database into ARCHIVELOG mode?
Next Topic: how to use RMAN?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 16 06:55:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.