| About MAXSETSIZE [message #475059] |
Sat, 11 September 2010 23:27  |
muktha_22
Messages: 527
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 #475062 is a reply to message #475060] |
Sun, 12 September 2010 02:49  |
John Watson
Messages: 8962
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 |
muktha_22
Messages: 527
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 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
