开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4071-12c管理类OCP认证班第一期 › 课程第27次（2016-12-21星期三）
返回列表 发新帖
查看: 1312|回复: 0

课程第27次（2016-12-21星期三）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-12-22 09:56:36 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2016-12-22 10:07 编辑

12c CLOUDCONTROL和12c OCP环境准备（12c bcpserver推送）

https://www.botangdb.com/forum.php?mod=viewthread&tid=658&extra=page%3D1

RMAN
配置前/后：
  1. RMAN> show all;

  3. using target database control file instead of recovery catalog
  4. RMAN configuration parameters for database with db_unique_name ORCL are:
  5. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  6. CONFIGURE BACKUP OPTIMIZATION ON;
  7. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  8. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  9. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  10. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  11. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  12. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  13. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  14. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  15. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  16. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  17. <font color="Red">CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  18. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  19. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  20. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  21. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  22. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  23. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  24. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';</font>
  25. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  26. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  27. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  28. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  29. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  30. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

复制代码


 1.png

2.png

3.png

RMAN输入决定并行度，并行度由通道来实现：

  1. [oracle@station6 ~]$ rman target /

  3. Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 22 05:13:28 2016

  5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  7. connected to target database: ORCL (DBID=1458753334)

  9. RMAN> show all;

  11. using target database control file instead of recovery catalog
  12. RMAN configuration parameters for database with db_unique_name ORCL are:
  13. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
  14. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  15. CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
  16. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  17. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  18. CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
  19. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  20. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  21. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  22. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  23. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  24. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  25. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  26. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  28. RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM  8 BACKUP TYPE TO BACKUPSET;

  30. new RMAN configuration parameters:
  31. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  32. new RMAN configuration parameters are successfully stored

  34. RMAN> exit


  37. Recovery Manager complete.
  38. [oracle@station6 ~]$ exit
  39. logout
  40. [root@station6 ~]# lsscsi -g
  41. [0:0:0:0]    disk    ATA      PLEXTOR PX-256M6 1.08  /dev/sda   /dev/sg0
  42. [5:0:0:0]    disk    ATA      WDC WD5000LPVX-2 1A01  /dev/sdb   /dev/sg1
  43. [6:0:0:0]    mediumx STK      L700             0105  /dev/sch0  /dev/sg10
  44. [6:0:1:0]    tape    IBM      ULT3580-TD5      0105  /dev/st0   /dev/sg2
  45. [6:0:2:0]    tape    IBM      ULT3580-TD5      0105  /dev/st1   /dev/sg3
  46. [6:0:3:0]    tape    IBM      ULT3580-TD4      0105  /dev/st2   /dev/sg4
  47. [6:0:4:0]    tape    IBM      ULT3580-TD4      0105  /dev/st3   /dev/sg5
  48. [6:0:8:0]    mediumx STK      L80              0105  /dev/sch1  /dev/sg11
  49. [6:0:9:0]    tape    STK      T10000B          0105  /dev/st4   /dev/sg6
  50. [6:0:10:0]   tape    STK      T10000B          0105  /dev/st5   /dev/sg7
  51. [6:0:11:0]   tape    STK      T10000B          0105  /dev/st6   /dev/sg8
  52. [6:0:12:0]   tape    STK      T10000B          0105  /dev/st7   /dev/sg9
  53. [root@station6 ~]# obtool
  54. Oracle Secure Backup 10.4.0.4.0
  55. Warning: auto-login failed - login token has expired
  56. login: admin
  57. Password:
  58. ob> lsdev
  59. library             lib01            in service         
  60.   drive 3           tape03           in service         
  61.   drive 4           tape04           in service         
  62. library             lib02            in service         
  63. ob> lsdev -g
  64. lib01:
  65.     Device type:            library
  66.     Model:                  [none]
  67.     Serial number:          XYZZY_A
  68.     In service:             yes
  69.     Debug mode:             no
  70.     Barcode reader:         default (hardware-selected)
  71.     Barcodes required:      no
  72.     Auto clean:             no
  73.     Clean interval:         (not set)
  74.     Clean using emptiest:   no
  75.     Ejection type:          auto
  76.     Min writable volumes:   0
  77.     UUID:                   a4f6cb3a-a737-1034-a178-089e01a5fcc4
  78.     Attachment 1:
  79.         Host:               station6
  80.         Raw device:         /dev/sg10
  81.     Connection type:        SCSI
  82.     Inquiry data:
  83.         Vendor:             STK
  84.         Product:            L700
  85.         Firmware:           0105
  86.         Serial number:      XYZZY_A
  87.     Element counts / addresses:
  88.         1 mte: 1
  89.        39 se : 1000 - 1038
  90.         4 iee: 10 - 13
  91.         4 dte: 500 - 503
  92.     Moves:
  93.        From mte, to: mte 1   se 1   iee 1   dte 1
  94.        From  se, to: mte 1   se 1   iee 1   dte 1
  95.        From iee, to: mte 1   se 1   iee 1   dte 1
  96.        From dte, to: mte 1   se 1   iee 1   dte 1
  97.     Ok_ops: move=1, reserve=1 sense_dev=1, sense_ele=1, unload_any=1, sense_dev_range=1
  98.     Device characteristics: two_d=0, is_120=0, fake_mte=1, fake_iee=0, one_target=0
  99.     State of barcode reader: present
  100.     Display:  none
  101.     Dte  1:   target *   lun * no drive configured in dte
  102.     Dte  2:   target *   lun * no drive configured in dte
  103.     Dte  3:   target *   lun * name tape03 (raw device name /dev/sg4)
  104.     Dte  4:   target *   lun * name tape04 (raw device name /dev/sg5)
  105.       Warning: bus info unknown or drive not installed
  106. tape03:
  107.     Device type:            tape
  108.     Model:                  [none]
  109.     Serial number:          XYZZY_A3
  110.     In service:             yes
  111.     Library:                lib01
  112.     DTE:                    3
  113.     Automount:              yes
  114.     Error rate:             8
  115.     Query frequency:        131072KB (134217728 bytes) (from driver)
  116.     Debug mode:             no
  117.     Blocking factor:        (default)
  118.     Max blocking factor:    (default)
  119.     Current tape:           [unknown]
  120.     Use list:               all
  121.     Drive usage:            none
  122.     Cleaning required:      no
  123.     UUID:                   f0528ccc-a737-1034-a178-089e01a5fcc4
  124.     Attachment 1:
  125.         Host:               station6
  126.         Raw device:         /dev/sg4
  127.     Connection type:        SCSI
  128.     Inquiry data:
  129.         Vendor:             IBM
  130.         Product:            ULT3580-TD4
  131.         Firmware:           0105
  132.         Serial number:      XYZZY_A3
  133.     Tape state:             offline
  134.     Hardware compression:   on
  135.     Last read was:          uncompressed
  136.     Hardware encryption:    not available
  137.     Maximum block size:     2097152
  138. tape04:
  139.     Device type:            tape
  140.     Model:                  [none]
  141.     Serial number:          XYZZY_A4
  142.     In service:             yes
  143.     Library:                lib01
  144.     DTE:                    4
  145.     Automount:              yes
  146.     Error rate:             8
  147.     Query frequency:        131072KB (134217728 bytes) (from driver)
  148.     Debug mode:             no
  149.     Blocking factor:        (default)
  150.     Max blocking factor:    (default)
  151.     Current tape:           [unknown]
  152.     Use list:               all
  153.     Drive usage:            none
  154.     Cleaning required:      no
  155.     UUID:                   f5ae5f98-a737-1034-a178-089e01a5fcc4
  156.     Attachment 1:
  157.         Host:               station6
  158.         Raw device:         /dev/sg5
  159.     Connection type:        SCSI
  160.     Inquiry data:
  161.         Vendor:             IBM
  162.         Product:            ULT3580-TD4
  163.         Firmware:           0105
  164.         Serial number:      XYZZY_A4
  165.     Tape state:             offline
  166.     Hardware compression:   on
  167.     Last read was:          uncompressed
  168.     Hardware encryption:    not available
  169.     Maximum block size:     2097152
  170. lib02:
  171.     Device type:            library
  172.     Model:                  [none]
  173.     Serial number:          XYZZY_B
  174.     In service:             yes
  175.     Debug mode:             no
  176.     Barcode reader:         default (hardware-selected)
  177.     Barcodes required:      no
  178.     Auto clean:             no
  179.     Clean interval:         (not set)
  180.     Clean using emptiest:   no
  181.     Ejection type:          auto
  182.     Min writable volumes:   0
  183.     UUID:                   d772fe58-a737-1034-a178-089e01a5fcc4
  184.     Attachment 1:
  185.         Host:               station6
  186.         Raw device:         /dev/sg11
  187.     Connection type:        SCSI
  188.     Inquiry data:
  189.         Vendor:             STK
  190.         Product:            L80
  191.         Firmware:           0105
  192.         Serial number:      XYZZY_B
  193.     Element counts / addresses:
  194.         1 mte: 1
  195.        40 se : 1000 - 1039
  196.         4 iee: 10 - 13
  197.         4 dte: 500 - 503
  198.     Moves:
  199.        From mte, to: mte 1   se 1   iee 1   dte 1
  200.        From  se, to: mte 1   se 1   iee 1   dte 1
  201.        From iee, to: mte 1   se 1   iee 1   dte 1
  202.        From dte, to: mte 1   se 1   iee 1   dte 1
  203.     Ok_ops: move=1, reserve=1 sense_dev=1, sense_ele=1, unload_any=1, sense_dev_range=1
  204.     Device characteristics: two_d=0, is_120=0, fake_mte=1, fake_iee=0, one_target=0
  205.     State of barcode reader: present
  206.     Display:  none
  207.     Dte  1:   target *   lun * no drive configured in dte
  208.     Dte  2:   target *   lun * no drive configured in dte
  209.     Dte  3:   target *   lun * no drive configured in dte
  210.     Dte  4:   target *   lun * no drive configured in dte
  211.       Warning: bus info unknown or drive not installed
  212. ob> inventory -L lib01
  213. ob> exit
  214. [root@station6 ~]# su - oracle
  215. [oracle@station6 ~]$ rman target /

  217. Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 22 05:20:22 2016

  219. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  221. connected to target database: ORCL (DBID=1458753334)

  223. RMAN> show all;

  225. using target database control file instead of recovery catalog
  226. RMAN configuration parameters for database with db_unique_name ORCL are:
  227. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
  228. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  229. CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
  230. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  231. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  232. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  233. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  234. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  235. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  236. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  237. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  238. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  239. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  240. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  242. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO  sbt;

  244. new RMAN configuration parameters:
  245. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  246. new RMAN configuration parameters are successfully stored

  248. RMAN> backup tablespace users;

  250. Starting backup at 22-DEC-16
  251. allocated channel: ORA_SBT_TAPE_1
  252. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
  253. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  254. channel ORA_SBT_TAPE_1: starting full datafile backup set
  255. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  256. RMAN-00571: ===========================================================
  257. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  258. RMAN-00571: ===========================================================
  259. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 12/22/2016 05:20:50
  260. ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

  262. RMAN> exit


  265. Recovery Manager complete.
  266. [oracle@station6 ~]$ sqlplus /nolog

  268. SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 22 05:20:59 2016

  270. Copyright (c) 1982, 2013, Oracle.  All rights reserved.

  272. SQL> conn / as sysdba
  273. Connected.
  274. SQL> shutdown immediate
  275. Database closed.
  276. Database dismounted.
  277. ORACLE instance shut down.
  278. SQL> startup mount
  279. ORACLE instance started.

  281. Total System Global Area 6530596864 bytes
  282. Fixed Size                    2265504 bytes
  283. Variable Size                 3472887392 bytes
  284. Database Buffers         3036676096 bytes
  285. Redo Buffers                   18767872 bytes
  286. Database mounted.
  287. SQL> alter database archivelog ;

  289. Database altered.

  291. SQL> alter database open ;
  292.    
  293. Database altered.

  295. SQL> exit
  296. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  297. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  298. Data Mining and Real Application Testing options
  299. [oracle@station6 ~]$ rman target /

  301. Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 22 05:21:55 2016

  303. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  305. connected to target database: ORCL (DBID=1458753334)

  307. RMAN> show all;

  309. using target database control file instead of recovery catalog
  310. RMAN configuration parameters for database with db_unique_name ORCL are:
  311. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
  312. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  313. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  314. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  315. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  316. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  317. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  318. CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
  319. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  320. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  321. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  322. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  323. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  324. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  325. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  326. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  327. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  328. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  330. RMAN> CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM  8 BACKUP TYPE TO BACKUPSET;

  332. new RMAN configuration parameters:
  333. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  334. new RMAN configuration parameters are successfully stored

  336. RMAN> show all;

  338. RMAN configuration parameters for database with db_unique_name ORCL are:
  339. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
  340. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  341. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  342. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  343. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  344. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  345. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  346. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  347. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  348. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  349. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  350. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  351. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  352. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  353. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  354. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  355. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  356. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  358. RMAN> backup tablespace users;

  360. Starting backup at 22-DEC-16
  361. allocated channel: ORA_SBT_TAPE_1
  362. channel ORA_SBT_TAPE_1: SID=10 device type=SBT_TAPE
  363. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  364. allocated channel: ORA_SBT_TAPE_2
  365. channel ORA_SBT_TAPE_2: SID=75 device type=SBT_TAPE
  366. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  367. allocated channel: ORA_SBT_TAPE_3
  368. channel ORA_SBT_TAPE_3: SID=140 device type=SBT_TAPE
  369. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  370. allocated channel: ORA_SBT_TAPE_4
  371. channel ORA_SBT_TAPE_4: SID=203 device type=SBT_TAPE
  372. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  373. allocated channel: ORA_SBT_TAPE_5
  374. channel ORA_SBT_TAPE_5: SID=15 device type=SBT_TAPE
  375. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  376. allocated channel: ORA_SBT_TAPE_6
  377. channel ORA_SBT_TAPE_6: SID=76 device type=SBT_TAPE
  378. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  379. allocated channel: ORA_SBT_TAPE_7
  380. channel ORA_SBT_TAPE_7: SID=141 device type=SBT_TAPE
  381. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  382. allocated channel: ORA_SBT_TAPE_8
  383. channel ORA_SBT_TAPE_8: SID=204 device type=SBT_TAPE
  384. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  385. channel ORA_SBT_TAPE_1: starting full datafile backup set
  386. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  387. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.930972515
  388. channel ORA_SBT_TAPE_1: starting piece 1 at 22-DEC-16
  389. channel ORA_SBT_TAPE_1: finished piece 1 at 22-DEC-16
  390. piece handle=02ro34o2_1_1 tag=TAG20161222T052418 comment=API Version 2.0,MMS Version 10.4.0.4
  391. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
  392. Finished backup at 22-DEC-16

  394. RMAN> list backup;


  397. List of Backup Sets
  398. ===================


  401. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  402. ------- ---- -- ---------- ----------- ------------ ---------------
  403. 1       Full    3.31M      SBT_TAPE    00:00:15     22-DEC-16      
  404.         BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20161222T052418
  405.         Handle: 02ro34o2_1_1   Media: RMAN-DEFAULT-000001
  406.   List of Datafiles in backup set 1
  407.   File LV Type Ckp SCN    Ckp Time  Name
  408.   ---- -- ---- ---------- --------- ----
  409.   4       Full 1083306    22-DEC-16 +DATA/orcl/datafile/users.259.930972515

  411. RMAN> delete backupset 1;

  413. allocated channel: ORA_DISK_1
  414. channel ORA_DISK_1: SID=63 device type=DISK
  415. allocated channel: ORA_DISK_2
  416. channel ORA_DISK_2: SID=7 device type=DISK
  417. allocated channel: ORA_DISK_3
  418. channel ORA_DISK_3: SID=77 device type=DISK
  419. allocated channel: ORA_DISK_4
  420. channel ORA_DISK_4: SID=142 device type=DISK
  421. allocated channel: ORA_DISK_5
  422. channel ORA_DISK_5: SID=206 device type=DISK
  423. allocated channel: ORA_DISK_6
  424. channel ORA_DISK_6: SID=17 device type=DISK
  425. allocated channel: ORA_DISK_7
  426. channel ORA_DISK_7: SID=78 device type=DISK
  427. allocated channel: ORA_DISK_8
  428. channel ORA_DISK_8: SID=143 device type=DISK
  429. using channel ORA_SBT_TAPE_1
  430. using channel ORA_SBT_TAPE_2
  431. using channel ORA_SBT_TAPE_3
  432. using channel ORA_SBT_TAPE_4
  433. using channel ORA_SBT_TAPE_5
  434. using channel ORA_SBT_TAPE_6
  435. using channel ORA_SBT_TAPE_7
  436. using channel ORA_SBT_TAPE_8

  438. List of Backup Pieces
  439. BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
  440. ------- ------- --- --- ----------- ----------- ----------
  441. 1       1       1   1   AVAILABLE   SBT_TAPE    02ro34o2_1_1

  443. Do you really want to delete the above objects (enter YES or NO)? YES
  444. deleted backup piece
  445. backup piece handle=02ro34o2_1_1 RECID=1 STAMP=931238658
  446. Deleted 1 objects


  449. RMAN> show all;

  451. RMAN configuration parameters for database with db_unique_name ORCL are:
  452. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
  453. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  454. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  455. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  456. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  457. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  458. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  459. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  460. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  461. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  462. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  463. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  464. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  465. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  466. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  467. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  468. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  469. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  471. RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE'    PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';

  473. new RMAN configuration parameters:
  474. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  475. new RMAN configuration parameters are successfully stored
  476. released channel: ORA_DISK_1
  477. released channel: ORA_DISK_2
  478. released channel: ORA_DISK_3
  479. released channel: ORA_DISK_4
  480. released channel: ORA_DISK_5
  481. released channel: ORA_DISK_6
  482. released channel: ORA_DISK_7
  483. released channel: ORA_DISK_8
  484. released channel: ORA_SBT_TAPE_1
  485. released channel: ORA_SBT_TAPE_2
  486. released channel: ORA_SBT_TAPE_3
  487. released channel: ORA_SBT_TAPE_4
  488. released channel: ORA_SBT_TAPE_5
  489. released channel: ORA_SBT_TAPE_6
  490. released channel: ORA_SBT_TAPE_7
  491. released channel: ORA_SBT_TAPE_8

  493. RMAN> show all;

  495. RMAN configuration parameters for database with db_unique_name ORCL are:
  496. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
  497. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  498. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  499. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  500. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  501. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  502. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  503. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  504. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  505. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  506. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  507. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  508. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  509. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  510. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  511. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  512. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  513. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  514. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  516. RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';

  518. new RMAN configuration parameters:
  519. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  520. new RMAN configuration parameters are successfully stored

  522. RMAN>  CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';

  524. new RMAN configuration parameters:
  525. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  526. new RMAN configuration parameters are successfully stored

  528. RMAN> CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';

  530. new RMAN configuration parameters:
  531. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  532. new RMAN configuration parameters are successfully stored

  534. RMAN> CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';

  536. new RMAN configuration parameters:
  537. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  538. new RMAN configuration parameters are successfully stored

  540. RMAN> CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';


  543. new RMAN configuration parameters:
  544. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  545. new RMAN configuration parameters are successfully stored

  547. RMAN>
  548. RMAN> CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';

  550. new RMAN configuration parameters:
  551. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  552. new RMAN configuration parameters are successfully stored

  554. RMAN> CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';

  556. new RMAN configuration parameters:
  557. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  558. new RMAN configuration parameters are successfully stored

  560. RMAN> show all;

  562. RMAN configuration parameters for database with db_unique_name ORCL are:
  563. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
  564. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  565. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  566. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  567. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  568. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  569. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  570. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  571. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  572. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  573. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  574. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  575. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  576. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  577. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  578. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  579. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  580. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  581. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  582. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station6)';
  583. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  584. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  585. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  586. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  587. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  588. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  590. RMAN> delete backup;         

  592. allocated channel: ORA_DISK_1
  593. channel ORA_DISK_1: SID=10 device type=DISK
  594. allocated channel: ORA_DISK_2
  595. channel ORA_DISK_2: SID=75 device type=DISK
  596. allocated channel: ORA_DISK_3
  597. channel ORA_DISK_3: SID=140 device type=DISK
  598. allocated channel: ORA_DISK_4
  599. channel ORA_DISK_4: SID=203 device type=DISK
  600. allocated channel: ORA_DISK_5
  601. channel ORA_DISK_5: SID=15 device type=DISK
  602. allocated channel: ORA_DISK_6
  603. channel ORA_DISK_6: SID=76 device type=DISK
  604. allocated channel: ORA_DISK_7
  605. channel ORA_DISK_7: SID=141 device type=DISK
  606. allocated channel: ORA_DISK_8
  607. channel ORA_DISK_8: SID=204 device type=DISK
  608. allocated channel: ORA_SBT_TAPE_1
  609. channel ORA_SBT_TAPE_1: SID=63 device type=SBT_TAPE
  610. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  611. allocated channel: ORA_SBT_TAPE_2
  612. channel ORA_SBT_TAPE_2: SID=7 device type=SBT_TAPE
  613. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  614. allocated channel: ORA_SBT_TAPE_3
  615. channel ORA_SBT_TAPE_3: SID=77 device type=SBT_TAPE
  616. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  617. allocated channel: ORA_SBT_TAPE_4
  618. channel ORA_SBT_TAPE_4: SID=142 device type=SBT_TAPE
  619. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  620. allocated channel: ORA_SBT_TAPE_5
  621. channel ORA_SBT_TAPE_5: SID=206 device type=SBT_TAPE
  622. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  623. allocated channel: ORA_SBT_TAPE_6
  624. channel ORA_SBT_TAPE_6: SID=17 device type=SBT_TAPE
  625. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  626. allocated channel: ORA_SBT_TAPE_7
  627. channel ORA_SBT_TAPE_7: SID=78 device type=SBT_TAPE
  628. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  629. allocated channel: ORA_SBT_TAPE_8
  630. channel ORA_SBT_TAPE_8: SID=143 device type=SBT_TAPE
  631. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  632. specification does not match any backup in the repository

  634. RMAN> list copy;

  636. specification does not match any datafile copy in the repository
  637. specification does not match any control file copy in the repository
  638. specification does not match any archived log in the repository

  640. RMAN> list copy;  

  642. specification does not match any datafile copy in the repository
  643. specification does not match any control file copy in the repository
  644. List of Archived Log Copies for database with db_unique_name ORCL
  645. =====================================================================

  647. Key     Thrd Seq     S Low Time
  648. ------- ---- ------- - ---------
  649. 1       1    11      A 22-DEC-16
  650.         Name: +FRA/orcl/archivelog/2016_12_22/thread_1_seq_11.260.931239623


  653. RMAN> delete copy ;

  655. released channel: ORA_DISK_1
  656. released channel: ORA_DISK_2
  657. released channel: ORA_DISK_3
  658. released channel: ORA_DISK_4
  659. released channel: ORA_DISK_5
  660. released channel: ORA_DISK_6
  661. released channel: ORA_DISK_7
  662. released channel: ORA_DISK_8
  663. released channel: ORA_SBT_TAPE_1
  664. released channel: ORA_SBT_TAPE_2
  665. released channel: ORA_SBT_TAPE_3
  666. released channel: ORA_SBT_TAPE_4
  667. released channel: ORA_SBT_TAPE_5
  668. released channel: ORA_SBT_TAPE_6
  669. released channel: ORA_SBT_TAPE_7
  670. released channel: ORA_SBT_TAPE_8
  671. allocated channel: ORA_DISK_1
  672. channel ORA_DISK_1: SID=10 device type=DISK
  673. allocated channel: ORA_DISK_2
  674. channel ORA_DISK_2: SID=75 device type=DISK
  675. allocated channel: ORA_DISK_3
  676. channel ORA_DISK_3: SID=140 device type=DISK
  677. allocated channel: ORA_DISK_4
  678. channel ORA_DISK_4: SID=203 device type=DISK
  679. allocated channel: ORA_DISK_5
  680. channel ORA_DISK_5: SID=15 device type=DISK
  681. allocated channel: ORA_DISK_6
  682. channel ORA_DISK_6: SID=76 device type=DISK
  683. allocated channel: ORA_DISK_7
  684. channel ORA_DISK_7: SID=141 device type=DISK
  685. allocated channel: ORA_DISK_8
  686. channel ORA_DISK_8: SID=204 device type=DISK
  687. specification does not match any datafile copy in the repository
  688. specification does not match any control file copy in the repository
  689. List of Archived Log Copies for database with db_unique_name ORCL
  690. =====================================================================

  692. Key     Thrd Seq     S Low Time
  693. ------- ---- ------- - ---------
  694. 1       1    11      A 22-DEC-16
  695.         Name: +FRA/orcl/archivelog/2016_12_22/thread_1_seq_11.260.931239623


  698. Do you really want to delete the above objects (enter YES or NO)? YES
  699. deleted archived log
  700. archived log file name=+FRA/orcl/archivelog/2016_12_22/thread_1_seq_11.260.931239623 RECID=1 STAMP=931239623
  701. Deleted 1 objects


  704. RMAN> backup tag '1T_INCR0_WHOLE' incremental level 0 database plus archivelog delete all input;


  707. Starting backup at 22-DEC-16
  708. current log archived
  709. released channel: ORA_DISK_1
  710. released channel: ORA_DISK_2
  711. released channel: ORA_DISK_3
  712. released channel: ORA_DISK_4
  713. released channel: ORA_DISK_5
  714. released channel: ORA_DISK_6
  715. released channel: ORA_DISK_7
  716. released channel: ORA_DISK_8
  717. allocated channel: ORA_SBT_TAPE_1
  718. channel ORA_SBT_TAPE_1: SID=10 device type=SBT_TAPE
  719. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  720. allocated channel: ORA_SBT_TAPE_2
  721. channel ORA_SBT_TAPE_2: SID=75 device type=SBT_TAPE
  722. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  723. allocated channel: ORA_SBT_TAPE_3
  724. channel ORA_SBT_TAPE_3: SID=140 device type=SBT_TAPE
  725. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  726. allocated channel: ORA_SBT_TAPE_4
  727. channel ORA_SBT_TAPE_4: SID=203 device type=SBT_TAPE
  728. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  729. allocated channel: ORA_SBT_TAPE_5
  730. channel ORA_SBT_TAPE_5: SID=15 device type=SBT_TAPE
  731. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  732. allocated channel: ORA_SBT_TAPE_6
  733. channel ORA_SBT_TAPE_6: SID=76 device type=SBT_TAPE
  734. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  735. allocated channel: ORA_SBT_TAPE_7
  736. channel ORA_SBT_TAPE_7: SID=141 device type=SBT_TAPE
  737. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  738. allocated channel: ORA_SBT_TAPE_8
  739. channel ORA_SBT_TAPE_8: SID=204 device type=SBT_TAPE
  740. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  741. channel ORA_SBT_TAPE_1: starting archived log backup set
  742. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  743. input archived log thread=1 sequence=12 RECID=2 STAMP=931240086
  744. channel ORA_SBT_TAPE_1: starting piece 1 at 22-DEC-16
  745. channel ORA_SBT_TAPE_1: finished piece 1 at 22-DEC-16
  746. piece handle=03ro364o_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  747. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  748. channel ORA_SBT_TAPE_1: deleting archived log(s)
  749. archived log file name=+FRA/orcl/archivelog/2016_12_22/thread_1_seq_12.260.931240087 RECID=2 STAMP=931240086
  750. Finished backup at 22-DEC-16

  752. Starting backup at 22-DEC-16
  753. using channel ORA_SBT_TAPE_1
  754. using channel ORA_SBT_TAPE_2
  755. using channel ORA_SBT_TAPE_3
  756. using channel ORA_SBT_TAPE_4
  757. using channel ORA_SBT_TAPE_5
  758. using channel ORA_SBT_TAPE_6
  759. using channel ORA_SBT_TAPE_7
  760. using channel ORA_SBT_TAPE_8
  761. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  762. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  763. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.930972515
  764. channel ORA_SBT_TAPE_1: starting piece 1 at 22-DEC-16
  765. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  766. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  767. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.930972515
  768. channel ORA_SBT_TAPE_2: starting piece 1 at 22-DEC-16
  769. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
  770. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
  771. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.930972603
  772. channel ORA_SBT_TAPE_3: starting piece 1 at 22-DEC-16
  773. channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
  774. channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
  775. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.930972515
  776. channel ORA_SBT_TAPE_4: starting piece 1 at 22-DEC-16
  777. channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
  778. channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
  779. channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
  780. channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
  781. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.930972515
  782. channel ORA_SBT_TAPE_6: starting piece 1 at 22-DEC-16
  783. channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
  784. channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
  785. including current SPFILE in backup set
  786. channel ORA_SBT_TAPE_7: starting piece 1 at 22-DEC-16
  787. including current control file in backup set
  788. channel ORA_SBT_TAPE_5: starting piece 1 at 22-DEC-16
  789. channel ORA_SBT_TAPE_1: finished piece 1 at 22-DEC-16
  790. piece handle=04ro365i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  791. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  792. channel ORA_SBT_TAPE_2: finished piece 1 at 22-DEC-16
  793. piece handle=05ro365i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  794. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  795. channel ORA_SBT_TAPE_4: finished piece 1 at 22-DEC-16
  796. piece handle=07ro365i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  797. channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:45
  798. channel ORA_SBT_TAPE_6: finished piece 1 at 22-DEC-16
  799. piece handle=09ro365i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  800. channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:00:45
  801. channel ORA_SBT_TAPE_3: finished piece 1 at 22-DEC-16
  802. piece handle=06ro365i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  803. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:55
  804. channel ORA_SBT_TAPE_5: finished piece 1 at 22-DEC-16
  805. piece handle=08ro365i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  806. channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:05
  807. channel ORA_SBT_TAPE_7: finished piece 1 at 22-DEC-16
  808. piece handle=0aro365i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  809. channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:01:05
  810. Finished backup at 22-DEC-16

  812. Starting backup at 22-DEC-16
  813. current log archived
  814. using channel ORA_SBT_TAPE_1
  815. using channel ORA_SBT_TAPE_2
  816. using channel ORA_SBT_TAPE_3
  817. using channel ORA_SBT_TAPE_4
  818. using channel ORA_SBT_TAPE_5
  819. using channel ORA_SBT_TAPE_6
  820. using channel ORA_SBT_TAPE_7
  821. using channel ORA_SBT_TAPE_8
  822. channel ORA_SBT_TAPE_1: starting archived log backup set
  823. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  824. input archived log thread=1 sequence=13 RECID=3 STAMP=931240179
  825. channel ORA_SBT_TAPE_1: starting piece 1 at 22-DEC-16
  826. channel ORA_SBT_TAPE_1: finished piece 1 at 22-DEC-16
  827. piece handle=0bro367j_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  828. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16
  829. channel ORA_SBT_TAPE_1: deleting archived log(s)
  830. archived log file name=+FRA/orcl/archivelog/2016_12_22/thread_1_seq_13.260.931240179 RECID=3 STAMP=931240179
  831. Finished backup at 22-DEC-16

  833. RMAN> list backup;


  836. List of Backup Sets
  837. ===================


  840. BS Key  Size       Device Type Elapsed Time Completion Time
  841. ------- ---------- ----------- ------------ ---------------
  842. 2       320.00K    SBT_TAPE    00:00:23     22-DEC-16      
  843.         BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  844.         Handle: 03ro364o_1_1   Media: station6-000001

  846.   List of Archived Logs in backup set 2
  847.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  848.   ---- ------- ---------- --------- ---------- ---------
  849.   1    12      1085365    22-DEC-16 1085835    22-DEC-16

  851. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  852. ------- ---- -- ---------- ----------- ------------ ---------------
  853. 3       Incr 0  638.63M    SBT_TAPE    00:00:20     22-DEC-16      
  854.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  855.         Handle: 04ro365i_1_1   Media: station6-000001
  856.   List of Datafiles in backup set 3
  857.   File LV Type Ckp SCN    Ckp Time  Name
  858.   ---- -- ---- ---------- --------- ----
  859.   1    0  Incr 1085882    22-DEC-16 +DATA/orcl/datafile/system.256.930972515

  861. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  862. ------- ---- -- ---------- ----------- ------------ ---------------
  863. 4       Incr 0  408.00M    SBT_TAPE    00:00:25     22-DEC-16      
  864.         BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  865.         Handle: 05ro365i_1_1   Media: station6-000002
  866.   List of Datafiles in backup set 4
  867.   File LV Type Ckp SCN    Ckp Time  Name
  868.   ---- -- ---- ---------- --------- ----
  869.   2    0  Incr 1085883    22-DEC-16 +DATA/orcl/datafile/sysaux.257.930972515

  871. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  872. ------- ---- -- ---------- ----------- ------------ ---------------
  873. 5       Incr 0  3.31M      SBT_TAPE    00:00:36     22-DEC-16      
  874.         BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  875.         Handle: 09ro365i_1_1   Media: station6-000001
  876.   List of Datafiles in backup set 5
  877.   File LV Type Ckp SCN    Ckp Time  Name
  878.   ---- -- ---- ---------- --------- ----
  879.   4    0  Incr 1085886    22-DEC-16 +DATA/orcl/datafile/users.259.930972515

  881. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  882. ------- ---- -- ---------- ----------- ------------ ---------------
  883. 6       Incr 0  12.69M     SBT_TAPE    00:00:42     22-DEC-16      
  884.         BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  885.         Handle: 07ro365i_1_1   Media: station6-000002
  886.   List of Datafiles in backup set 6
  887.   File LV Type Ckp SCN    Ckp Time  Name
  888.   ---- -- ---- ---------- --------- ----
  889.   3    0  Incr 1085885    22-DEC-16 +DATA/orcl/datafile/undotbs1.258.930972515

  891. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  892. ------- ---- -- ---------- ----------- ------------ ---------------
  893. 7       Incr 0  68.19M     SBT_TAPE    00:00:49     22-DEC-16      
  894.         BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  895.         Handle: 06ro365i_1_1   Media: station6-000001
  896.   List of Datafiles in backup set 7
  897.   File LV Type Ckp SCN    Ckp Time  Name
  898.   ---- -- ---- ---------- --------- ----
  899.   5    0  Incr 1085884    22-DEC-16 +DATA/orcl/datafile/example.265.930972603

  901. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  902. ------- ---- -- ---------- ----------- ------------ ---------------
  903. 8       Incr 0  9.38M      SBT_TAPE    00:00:55     22-DEC-16      
  904.         BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  905.         Handle: 08ro365i_1_1   Media: station6-000002
  906.   Control File Included: Ckp SCN: 1085885      Ckp time: 22-DEC-16

  908. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  909. ------- ---- -- ---------- ----------- ------------ ---------------
  910. 9       Incr 0  128.00K    SBT_TAPE    00:01:02     22-DEC-16      
  911.         BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  912.         Handle: 0aro365i_1_1   Media: station6-000001
  913.   SPFILE Included: Modification time: 22-DEC-16
  914.   SPFILE db_unique_name: ORCL

  916. BS Key  Size       Device Type Elapsed Time Completion Time
  917. ------- ---------- ----------- ------------ ---------------
  918. 10      192.00K    SBT_TAPE    00:00:15     22-DEC-16      
  919.         BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  920.         Handle: 0bro367j_1_1   Media: station6-000001

  922.   List of Archived Logs in backup set 10
  923.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  924.   ---- ------- ---------- --------- ---------- ---------
  925.   1    13      1085835    22-DEC-16 1085978    22-DEC-16
复制代码
backup tag '1T_INCR0_WHOLE' incremental level 0 database plus archivelog delete all input;这条命令前后各有一次归档
  1. [root@station6 stage]# su - oracle
  2. [oracle@station6 ~]$ sqlplus /nolog

  4. SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 22 05:39:50 2016

  6. Copyright (c) 1982, 2013, Oracle.  All rights reserved.

  8. SQL> conn / as sysdba
  9. Connected.
  10. SQL> alter system switch logfile;

  12. System altered.

  14. SQL> archive log list
  15. Database log mode               Archive Mode
  16. Automatic archival               Enabled
  17. Archive destination               USE_DB_RECOVERY_FILE_DEST
  18. Oldest online log sequence     10
  19. Next log sequence to archive   12
  20. Current log sequence               <font size="5">12</font>
  21. SQL> exit
  22. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  23. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  24. Data Mining and Real Application Testing options
  25. [oracle@station6 ~]$ su -
  26. Password:
  27. [root@station6 ~]# obtool  
  28. ob> lsjob
  29. Job ID           Sched time  Contents                       State
  30. ---------------- ----------- ------------------------------ ---------------------------------------
  31. oracle/3         none        database orcl (dbid=1458753334) processed; Oracle job(s) scheduled
  32. oracle/3.3       none        incremental backup             running since 2016/12/22.05:48
  33. oracle/3.4       none        incremental backup             running since 2016/12/22.05:48
  34. oracle/3.5       none        incremental backup             pending resource availability
  35. oracle/3.6       none        incremental backup             pending resource availability
  36. oracle/3.7       none        incremental backup             pending resource availability
  37. ob> ^[[A
  38. ob> r: unknown command,
  39. ob>
  40. ob>
  41. ob> lsjob
  42. Job ID           Sched time  Contents                       State
  43. ---------------- ----------- ------------------------------ ---------------------------------------
  44. oracle/3         none        database orcl (dbid=1458753334) processed; Oracle job(s) scheduled
  45. oracle/3.5       none        incremental backup             running since 2016/12/22.05:49
  46. oracle/3.6       none        incremental backup             running since 2016/12/22.05:49
  47. oracle/3.7       none        incremental backup             pending resource availability
  48. ob> exit
  49. [root@station6 ~]# su - oracle
  50. [oracle@station6 ~]$ sqlplus /nolog

  52. SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 22 05:52:49 2016

  54. Copyright (c) 1982, 2013, Oracle.  All rights reserved.

  56. SQL> conn / as sysdba
  57. Connected.
  58. SQL> archive log list
  59. Database log mode               Archive Mode
  60. Automatic archival               Enabled
  61. Archive destination               USE_DB_RECOVERY_FILE_DEST
  62. Oldest online log sequence     12
  63. Next log sequence to archive   14
  64. Current log sequence               <font size="5">14</font>
  65. SQL> Write failed: Broken pipe
  66. [root@station90 mhvtl]#
复制代码


回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2025-2-3 05:42 , Processed in 0.073185 second(s), 27 queries .

快速回复 返回顶部 返回列表