Home » RDBMS Server » Backup & Recovery » About MAXSETSIZE (Oracle 9i.2, Windows. )
About MAXSETSIZE [message #475059] Sat, 11 September 2010 23:27 Go to next message
muktha_22
Messages: 378
Registered: December 2009
Senior Member
Hi,

Need a clarifications:

1) Setting MAXSETSIZE must have atleast the size of the SYSTEM tablespace? Am I right.

2) What is the use of it in real time production?

Thanks
Re: About MAXSETSIZE [message #475060 is a reply to message #475059] Sat, 11 September 2010 23:36 Go to previous messageGo to next message
BlackSwan
Messages: 22681
Registered: January 2009
Senior Member
1) NO
2) Specifies a maximum size for a backup set.
Re: About MAXSETSIZE [message #475062 is a reply to message #475060] Sun, 12 September 2010 02:49 Go to previous messageGo to next message
John Watson
Messages: 4478
Registered: January 2010
Location: Global Village
Senior Member
Muktha, may I offer some general advice? In the Oracle environment, you must always test and experiment. You can even do reverse engineering.
For example, with your first question, try it. The test takes a few seconds:
C:\Users\john\home>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Sep 12 08:44:41 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: JW (DBID=955106381, not open)

RMAN> report schema;

using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name JW

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    730      SYSTEM               ***     C:\ORACLE\ORADATA\JW\SYSTEM01.DBF
2    550      SYSAUX               ***     C:\ORACLE\ORADATA\JW\SYSAUX01.DBF
3    295      UNDOTBS1             ***     C:\ORACLE\ORADATA\JW\UNDOTBS01.DBF
4    5        USERS                ***     C:\ORACLE\ORADATA\JW\USERS01.DBF
5    100      EXAMPLE              ***     C:\ORACLE\ORADATA\JW\EXAMPLE01.DBF
6    50       CIS                  ***     C:\ORACLE\ORADATA\JW\JW\DATAFILE\O1_MF_CIS_679ZOCWC_.DBF
7    50       BPLC                 ***     C:\ORACLE\ORADATA\JW\JW\DATAFILE\O1_MF_BPLC_679ZOHVS_.DBF
8    20       MGMT_ECM_DEPOT_TS    ***     C:\ORACLE\ORADATA\JW\MGMT_ECM_DEPOT1.DBF
9    250      MGMT_TABLESPACE      ***     C:\ORACLE\ORADATA\JW\MGMT.DBF
10   200      MGMT_AD4J_TS         ***     C:\ORACLE\ORADATA\JW\MGMT_AD4J.DBF

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    44       TEMP                 32767       C:\ORACLE\ORADATA\JW\TEMP01.DBF

RMAN> backup tablespace system maxsetsize 100m;

Starting backup at 12-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=395 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/12/2010 08:44:58
RMAN-06183: datafile or datafile copy C:\ORACLE\ORADATA\JW\SYSTEM01.DBF (file number 1) larger than MAXSETSIZE

RMAN> backup tablespace MGMT_AD4J_TS maxsetsize 100m;

Starting backup at 12-SEP-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/12/2010 08:45:14
RMAN-06183: datafile or datafile copy C:\ORACLE\ORADATA\JW\MGMT_AD4J.DBF (file number 10) larger than MAXSETSIZE

RMAN> backup tablespace CIS maxsetsize 100m;

Starting backup at 12-SEP-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=C:\ORACLE\ORADATA\JW\JW\DATAFILE\O1_MF_CIS_679ZOCWC_.DBF
channel ORA_DISK_1: starting piece 1 at 12-SEP-10
channel ORA_DISK_1: finished piece 1 at 12-SEP-10
piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\JW\BACKUPSET\2010_09_12\O1_MF_NNNDF_TAG20100912T084527_68S18QSC_.BKP tag=TAG2
0100912T084527 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 12-SEP-10

RMAN>


And the answer to your question becomes clear.
Re: About MAXSETSIZE [message #475065 is a reply to message #475062] Sun, 12 September 2010 05:25 Go to previous messageGo to next message
muktha_22
Messages: 378
Registered: December 2009
Senior Member
Hi John & Blackswan,

Thanks a lot,

1) Before I post it I tried with the full database backup. It shown me the error. Then I tried with the size of system tablespace, then it was succeeded.
So I wanted to check with the expert.

Now tell me why I got the error as same as above, and what is the solutions?

Thanks
Re: About MAXSETSIZE [message #475066 is a reply to message #475065] Sun, 12 September 2010 05:39 Go to previous message
Michel Cadot
Messages: 58847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN-06183: datafile or datafile copy larger than MAXSETSIZE: file# %s %s
 *Cause: A BACKUP DATAFILE(copy) command specified the MAXSETSIZE operand too
         low.  The specified datafile is larger than MAXSETSIZE will allow.
 *Action: Increase MAXSETSIZE limit.

Regards
Michel
Previous Topic: Backup Archivelog with standby
Next Topic: How to force tempfile reuse when duplicating database
Goto Forum:
  


Current Time: Wed Aug 20 11:55:10 CDT 2014

Total time taken to generate the page: 0.06973 seconds