OraFAQ Forum: Backup & Recovery » Rman backup piece size in oracle 9i

Home » RDBMS Server » Backup & Recovery » Rman backup piece size in oracle 9i (oracle 9i, SOLARIS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rman backup piece size in oracle 9i [message #429922]

Fri, 06 November 2009 05:33

suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad

Member

Hi,

Is there any view (Either data dictionary view or rman view) to find the backup piece size in oracle 9i. My requirement is to find the piece size using view only (PL/SQL needs the query to find the piece information).

Thanks for the help in advance..

Regards,
Suresh

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #429931 is a reply to message #429922]

Fri, 06 November 2009 06:12

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

v$backup_piece

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #429968 is a reply to message #429931]

Fri, 06 November 2009 10:11

suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad

Member

Thanks for the replay...But I could not find size column or any other column which gives the size of the piece.

Regards,
Suresh

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #429969 is a reply to message #429968]

Fri, 06 November 2009 10:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> desc v$backup_piece
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 RECID						    NUMBER
 STAMP						    NUMBER
 SET_STAMP					    NUMBER
 SET_COUNT					    NUMBER
 PIECE# 					    NUMBER
 COPY#						    NUMBER
 DEVICE_TYPE					    VARCHAR2(17)
 HANDLE 					    VARCHAR2(513)
 COMMENTS					    VARCHAR2(64)
 MEDIA						    VARCHAR2(65)
 MEDIA_POOL					    NUMBER
 CONCUR 					    VARCHAR2(3)
 TAG						    VARCHAR2(32)
 STATUS 					    VARCHAR2(1)
 START_TIME					    DATE
 COMPLETION_TIME				    DATE
 ELAPSED_SECONDS				    NUMBER
 DELETED					    VARCHAR2(3)
 BYTES						    NUMBER
 IS_RECOVERY_DEST_FILE				    VARCHAR2(3)
 RMAN_STATUS_RECID				    NUMBER
 RMAN_STATUS_STAMP				    NUMBER
 COMPRESSED					    VARCHAR2(3)

What might BYTES represent?

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #429970 is a reply to message #429968]

Fri, 06 November 2009 10:19

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1040.htm
Your best chance is checking with documentation.

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #430288 is a reply to message #429931]

Mon, 09 November 2009 23:24

suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad

Member

Hi,

Thanks for your help.. but I could not see bytes column in the following view.

$ sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Nov 9 23:21:13 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> desc v$backup_piece
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
PIECE# NUMBER
COPY# NUMBER
DEVICE_TYPE VARCHAR2(17)
HANDLE VARCHAR2(513)
COMMENTS VARCHAR2(81)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
CONCUR VARCHAR2(3)
TAG VARCHAR2(32)
STATUS VARCHAR2(1)
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
DELETED VARCHAR2(3)

Regards,
Suresh

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #430290 is a reply to message #429969]

Mon, 09 November 2009 23:28

suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad

Member

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #430292 is a reply to message #430290]

Mon, 09 November 2009 23:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>SQL*Plus: Release 9.2.0.6.0
Above is obsoleted & unsupported.
Please join the 21st century at your earliest convenience!

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #430408 is a reply to message #430290]

Tue, 10 November 2009 05:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Apologies. I was ignorant that you have already stated that version you are using is 9i.

Look into v$backup_datafile and v$backup_redolog.

http://download.oracle.com/docs/cd/B10501_01/server.920/a96565/rcviews5.htm#RCMRF166

Report message to a moderator

Re: Rman backup piece size in oracle 9i [message #430560 is a reply to message #430408]

Wed, 11 November 2009 01:05

suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad

Member

Thanks a lot .. your reply helped me.

Regards,
Suresh

Report message to a moderator

Previous Topic:	Oracle Flashback Logs backups
Next Topic:	replace database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 17:57:22 CST 2024