[Oracle] rman備份指令碼(2)
C:\Users\Admin>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 4 08:37:06 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: BRUCE (DBID=1667411)
RMAN> run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup as compressed backupset filesperset 2 tag 'pri_full_backup' format 'D:\oracle\product\arch\%T_%U' database;
6> release channel c1;
7> release channel c2;
8> release channel c3;
9> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=142 devtype=DISK
allocated channel: c2
channel c2: sid=143 devtype=DISK
allocated channel: c3
channel c3: sid=144 devtype=DISK
Starting backup at 04-OCT-16
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00006 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\TEST.DBF
channel c1: starting piece 1 at 04-OCT-16
channel c2: starting compressed full datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\SYSTEM01.DBF
input datafile fno=00004 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\USERS01.DBF
channel c2: starting piece 1 at 04-OCT-16
channel c3: starting compressed full datafile backupset
channel c3: specifying datafile(s) in backupset
input datafile fno=00003 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\SYSAUX01.DBF
input datafile fno=00007 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\BRUCE.DBF
channel c3: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0DRHGI38_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:06
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00005 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\EXAMPLE01.DBF
input datafile fno=00002 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\UNDOTBS01.DBF
channel c1: starting piece 1 at 04-OCT-16
channel c3: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0FRHGI38_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c3: backup set complete, elapsed time: 00:00:07
channel c3: starting compressed full datafile backupset
channel c3: specifying datafile(s) in backupset
including current control file in backupset
channel c3: starting piece 1 at 04-OCT-16
channel c3: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0HRHGI3F_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c3: starting compressed full datafile backupset
channel c3: specifying datafile(s) in backupset
including current SPFILE in backupset
channel c3: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0GRHGI3E_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:05
channel c3: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0IRHGI3H_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c2: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0ERHGI38_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c2: backup set complete, elapsed time: 00:00:18
Finished backup at 04-OCT-16
released channel: c1
released channel: c2
released channel: c3
======================================================================================================================
C:\Users\Admin>rman target / cmdfile=D:\oracle\product\arch\backup
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 4 08:48:31 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: BRUCE (DBID=1667411)
RMAN> run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup as compressed backupset filesperset 3 tag 'pri_full_backup' format 'D:\oracle\product\arch\%T_%U' database;
6> release channel c1;
7> release channel c2;
8> release channel c3;
9> }
10>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=144 devtype=DISK
allocated channel: c2
channel c2: sid=143 devtype=DISK
allocated channel: c3
channel c3: sid=142 devtype=DISK
Starting backup at 04-OCT-16
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00006 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\TEST.DBF
channel c1: starting piece 1 at 04-OCT-16
channel c2: starting compressed full datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\SYSTEM01.DBF
input datafile fno=00007 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\BRUCE.DBF
input datafile fno=00004 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\USERS01.DBF
channel c2: starting piece 1 at 04-OCT-16
channel c3: starting compressed full datafile backupset
channel c3: specifying datafile(s) in backupset
input datafile fno=00003 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\SYSAUX01.DBF
input datafile fno=00005 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\EXAMPLE01.DBF
input datafile fno=00002 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\UNDOTBS01.DBF
channel c3: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0PRHGIN9_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:04
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0SRHGIND_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0TRHGINF_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c3: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0RRHGINA_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c3: backup set complete, elapsed time: 00:00:10
channel c2: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0QRHGIN9_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c2: backup set complete, elapsed time: 00:00:18
Finished backup at 04-OCT-16
released channel: c1
released channel: c2
released channel: c3
Recovery Manager complete.
D:\oracle\product\arch\backup 的內容
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup as compressed backupset filesperset 3 tag 'pri_full_backup' format 'D:\oracle\product\arch\%T_%U' database;
release channel c1;
release channel c2;
release channel c3;
}
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 4 08:37:06 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: BRUCE (DBID=1667411)
RMAN> run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup as compressed backupset filesperset 2 tag 'pri_full_backup' format 'D:\oracle\product\arch\%T_%U' database;
6> release channel c1;
7> release channel c2;
8> release channel c3;
9> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=142 devtype=DISK
allocated channel: c2
channel c2: sid=143 devtype=DISK
allocated channel: c3
channel c3: sid=144 devtype=DISK
Starting backup at 04-OCT-16
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00006 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\TEST.DBF
channel c1: starting piece 1 at 04-OCT-16
channel c2: starting compressed full datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\SYSTEM01.DBF
input datafile fno=00004 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\USERS01.DBF
channel c2: starting piece 1 at 04-OCT-16
channel c3: starting compressed full datafile backupset
channel c3: specifying datafile(s) in backupset
input datafile fno=00003 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\SYSAUX01.DBF
input datafile fno=00007 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\BRUCE.DBF
channel c3: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0DRHGI38_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:06
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00005 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\EXAMPLE01.DBF
input datafile fno=00002 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\UNDOTBS01.DBF
channel c1: starting piece 1 at 04-OCT-16
channel c3: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0FRHGI38_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c3: backup set complete, elapsed time: 00:00:07
channel c3: starting compressed full datafile backupset
channel c3: specifying datafile(s) in backupset
including current control file in backupset
channel c3: starting piece 1 at 04-OCT-16
channel c3: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0HRHGI3F_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c3: starting compressed full datafile backupset
channel c3: specifying datafile(s) in backupset
including current SPFILE in backupset
channel c3: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0GRHGI3E_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:05
channel c3: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0IRHGI3H_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c2: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0ERHGI38_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c2: backup set complete, elapsed time: 00:00:18
Finished backup at 04-OCT-16
released channel: c1
released channel: c2
released channel: c3
======================================================================================================================
C:\Users\Admin>rman target / cmdfile=D:\oracle\product\arch\backup
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 4 08:48:31 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: BRUCE (DBID=1667411)
RMAN> run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup as compressed backupset filesperset 3 tag 'pri_full_backup' format 'D:\oracle\product\arch\%T_%U' database;
6> release channel c1;
7> release channel c2;
8> release channel c3;
9> }
10>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=144 devtype=DISK
allocated channel: c2
channel c2: sid=143 devtype=DISK
allocated channel: c3
channel c3: sid=142 devtype=DISK
Starting backup at 04-OCT-16
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00006 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\TEST.DBF
channel c1: starting piece 1 at 04-OCT-16
channel c2: starting compressed full datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\SYSTEM01.DBF
input datafile fno=00007 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\BRUCE.DBF
input datafile fno=00004 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\USERS01.DBF
channel c2: starting piece 1 at 04-OCT-16
channel c3: starting compressed full datafile backupset
channel c3: specifying datafile(s) in backupset
input datafile fno=00003 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\SYSAUX01.DBF
input datafile fno=00005 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\EXAMPLE01.DBF
input datafile fno=00002 name=D:\ORACLE\PRODUCT\ORADATA\BRUCE\UNDOTBS01.DBF
channel c3: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0PRHGIN9_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:04
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0SRHGIND_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 04-OCT-16
channel c1: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0TRHGINF_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c3: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0RRHGINA_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c3: backup set complete, elapsed time: 00:00:10
channel c2: finished piece 1 at 04-OCT-16
piece handle=D:\ORACLE\PRODUCT\ARCH\20161004_0QRHGIN9_1_1 tag=PRI_FULL_BACKUP comment=NONE
channel c2: backup set complete, elapsed time: 00:00:18
Finished backup at 04-OCT-16
released channel: c1
released channel: c2
released channel: c3
Recovery Manager complete.
D:\oracle\product\arch\backup 的內容
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup as compressed backupset filesperset 3 tag 'pri_full_backup' format 'D:\oracle\product\arch\%T_%U' database;
release channel c1;
release channel c2;
release channel c3;
}
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24237320/viewspace-2125843/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle RMAN備份指令碼Oracle指令碼
- oracle rman備份指令碼收集Oracle指令碼
- 分享Oracle Rman的備份指令碼Oracle指令碼
- oracle rman 定時備份指令碼Oracle指令碼
- [Oracle] rman備份的指令碼(1)Oracle指令碼
- ORACLE RMAN備份的指令碼配置Oracle指令碼
- rman 備份指令碼指令碼
- rman備份指令碼指令碼
- oracle11g Rman 備份指令碼Oracle指令碼
- rman備份和增量備份指令碼指令碼
- rman 全備份指令碼指令碼
- rman增量備份指令碼指令碼
- windows rman備份指令碼Windows指令碼
- RMAN常用備份指令碼指令碼
- oracle資料庫使用rman備份指令碼Oracle資料庫指令碼
- Oracle生產環境RMAN備份指令碼Oracle指令碼
- [Rman]Oracle Rman增量備份Level012指令碼Oracle指令碼
- 使用rman備份的指令碼指令碼
- Windows下RMAN備份指令碼Windows指令碼
- RMAN全庫備份指令碼指令碼
- RMAN備份Shel指令碼示例指令碼
- Rman備份的shell指令碼指令碼
- 【RMAN】RMAN備份恢復2 RMAN熱備指令碼與crontab計劃任務指令碼
- Oracle 11g RMAN multiplexing 備份指令碼Oracle指令碼
- RMAN定時全備份指令碼指令碼
- 轉貼：RMAN備份指令碼(Unix)指令碼
- rman 自動備份指令碼-windows指令碼Windows
- rman備份的shell指令碼(例子)指令碼
- ORACLE備份指令碼Oracle指令碼
- oracle 備份指令碼Oracle指令碼
- RAC模式下的備份策略以及RMAN備份指令碼模式指令碼
- Oracle 11g EXPDP、RMAN自動備份SHELL指令碼Oracle指令碼
- rman的備份檢視的指令碼指令碼
- linux 下RMAN備份shell指令碼Linux指令碼
- RMAN備份歸檔日誌指令碼指令碼
- windows下rman自動備份指令碼Windows指令碼
- RMAN備份恢復測試指令碼指令碼
- 【RMAN】RMAN備份恢復3 RMAN增量備份指令碼與crontab計劃任務指令碼