Home » RDBMS Server » Backup & Recovery » Rman backup piece size in oracle 9i (oracle 9i, SOLARIS)
Rman backup piece size in oracle 9i [message #429922] Fri, 06 November 2009 05:33 Go to next message
suresh.wst
Messages: 48
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
Re: Rman backup piece size in oracle 9i [message #429931 is a reply to message #429922] Fri, 06 November 2009 06:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
v$backup_piece
Re: Rman backup piece size in oracle 9i [message #429968 is a reply to message #429931] Fri, 06 November 2009 10:11 Go to previous messageGo to next message
suresh.wst
Messages: 48
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
Re: Rman backup piece size in oracle 9i [message #429969 is a reply to message #429968] Fri, 06 November 2009 10:18 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
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?
Re: Rman backup piece size in oracle 9i [message #429970 is a reply to message #429968] Fri, 06 November 2009 10:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
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.
Re: Rman backup piece size in oracle 9i [message #430288 is a reply to message #429931] Mon, 09 November 2009 23:24 Go to previous messageGo to next message
suresh.wst
Messages: 48
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
Re: Rman backup piece size in oracle 9i [message #430290 is a reply to message #429969] Mon, 09 November 2009 23:28 Go to previous messageGo to next message
suresh.wst
Messages: 48
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
Re: Rman backup piece size in oracle 9i [message #430292 is a reply to message #430290] Mon, 09 November 2009 23:33 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
>SQL*Plus: Release 9.2.0.6.0
Above is obsoleted & unsupported.
Please join the 21st century at your earliest convenience!
Re: Rman backup piece size in oracle 9i [message #430408 is a reply to message #430290] Tue, 10 November 2009 05:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
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
Re: Rman backup piece size in oracle 9i [message #430560 is a reply to message #430408] Wed, 11 November 2009 01:05 Go to previous message
suresh.wst
Messages: 48
Registered: June 2008
Location: Hyderabad
Member
Thanks a lot .. your reply helped me.

Regards,
Suresh
Previous Topic: Oracle Flashback Logs backups
Next Topic: replace database
Goto Forum:
  


Current Time: Sun Sep 25 16:17:14 CDT 2016

Total time taken to generate the page: 0.11790 seconds