Shulou(Shulou.com)05/31 Report--

This article is about how to back up the 5T database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. Backup capacity

Level 0 backup every Saturday, level 1 backup on other dates, enable compressed backup, each level 0 backup DB+archivelog produces about 2.5T backup package, other date DB+archivelog about 250g backup package, backup package size is 4T in a week, 16T in a month, keep backup for half a year, total 100T space is needed, 128T space is enough

2. Speed of backup

At present, NAS storage is used, and the storage speed is about 100M/s (10 Gigabit network card, but the storage speed of IO is only 100M/s), so it takes about 12 hours to back up 5T level 0 backup (500000lash 100max 60max 13.8).

3. Measures to improve backup speed

Using SAN storage, the storage speed is about 1G/s (10 Gigabit network card, the storage speed can reach 10 gigabytes / 8 per second, divided by 8 because the network speed unit is bit, the storage unit is byte), backup 5T, about 1.3 hours, SAN storage is more expensive so only apply for 20T San to retain only one month of data, other months of data regularly migrated from SAN storage to the slow 128T space NAS storage.

If you don't apply for SAN, you can only use NAS. How to back it up?

Because the level 0 backup time of 12 hours is very long, during this period, you can enable a level 1 backup that only backs up the archive log. The backup strategy is as follows

Level 0 starts at 17:00 and ends at 07:00

BACKUP INCREMENTAL LEVEL 0 TAG 'DB0' DATABASE FORMAT' / dbbak/rmanbackup/data/DB_0_%T%U' PLUS ARCHIVELOG FORMAT'/ dbbak/rmanbackup/archivelog/ARCH_0_%T_%s' DELETE ALL INPUT

Level 1 starts at 23:00 and ends at 24:00

BACKUP INCREMENTAL LEVEL 1 TAG 'LOG1' ARCHIVELOG ALL FORMAT' / dbbak/rmanbackup/archivelog/ARCH_1_%T_%s' DELETE ALL INPUT

Level 0 backup: archive log + DB+ archive log

The first archive log, the last log sequence:336557 (backup duration 17:00-20:00, backed up the archive log from the previous day to 17:00 today)

DB (backup duration 20:00-06:00)

The second archive log, the first log sequence:336798, the last log sequence:337075 (backup duration 06:00-07:00, backup archive logs generated from 23:00-06:00)

Level 1 backup: archived logs (backup duration 23:00-24:00, only archived logs generated from 17:00-23:00 backed up)

The sequence:336558 of the initial log

The sequence:336797 of the last log

Explain that part of the archived logs generated during the level 0 backup (not generated during 17:00-06 06cong 00-07:00, because the level 0 database was backed up at 06:00), only the archived logs generated from 17:00 to 23:00 were backed up in the level 1 backup (that is, starting at the start time of the level 0 backup) Ending at the start time of the level 1 backup), not all archive logs during the level 0 period are backed up in the level 1 archive log backup (the archive logs generated between 23:00 and 06:00 are not backed up, but in the level 0 archive log backup after the level 0 DB backup)

Select SEQUENCE#,FIRST_TIME,NEXT_TIME from v$archived_log where SEQUENCE# in (336557, 336558, 336797, 336798, 337075)

3365572018/4/20 16:57:452018/4/20 17:00:23

3365572018/4/20 16:57:452018/4/20 17:00:23

3365582018/4/20 17:00:232018/4/20 17:01:21

3365582018/4/20 17:00:232018/4/20 17:01:21

3367972018/4/20 22:57:222018/4/20 23:00:14

3367972018/4/20 22:57:222018/4/20 23:00:14

3367982018/4/20 23:00:142018/4/20 23:00:49

3367982018/4/20 23:00:142018/4/20 23:00:49

3370752018/4/21 5:53:202018/4/21 5:53:38

3370752018/4/21 5:53:202018/4/21 5:53:38

-rw-r-. 1 1024 users 13841127936 April 2018: 04 ARCH_0_20180420_25393

-rw-r-. 1 1024 users 14457288704 April 2018: 06 ARCH_0_20180420_25394

-rw-r-. 1 1024 users 12373300224 April 2018: 27 ARCH_0_20180420_25395

-rw-r-. 1 1024 users 14544237568 April 2018: 31 ARCH_0_20180420_25396

-rw-r-. 1 1024 users 16360 293888 April 2018: 54 ARCH_0_20180420_25397

-rw-r-. 1 1024 users 14905612288 April 2018: 56 ARCH_0_20180420_25398

-rw-r-. 1 1024 users 13927405056 April 20 19:18 ARCH_0_20180420_25399

-rw-r-. 1 1024 users 1631136864 April 20 19:23 ARCH_0_20180420_25400

-rw-r-. 1 1024 users 13070147584 April 20 19:44 ARCH_0_20180420_25402

-rw-r-. 1 1024 users 1601701992 April 20 19:44 ARCH_0_20180420_25401

-- Last log sequence:336557

-rw-r-. 1 1024 users 14543302144 April 20 23:36 ARCH_1_20180420_25407

-rw-r-. 1 1024 users 14880619008 April 20 23:37 ARCH_1_20180420_25408

-rw-r-. 1 1024 users 10505546240 April 20 23:55 ARCH_1_20180420_25410

-rw-r-. 1 1024 users 14935029760 April 20 23:59 ARCH_1_20180420_25409

-- the sequence:336558 of the first log

-- sequence:336797 of the last log

-rw-r-. 1 1024 users 12344919552 April 21 06:23 ARCH_0_20180421_25417

-rw-r-. 1 1024 users 11478225920 April 21 06:24 ARCH_0_20180421_25416

-rw-r-. 1 1024 users 12127244800 April 21 06:40 ARCH_0_20180421_25418

-rw-r-. 1 1024 users 124 19464704 April 21 06:41 ARCH_0_20180421_25419

-rw-r-. 1 1024 users 11637486592 April 21 06:58 ARCH_0_20180421_25420

-- the first log sequence:336798

Thank you for reading! This is the end of the article on "how to back up the 5T database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.