RE: RMAN backups
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <richard.ignizio@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 17 Jun 2005 12:34:53 -0700
Hi Rich,
We backup several large databases to tape via RMAN & Netbackup daily - here are
the timings along with DB size and backup size from last night:
Database Set Stamp Start End Minutes Activity Status
#Files Database Size MB Written Size MB
-------- ------------- ------------ ------------ ------- ----------
------------ ------ ---------------- ---------------
BERP 561153815 16/20:03:47 16/21:02:00 58.22 Full Available
55 88324.00 63123.71
Database BS_Key Start End Minutes Activity
Status #Files Database Size MB Written Size MB
-------------- ------------- ------------ ------------ ------- -------------
------------ ------ ---------------- ---------------
D000 1929894 16/19:25:08 16/19:32:41 7.55 Full
Available 17 1486.00 267.03
D500 1930111 16/19:09:04 16/19:41:18 32.23 Full
Available 17 9967.00 9214.71
D502 1929962 16/19:08:56 16/19:37:07 28.18 Full
Available 16 4676.00 3692.84
D514 1929697 16/19:08:56 16/19:21:41 12.75 Full
Available 16 2152.00 1575.43
D517 1929922 16/19:08:57 16/19:35:09 26.20 Full
Available 16 3216.00 2262.55
D521 1929780 16/19:09:02 16/19:29:34 20.53 Full
Available 16 2976.00 2107.10
D525 1929670 16/19:08:56 16/19:21:16 12.33 Full
Available 16 2246.00 1499.02
D530 1929782 16/19:09:02 16/19:29:33 20.52 Full
Available 16 2966.00 2046.51
D537 1929862 16/19:09:03 16/19:31:00 21.95 Full
Available 16 3306.00 2474.78
D542 1929647 16/19:09:01 16/19:16:49 7.80 Full
Available 16 1646.00 657.84
D547 1930088 16/19:09:02 16/19:40:53 31.85 Full
Available 16 5356.00 4796.38
D550 1929840 16/19:09:00 16/19:31:06 22.10 Full
Available 16 2146.00 1112.02
D553 1930139 16/19:09:02 16/19:41:48 32.77 Full
Available 16 5784.00 4874.55
D559 1929759 16/19:09:02 16/19:29:00 19.97 Full
Available 16 1996.00 1061.52
D567 1929949 16/19:09:05 16/19:37:02 27.95 Full
Available 16 5674.00 5074.55
D573 1929732 16/19:09:03 16/19:22:47 13.73 Full
Available 16 2246.00 1330.07
D583 1930029 16/19:09:05 16/19:39:02 29.95 Full
Available 16 3650.00 2666.98
D589 1929995 16/19:09:05 16/19:37:14 28.15 Full
Available 19 5006.00 4408.70
H553 1929624 16/19:09:06 16/19:14:31 5.42 Full
Available 16 4246.00 3465.84
Database BS_Key Start End Minutes Activity
Status #Files Database Size MB Written Size MB
-------------- ------------- ------------ ------------ ------- -------------
------------ ------ ---------------- ---------------
BAAN4 410561 17/00:11:14 17/04:24:32 253.30 Incremental
Available 37 118600.00 1654.00
BAAN4 410562 17/00:11:11 17/04:28:41 257.50 Incremental
Available 36 118620.00 8475.27
BAAN4 410563 17/00:11:17 17/04:32:28 261.18 Incremental
Available 37 118740.47 8357.28
Database BS_Key Start End Minutes Backup Type
Status #Files Database Size MB Written Size MB
-------------- ------------- ------------ ------------ ------- -------------
------------ ------ ---------------- ---------------
BAANPRD 619949 16/21:09:48 17/01:01:48 232.00 Full
Available 24 40399.00 30400.30
BAANPRD 619950 16/21:09:41 17/01:27:37 257.93 Full
Available 24 40087.00 35443.70
BAANPRD 619951 16/21:09:41 17/01:29:57 260.27 Full
Available 24 40099.00 34932.27
BAANPRD 619952 16/21:09:46 17/01:35:56 266.17 Full
Available 24 41404.00 32738.58
BAANPRD 619953 16/21:09:48 17/01:46:46 276.97 Full
Available 24 41353.00 35964.65
BAANPRD 619954 16/21:09:46 17/01:46:55 277.15 Full
Available 23 40940.00 34735.03
Database BS_Key Start End Minutes Backup Type
Status #Files Database Size MB Written Size MB
-------------- ------------- ------------ ------------ ------- -------------
------------ ------ ---------------- ---------------
TLEV52 112169 16/21:09:30 16/21:14:21 4.85 Full
Available 2 60.00 48.80
TLEV52 112170 16/21:09:30 16/21:14:42 5.20 Full
Available 2 110.00 45.45
TLEV52 112171 16/21:09:30 16/21:14:45 5.25 Full
Available 1 200.00 41.16
TLEV52 112172 16/21:09:30 16/21:15:46 6.27 Full
Available 1 750.00 236.26
TLEV52 112173 16/21:09:30 16/21:16:05 6.58 Full
Available 2 310.00 1.21
TLE52TST 112196 17/01:28:02 17/01:36:14 8.20 Full
Available 2 31.00 8.09
TLE52TST 112197 17/01:28:03 17/01:37:14 9.18 Full
Available 1 300.00 101.93
TLE52TST 112198 17/01:28:03 17/01:37:50 9.78 Full
Available 1 100.00 40.87
TLE52TST 112199 17/01:28:02 17/01:38:08 10.10 Full
Available 2 26.00 5.50
TLE52TST 112200 17/01:28:03 17/01:38:30 10.45 Full
Available 2 31.00 11.59
Database BS_Key Start End Minutes Backup Type
Status #Files Database Size MB Written Size MB
-------------- ------------- ------------ ------------ ------- -------------
------------ ------ ---------------- ---------------
VRTXPRD 16775 16/21:09:28 16/21:16:14 6.77 Full
Available 4 1024.00 320.34
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ignizio, Richard
Sent: Friday, June 17, 2005 12:06 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN backups
I am doing research on taking backups with RMAN vs. Sync/split then backup to
tape. We currently use sync/split, copy to tape for all of our production
database backups and direct to tape backups for non prod backups. Some
databases are backed up four times a week while otheres are backed up everyday.
My question to the list is who uses RMAN and how large are the databases and
the backup times associated with using RMAN.
Thanks,
Rich
--
//www.freelists.org/webpage/oracle-l
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
