程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle數據庫基礎 >> ORACLE ten G R two 備份 帶與帶不歸檔日志的過程

ORACLE ten G R two 備份 帶與帶不歸檔日志的過程

編輯:Oracle數據庫基礎

RMAN> 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> 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 data

file(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> 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 



  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved