---
title: "ORACLE ten G R two 备份 带与带不归档日志的过程"
author: "winzenghua"
date: "2007-11-30T15:00:00Z"
tags: []
slug: "oracle-ten-g-r-two"
draft: false
lastmod: "2007-11-30T15:00:00Z"
id: 987918
url: "https://java4gis.iteye.com/blog/987918"
---

RMAN&gt; show all;

RMAN configuration parameters are:  
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default  
CONFIGURE BACKUP OPTIMIZATION ON;  
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default  
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default  
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default  
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;  
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default  
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default  
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oradata/surgesms/rmanbackup/full\_%d\_%s\_%T\_%t.bak';  
CONFIGURE MAXSETSIZE TO UNLIMITED; # default  
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default  
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default  
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default  
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/product/10.2.0/dbs/snapcf\_surgesms.f'; # default

RMAN&gt; backup database;

Starting backup at 2007-11-27 17:04:46  
allocated channel: ORA\_DISK\_1  
channel ORA\_DISK\_1: sid=328 devtype=DISK  
channel ORA\_DISK\_1: starting compressed full datafile backupset  
channel ORA\_DISK\_1: specifying datafile(s) in backupset  
input datafile fno=00004 name=/oradata/surgesms/users01.dbf  
input datafile fno=00006 name=/oradata/surgesms/surgesms1\_02.dbf  
input datafile fno=00008 name=/oradata/surgesms/undotbs2.dbf  
input datafile fno=00005 name=/oradata/surgesms/surgesms1\_01.dbf  
input datafile fno=00003 name=/oradata/surgesms/sysaux01.dbf  
input datafile fno=00001 name=/oradata/surgesms/system01.dbf  
input datafile fno=00007 name=/oradata/surgesms/perfstat01.dbf  
input datafile fno=00002 name=/oradata/surgesms/logmnr01.dbf  
channel ORA\_DISK\_1: starting piece 1 at 2007-11-27 17:04:47  
channel ORA\_DISK\_1: finished piece 1 at 2007-11-27 17:51:43  
piece handle=/oradata/surgesms/rmanbackup/full\_SURGESMS\_143\_20071127\_639767087.bak tag=TAG20071127T170447 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:46:56  
channel ORA\_DISK\_1: starting compressed full datafile backupset  
channel ORA\_DISK\_1: specifying datafile(s) in backupset  
including current control file in backupset  
including current SPFILE in backupset  
channel ORA\_DISK\_1: starting piece 1 at 2007-11-27 17:51:45  
channel ORA\_DISK\_1: finished piece 1 at 2007-11-27 17:51:46  
piece handle=/oradata/surgesms/rmanbackup/full\_SURGESMS\_144\_20071127\_639769903.bak tag=TAG20071127T170447 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:00:03  
Finished backup at 2007-11-27 17:51:46

-rw-r----- 1 oracle dba 98849792 Nov 28 03:04 1\_13161\_630698096.dbf  
\-rw-r----- 1 oracle dba 101046784 Nov 28 07:15 1\_13162\_630698096.dbf  
\-rw-r----- 1 oracle dba 99079168 Nov 28 07:59 1\_13163\_630698096.dbf  
\-rw-r----- 1 oracle dba 98836480 Nov 28 08:27 1\_13164\_630698096.dbf  
\-rw-r----- 1 oracle dba 99732992 Nov 28 08:47 1\_13165\_630698096.dbf  
\-rw-r----- 1 oracle dba 100235264 Nov 28 08:50 1\_13166\_630698096.dbf  
\-rw-r----- 1 oracle dba 99797504 Nov 28 08:55 1\_13167\_630698096.dbf  
\-rw-r----- 1 oracle dba 100859392 Nov 28 08:57 1\_13168\_630698096.dbf  
\-rw-r----- 1 oracle dba 99411456 Nov 28 09:05 1\_13169\_630698096.dbf  
\-rw-r----- 1 oracle dba 99488768 Nov 28 09:16 1\_13170\_630698096.dbf  
\-rw-r----- 1 oracle dba 99076608 Nov 28 09:18 1\_13171\_630698096.dbf  
\-rw-r----- 1 oracle dba 99061760 Nov 28 09:20 1\_13172\_630698096.dbf  
\-rw-r----- 1 oracle dba 99566080 Nov 28 09:23 1\_13173\_630698096.dbf

-rw-r----- 1 oracle dba 98910720 Nov 28 09:25 1\_13174\_630698096.dbf  
\-rw-r----- 1 oracle dba 98845696 Nov 28 09:28 1\_13175\_630698096.dbf  
\-rw-r----- 1 oracle dba 99106816 Nov 28 09:32 1\_13176\_630698096.dbf  
\-rw-r----- 1 oracle dba 98854400 Nov 28 09:35 1\_13177\_630698096.dbf  
\-rw-r----- 1 oracle dba 98973696 Nov 28 09:41 1\_13178\_630698096.dbf  
\-rw-r----- 1 oracle dba 99266048 Nov 28 09:44 1\_13179\_630698096.dbf  
\-rw-r----- 1 oracle dba 99045376 Nov 28 09:53 1\_13180\_630698096.dbf  
\-rw-r----- 1 oracle dba 98802688 Nov 28 10:02 1\_13181\_630698096.dbf

-rw-r----- 1 oracle dba 98867200 Nov 28 10:17 1\_13182\_630698096.dbf  
\-rw-r----- 1 oracle dba 98801152 Nov 28 10:31 1\_13183\_630698096.dbf

RMAN&gt; backup database plus archivelog;

Starting backup at 2007-11-28 09:25:19  
using target database control file instead of recovery catalog  
allocated channel: ORA\_DISK\_1  
channel ORA\_DISK\_1: sid=325 devtype=DISK  
channel ORA\_DISK\_1: starting compressed archive log backupset  
channel ORA\_DISK\_1: specifying archive log(s) in backup set  
input archive log thread=1 sequence=13161 recid=4797 stamp=639803086  
input archive log thread=1 sequence=13162 recid=4798 stamp=639818157  
input archive log thread=1 sequence=13163 recid=4799 stamp=639820749  
input archive log thread=1 sequence=13164 recid=4800 stamp=639822429  
input archive log thread=1 sequence=13165 recid=4801 stamp=639823644  
input archive log thread=1 sequence=13166 recid=4802 stamp=639823827  
input archive log thread=1 sequence=13167 recid=4803 stamp=639824116  
input archive log thread=1 sequence=13168 recid=4804 stamp=639824280  
input archive log thread=1 sequence=13169 recid=4805 stamp=639824710  
input archive log thread=1 sequence=13170 recid=4806 stamp=639825389  
input archive log thread=1 sequence=13171 recid=4807 stamp=639825525  
input archive log thread=1 sequence=13172 recid=4808 stamp=639825654  
input archive log thread=1 sequence=13173 recid=4809 stamp=639825797  
channel ORA\_DISK\_1: starting piece 1 at 2007-11-28 09:25:22  
channel ORA\_DISK\_1: finished piece 1 at 2007-11-28 09:27:17  
piece handle=/oradata/surgesms/rmanbackup/full\_SURGESMS\_145\_20071128\_639825920.bak tag=TAG20071128T092520 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:01:57  
Finished backup at 2007-11-28 09:27:17

Starting backup at 2007-11-28 09:27:17  
using channel ORA\_DISK\_1  
channel ORA\_DISK\_1: starting compressed full datafile backupset  
channel ORA\_DISK\_1: specifying datafile(s) in backupset  
input datafile fno=00004 name=/oradata/surgesms/users01.dbf  
input datafile fno=00006 name=/oradata/surgesms/surgesms1\_02.dbf  
input datafile fno=00008 name=/oradata/surgesms/undotbs2.dbf  
input datafile fno=00005 name=/oradata/surgesms/surgesms1\_01.dbf  
input datafile fno=00003 name=/oradata/surgesms/sysaux01.dbf  
input datafile fno=00001 name=/oradata/surgesms/system01.dbf  
input datafile fno=00007 name=/oradata/surgesms/perfstat01.dbf  
input datafile fno=00002 name=/oradata/surgesms/logmnr01.dbf  
channel ORA\_DISK\_1: starting piece 1 at 2007-11-28 09:27:17  
channel ORA\_DISK\_1: finished piece 1 at 2007-11-28 10:15:33  
piece handle=/oradata/surgesms/rmanbackup/full\_SURGESMS\_146\_20071128\_639826037.bak tag=TAG20071128T092717 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:48:16  
channel ORA\_DISK\_1: starting compressed full datafile backupset  
channel ORA\_DISK\_1: specifying datafile(s) in backupset  
including current control file in backupset  
including current SPFILE in backupset  
channel ORA\_DISK\_1: starting piece 1 at 2007-11-28 10:15:35  
channel ORA\_DISK\_1: finished piece 1 at 2007-11-28 10:15:36  
piece handle=/oradata/surgesms/rmanbackup/full\_SURGESMS\_147\_20071128\_639828933.bak tag=TAG20071128T092717 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:00:03  
Finished backup at 2007-11-28 10:15:36

Starting backup at 2007-11-28 10:15:36  
using channel ORA\_DISK\_1  
channel ORA\_DISK\_1: starting compressed archive log backupset  
channel ORA\_DISK\_1: specifying archive log(s) in backup set  
input archive log thread=1 sequence=13174 recid=4810 stamp=639825944  
input archive log thread=1 sequence=13175 recid=4811 stamp=639826134  
input archive log thread=1 sequence=13176 recid=4812 stamp=639826334  
input archive log thread=1 sequence=13177 recid=4813 stamp=639826537  
input archive log thread=1 sequence=13178 recid=4814 stamp=639826872  
input archive log thread=1 sequence=13179 recid=4815 stamp=639827056  
input archive log thread=1 sequence=13180 recid=4816 stamp=639827589  
input archive log thread=1 sequence=13181 recid=4817 stamp=639828152  
channel ORA\_DISK\_1: starting piece 1 at 2007-11-28 10:15:37  
channel ORA\_DISK\_1: finished piece 1 at 2007-11-28 10:16:42  
piece handle=/oradata/surgesms/rmanbackup/full\_SURGESMS\_148\_20071128\_639828936.bak tag=TAG20071128T101536 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:01:06  
Finished backup at 2007-11-28 10:16:42