In Linux, the entire backup process lasted about five hours, and the backup capacity was as follows: [oracle @ smsbackup] $ du-sk1448023700. Backup script:
In Linux, the entire backup process lasts for about five hours. The backup capacity is as follows: [oracle @ sms backup] $ du-sk1448023700. backup script:
Last night, a temporary backup retained for a customer's database. The overall database capacity is about TB. Generally, the low-end storage is as follows:
SQL * Plus: Release 10.2.0.2.0-Production on Thu Sep 10 14:27:39 2009
Copyright (c) 1982,200 5, Oracle. All Rights Reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select sum (bytes)/1024/1024/1024 GB from v $ datafile;
GB
----------
1527.83266
In Linux, the entire backup process lasts about five hours. The backup capacity is as follows:
[Oracle @ sms backup] $ du-sk
1448023700.
Backup script:
Run {
Allocate channel d1 type disk maxpiecesize = 50G;
Allocate channel d2 type disk maxpiecesize = 50G;
Backup full database filesperset 10 include current controlfile format '/backup/fullbak _ % d _ % T _ % s _ % P'
Plus archivelog format'/backup/archbak _ % d _ % T _ % s' delete all input;
Release channel d1;
Release channel d2;
}
Backup starts:
Recovery Manager: Release 10.2.0.2.0-Production on Wed Sep 9 21:30:23 2009
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected to target database: ORADB (DBID = 2409970687)
RMAN> run {
2> allocate channel d1 type disk maxpiecesize = 50 GB;
3> allocate channel d2 type disk maxpiecesize = 50 GB;
4> backup full database filesperset 10 include current controlfile format '/backup/fullbak _ % d _ % T _ % s _ % P'
5> plus archivelog format'/backup/archbak _ % d _ % T _ % s' delete all input;
6> release channel d1;
7> release channel d2;
8>}
9>
Using target database control file instead of recovery catalog
Allocated channel: d1
Channel d1: sid = 819 instance = oradb1 devtype = DISK
Allocated channel: d2
Channel d2: sid = 799 instance = oradb1 devtype = DISK
Starting backup at 09-SEP-09
Current log archived
Channel d1: starting archive log backupset
Channel d1: specifying archive log (s) in backup set
Input archive log thread = 1 sequence = 39695 recid = 82786 stamp = 697023074
Input archive log thread = 1 sequence = 39696 recid = 82789 stamp = 697024187
The End Time is Sep 10, about five hours.