OraFAQ Forum: Server Administration » How to determine the size of backup increased in last one month

Home » RDBMS Server » Server Administration » How to determine the size of backup increased in last one month (oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM)

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

How to determine the size of backup increased in last one month [message #680697]

Tue, 02 June 2020 00:08

janakors
Messages: 232
Registered: September 2009

Senior Member

Hello
I I have been asked to submit a report which tells us how much space has been increased in the last one month That is starting from first of May to 31st of May so I will be able to tell that how much data base size increase in last one month

Is there any way around to have this data or I have to manually record the data base size on every first of the month so and do some manual subtraction please guide if there is any alternative to this thank you

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680698 is a reply to message #680697]

Tue, 02 June 2020 00:53

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How do you take backup?
If RMAN, do you use a RMAN catalog?
Do you keep your previous backups?
...

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680704 is a reply to message #680698]

Tue, 02 June 2020 04:30

janakors
Messages: 232
Registered: September 2009

Senior Member

Yes use RMAN and weekly full physical Back up and every end of the week I delete previous back up so at the end of the month I don’t have any record d like for now I don’t have any record for what exactly the size of the backup I took in ist week of May I do not use RMAN catalogue but I do have logs of backup taken one month back

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680706 is a reply to message #680704]

Tue, 02 June 2020 05:18

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

have a look at V$RMAN_BACKUP_JOB_DETAILS:

Code: [Select all] [Show/ hide]

SQL> desc V$RMAN_BACKUP_JOB_DETAILS
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SESSION_KEY                               NUMBER
 SESSION_RECID                             NUMBER
 SESSION_STAMP                             NUMBER
 COMMAND_ID                                VARCHAR2(33)
 START_TIME                                DATE
 END_TIME                                  DATE
 INPUT_BYTES                               NUMBER
 OUTPUT_BYTES                              NUMBER
 STATUS_WEIGHT                             NUMBER
 OPTIMIZED_WEIGHT                          NUMBER
 OBJECT_TYPE_WEIGHT                        NUMBER
 OUTPUT_DEVICE_TYPE                        VARCHAR2(17)
 AUTOBACKUP_COUNT                          NUMBER
 BACKED_BY_OSB                             VARCHAR2(3 CHAR)
 AUTOBACKUP_DONE                           VARCHAR2(3 CHAR)
 STATUS                                    VARCHAR2(23 CHAR)
 INPUT_TYPE                                VARCHAR2(13 CHAR)
 OPTIMIZED                                 VARCHAR2(3 CHAR)
 ELAPSED_SECONDS                           NUMBER
 COMPRESSION_RATIO                         NUMBER
 INPUT_BYTES_PER_SEC                       NUMBER
 OUTPUT_BYTES_PER_SEC                      NUMBER
 INPUT_BYTES_DISPLAY                       VARCHAR2(4000 CHAR)
 OUTPUT_BYTES_DISPLAY                      VARCHAR2(4000 CHAR)
 INPUT_BYTES_PER_SEC_DISPLAY               VARCHAR2(4000 CHAR)
 OUTPUT_BYTES_PER_SEC_DISPLAY              VARCHAR2(4000 CHAR)
 TIME_TAKEN_DISPLAY                        VARCHAR2(4000 CHAR)

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680730 is a reply to message #680706]

Thu, 04 June 2020 06:00

janakors
Messages: 232
Registered: September 2009

Senior Member

thank you Michel

i need to track incremental level 0 and the my backup tag is backup_full but when i see the input type in the output of the query i see only DB_INCR and DB_Arch? where is backup_full so i can determine the size

please comment

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680733 is a reply to message #680730]

Thu, 04 June 2020 09:37

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your "control_file_record_keep_time" parameter value?

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680736 is a reply to message #680733]

Fri, 05 June 2020 01:15

janakors
Messages: 232
Registered: September 2009

Senior Member

The value is 7 please

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680737 is a reply to message #680736]

Fri, 05 June 2020 01:30

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So RMAN records may be deleted after 7 days.
Increase it to 30, for instance, if you want to keep records over 2 weeks.

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680739 is a reply to message #680733]

Fri, 05 June 2020 04:09

janakors
Messages: 232
Registered: September 2009

Senior Member

Which column will tell the size of the backup taken at that time?
i have checked the details of the columns but didnt get it

these are output_Bytes ? output_bytes_display? or something else.plz elaborate if possible

Regards

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680740 is a reply to message #680739]

Fri, 05 June 2020 04:23

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What does the documentation I pointed you to say?
What is the difference between the 2 columns you mentioned?

Report message to a moderator

Re: How to determine the size of backup increased in last one month [message #680746 is a reply to message #680740]

Fri, 05 June 2020 09:46

janakors
Messages: 232
Registered: September 2009

Senior Member

output_bytes mean the Output size of all pieces generated by this job. this one looks to be my column for the said purpose but i was making it sure from you as well anyhow i think this is the columns as it says that size of all pieces in RMAN backup

can u confirm that please

Good day

Report message to a moderator