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)
How to determine the size of backup increased in last one month [message #680697] Tue, 02 June 2020 00:08 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

have a look at V$RMAN_BACKUP_JOB_DETAILS:
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)
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is your "control_file_record_keep_time" parameter value?

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 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
The value is 7 please
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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 Go to previous messageGo to next message
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
Re: How to determine the size of backup increased in last one month [message #680747 is a reply to message #680746] Fri, 05 June 2020 10:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is that.
And the "_display" column is just a pretty way to display the same thing.

Re: How to determine the size of backup increased in last one month [message #681068 is a reply to message #680747] Wed, 10 June 2020 10:41 Go to previous message
janakors
Messages: 232
Registered: September 2009
Senior Member
Thank You for Your time. i will use _display column for the desired results
Previous Topic: SQL text history
Next Topic: Datafile cannot be open by either non cdb or cdb instance
Goto Forum:
  


Current Time: Thu Mar 28 16:40:46 CDT 2024