课程第28次（2018-04-11星期三）

botang · 发表于 2018-4-11 20:13:14

RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

复制代码

Daily Script:
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA_OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
release channel oem_disk_backup;
allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
backup archivelog all not backed up;
}
allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
Weekly Script:
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA_OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
release channel oem_disk_backup;
allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
backup recovery area;
}
allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';

复制代码

第一天：

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 11 21:15:27 2018
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: ORCL (DBID=1343950367)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> run {
2> allocate channel oem_disk_backup device type disk;
3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
4> backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
5> release channel oem_disk_backup;
6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
8> backup archivelog all not backed up;
9> }
allocated channel: oem_disk_backup
channel oem_disk_backup: SID=195 device type=DISK
Starting recover at 11-APR-18
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
Finished recover at 11-APR-18
Starting backup at 11-APR-18
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 5 found
no parent backup or copy of datafile 4 found
channel oem_disk_backup: starting datafile copy
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
output file name=+FRA/orcl/datafile/sysaux.277.973199731 tag=ORA_OEM_LEVEL_0 RECID=2 STAMP=973199735
channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:07
channel oem_disk_backup: starting datafile copy
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
output file name=+FRA/orcl/datafile/system.267.973199737 tag=ORA_OEM_LEVEL_0 RECID=3 STAMP=973199741
channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:07
channel oem_disk_backup: starting datafile copy
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.972833355
output file name=+FRA/orcl/datafile/undotbs1.262.973199745 tag=ORA_OEM_LEVEL_0 RECID=4 STAMP=973199745
channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:03
channel oem_disk_backup: starting datafile copy
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
output file name=+FRA/orcl/datafile/example.351.973199747 tag=ORA_OEM_LEVEL_0 RECID=5 STAMP=973199748
channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:03
channel oem_disk_backup: starting datafile copy
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
output file name=+FRA/orcl/datafile/users.350.973199751 tag=ORA_OEM_LEVEL_0 RECID=6 STAMP=973199751
channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
Finished backup at 11-APR-18
Starting Control File and SPFILE Autobackup at 11-APR-18
piece handle=+FRA/orcl/autobackup/2018_04_11/s_973199752.349.973199753 comment=NONE
Finished Control File and SPFILE Autobackup at 11-APR-18
released channel: oem_disk_backup
allocated channel: oem_sbt_backup1
channel oem_sbt_backup1: SID=195 device type=SBT_TAPE
channel oem_sbt_backup1: Oracle Secure Backup
allocated channel: oem_sbt_backup2
channel oem_sbt_backup2: SID=200 device type=SBT_TAPE
channel oem_sbt_backup2: Oracle Secure Backup
Starting backup at 11-APR-18
current log archived
channel oem_sbt_backup1: starting archived log backup set
channel oem_sbt_backup1: specifying archived log(s) in backup set
input archived log thread=1 sequence=81 RECID=95 STAMP=973198807
input archived log thread=1 sequence=82 RECID=96 STAMP=973198817
channel oem_sbt_backup1: starting piece 1 at 11-APR-18
channel oem_sbt_backup2: starting archived log backup set
channel oem_sbt_backup2: specifying archived log(s) in backup set
input archived log thread=1 sequence=83 RECID=97 STAMP=973199765
channel oem_sbt_backup2: starting piece 1 at 11-APR-18
channel oem_sbt_backup1: finished piece 1 at 11-APR-18
piece handle=1gt03mcl_1_1 tag=TAG20180411T211605 comment=API Version 2.0,MMS Version 10.4.0.4
channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
channel oem_sbt_backup2: finished piece 1 at 11-APR-18
piece handle=1ht03mcl_1_1 tag=TAG20180411T211605 comment=API Version 2.0,MMS Version 10.4.0.4
channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:25
Finished backup at 11-APR-18
Starting Control File and SPFILE Autobackup at 11-APR-18
piece handle=c-1343950367-20180411-01 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 11-APR-18
released channel: oem_sbt_backup1
released channel: oem_sbt_backup2
RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: SID=195 device type=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup
RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
no obsolete backups found
RMAN> exit;
Recovery Manager complete.

复制代码

RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
42 Full 9.45M DISK 00:00:00 11-APR-18
BP Key: 42 Status: AVAILABLE Compressed: NO Tag: TAG20180411T211552
Piece Name: +FRA/orcl/autobackup/2018_04_11/s_973199752.349.973199753
SPFILE Included: Modification time: 11-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1696024 Ckp time: 11-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
43 42.00M SBT_TAPE 00:00:16 11-APR-18
BP Key: 43 Status: AVAILABLE Compressed: NO Tag: TAG20180411T211605
Handle: 1gt03mcl_1_1 Media: station90-000003
List of Archived Logs in backup set 43
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 81 1685025 11-APR-18 1690508 11-APR-18
1 82 1690508 11-APR-18 1693389 11-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
44 12.25M SBT_TAPE 00:00:24 11-APR-18
BP Key: 44 Status: AVAILABLE Compressed: NO Tag: TAG20180411T211605
Handle: 1ht03mcl_1_1 Media: station90-000004
List of Archived Logs in backup set 44
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 83 1693389 11-APR-18 1696105 11-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
45 Full 9.50M SBT_TAPE 00:00:16 11-APR-18
BP Key: 45 Status: AVAILABLE Compressed: NO Tag: TAG20180411T211630
Handle: c-1343950367-20180411-01 Media: station90-000003
SPFILE Included: Modification time: 11-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1696146 Ckp time: 11-APR-18
RMAN>

复制代码

RMAN> list copy;
using target database control file instead of recovery catalog
specification does not match any control file copy in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
3 1 A 11-APR-18 1695966 11-APR-18
Name: +FRA/orcl/datafile/system.267.973199737
Tag: ORA_OEM_LEVEL_0
2 2 A 11-APR-18 1695929 11-APR-18
Name: +FRA/orcl/datafile/sysaux.277.973199731
Tag: ORA_OEM_LEVEL_0
4 3 A 11-APR-18 1695977 11-APR-18
Name: +FRA/orcl/datafile/undotbs1.262.973199745
Tag: ORA_OEM_LEVEL_0
6 4 A 11-APR-18 1696012 11-APR-18
Name: +FRA/orcl/datafile/users.350.973199751
Tag: ORA_OEM_LEVEL_0
5 5 A 11-APR-18 1695993 11-APR-18
Name: +FRA/orcl/datafile/example.351.973199747
Tag: ORA_OEM_LEVEL_0
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
95 1 81 A 11-APR-18
Name: +FRA/orcl/archivelog/2018_04_11/thread_1_seq_81.263.973198807
96 1 82 A 11-APR-18
Name: +FRA/orcl/archivelog/2018_04_11/thread_1_seq_82.304.973198817
97 1 83 A 11-APR-18
Name: +FRA/orcl/archivelog/2018_04_11/thread_1_seq_83.348.973199765
RMAN>

复制代码

第二天：

RMAN>
connected to target database: ORCL (DBID=1343950367)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> run {
2> allocate channel oem_disk_backup device type disk;
3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
4> backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
5> release channel oem_disk_backup;
6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
8> backup archivelog all not backed up;
9> }
allocated channel: oem_disk_backup
channel oem_disk_backup: SID=200 device type=DISK
Starting recover at 12-APR-18
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
Finished recover at 12-APR-18
Starting backup at 12-APR-18
channel oem_disk_backup: starting incremental level 1 datafile backup set
channel oem_disk_backup: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.972833355
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
channel oem_disk_backup: starting piece 1 at 12-APR-18
channel oem_disk_backup: finished piece 1 at 12-APR-18
piece handle=+FRA/orcl/backupset/2018_04_12/nnndn1_ora_oem_level_0_0.345.973286133 tag=ORA_OEM_LEVEL_0 comment=NONE
channel oem_disk_backup: backup set complete, elapsed time: 00:00:08
Finished backup at 12-APR-18
Starting Control File and SPFILE Autobackup at 12-APR-18
piece handle=+FRA/orcl/autobackup/2018_04_12/s_973286135.344.973286135 comment=NONE
Finished Control File and SPFILE Autobackup at 12-APR-18
released channel: oem_disk_backup
allocated channel: oem_sbt_backup1
channel oem_sbt_backup1: SID=200 device type=SBT_TAPE
channel oem_sbt_backup1: Oracle Secure Backup
allocated channel: oem_sbt_backup2
channel oem_sbt_backup2: SID=9 device type=SBT_TAPE
channel oem_sbt_backup2: Oracle Secure Backup
Starting backup at 12-APR-18
current log archived
skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_81.263.973198807; already backed on 11-APR-18
skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_82.304.973198817; already backed on 11-APR-18
skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_83.348.973199765; already backed on 11-APR-18
channel oem_sbt_backup1: starting archived log backup set
channel oem_sbt_backup1: specifying archived log(s) in backup set
input archived log thread=1 sequence=84 RECID=98 STAMP=973285874
input archived log thread=1 sequence=85 RECID=99 STAMP=973286059
channel oem_sbt_backup1: starting piece 1 at 12-APR-18
channel oem_sbt_backup2: starting archived log backup set
channel oem_sbt_backup2: specifying archived log(s) in backup set
input archived log thread=1 sequence=86 RECID=100 STAMP=973286148
channel oem_sbt_backup2: starting piece 1 at 12-APR-18
channel oem_sbt_backup1: finished piece 1 at 12-APR-18
piece handle=1lt06ao4_1_1 tag=TAG20180412T211548 comment=API Version 2.0,MMS Version 10.4.0.4
channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25

复制代码

多了什么？

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
46 Incr 1 48.75M DISK 00:00:05 12-APR-18
BP Key: 46 Status: AVAILABLE Compressed: NO Tag: ORA_OEM_LEVEL_0
Piece Name: +FRA/orcl/backupset/2018_04_12/nnndn1_ora_oem_level_0_0.345.973286133
List of Datafiles in backup set 46
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 1740881 12-APR-18 +DATA/orcl/datafile/system.256.816169553
2 1 Incr 1740881 12-APR-18 +DATA/orcl/datafile/sysaux.257.816169553
3 1 Incr 1740881 12-APR-18 +DATA/orcl/datafile/undotbs1.258.972833355
4 1 Incr 1740881 12-APR-18 +DATA/orcl/datafile/users.259.816169553
5 1 Incr 1740881 12-APR-18 +DATA/orcl/datafile/example.265.816169651
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
47 Full 9.45M DISK 00:00:00 12-APR-18
BP Key: 47 Status: AVAILABLE Compressed: NO Tag: TAG20180412T211535
Piece Name: +FRA/orcl/autobackup/2018_04_12/s_973286135.344.973286135
SPFILE Included: Modification time: 12-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1742573 Ckp time: 12-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
48 50.00M SBT_TAPE 00:00:16 12-APR-18
BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20180412T211548
Handle: 1lt06ao4_1_1 Media: station90-000003
List of Archived Logs in backup set 48
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 84 1696105 11-APR-18 1699635 12-APR-18
1 85 1699635 12-APR-18 1723330 12-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
49 8.00M SBT_TAPE 00:00:25 12-APR-18
BP Key: 49 Status: AVAILABLE Compressed: NO Tag: TAG20180412T211548
Handle: 1mt06ao5_1_1 Media: station90-000004
List of Archived Logs in backup set 49
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 86 1723330 12-APR-18 1746108 12-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
50 Full 9.50M SBT_TAPE 00:00:16 12-APR-18
BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20180412T211624
Handle: c-1343950367-20180412-01 Media: station90-000003
SPFILE Included: Modification time: 12-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1755592 Ckp time: 12-APR-18
RMAN>

复制代码

98 1 84 A 11-APR-18
Name: +FRA/orcl/archivelog/2018_04_12/thread_1_seq_84.347.973285875
99 1 85 A 12-APR-18
Name: +FRA/orcl/archivelog/2018_04_12/thread_1_seq_85.346.973286059
100 1 86 A 12-APR-18
Name: +FRA/orcl/archivelog/2018_04_12/thread_1_seq_86.343.973286149
101 1 87 A 12-APR-18
Name: +FRA/orcl/archivelog/2018_04_12/thread_1_seq_87.342.973286343

复制代码

第三天：

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Apr 13 21:15:22 2018
RMAN>
connected to target database: ORCL (DBID=1343950367)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> run {
2> allocate channel oem_disk_backup device type disk;
3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
4> backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
5> release channel oem_disk_backup;
6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
8> backup archivelog all not backed up;
9> }
allocated channel: oem_disk_backup
channel oem_disk_backup: SID=199 device type=DISK
Starting recover at 13-APR-18
channel oem_disk_backup: starting incremental datafile backup set restore
channel oem_disk_backup: specifying datafile copies to recover
recovering datafile copy file number=00001 name=+FRA/orcl/datafile/system.267.973199737
recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.277.973199731
recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.262.973199745
recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.350.973199751
recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.351.973199747
channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2018_04_12/nnndn1_ora_oem_level_0_0.345.973286133
channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2018_04_12/nnndn1_ora_oem_level_0_0.345.973286133 tag=ORA_OEM_LEVEL_0
channel oem_disk_backup: restored backup piece 1
channel oem_disk_backup: restore complete, elapsed time: 00:00:03
Finished recover at 13-APR-18
Starting backup at 13-APR-18
channel oem_disk_backup: starting incremental level 1 datafile backup set
channel oem_disk_backup: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.972833355
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
channel oem_disk_backup: starting piece 1 at 13-APR-18
channel oem_disk_backup: finished piece 1 at 13-APR-18
piece handle=+FRA/orcl/backupset/2018_04_13/nnndn1_ora_oem_level_0_0.340.973372531 tag=ORA_OEM_LEVEL_0 comment=NONE
channel oem_disk_backup: backup set complete, elapsed time: 00:00:03
Finished backup at 13-APR-18
Starting Control File and SPFILE Autobackup at 13-APR-18
piece handle=+FRA/orcl/autobackup/2018_04_13/s_973372532.339.973372533 comment=NONE
Finished Control File and SPFILE Autobackup at 13-APR-18
released channel: oem_disk_backup
allocated channel: oem_sbt_backup1
channel oem_sbt_backup1: SID=199 device type=SBT_TAPE
channel oem_sbt_backup1: Oracle Secure Backup
allocated channel: oem_sbt_backup2
channel oem_sbt_backup2: SID=145 device type=SBT_TAPE
channel oem_sbt_backup2: Oracle Secure Backup
Starting backup at 13-APR-18
current log archived
skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_81.263.973198807; already backed on 11-APR-18
skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_82.304.973198817; already backed on 11-APR-18
skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_83.348.973199765; already backed on 11-APR-18
skipping archived log file +FRA/orcl/archivelog/2018_04_12/thread_1_seq_84.347.973285875; already backed on 12-APR-18
skipping archived log file +FRA/orcl/archivelog/2018_04_12/thread_1_seq_85.346.973286059; already backed on 12-APR-18
skipping archived log file +FRA/orcl/archivelog/2018_04_12/thread_1_seq_86.343.973286149; already backed on 12-APR-18
channel oem_sbt_backup1: starting archived log backup set
channel oem_sbt_backup1: specifying archived log(s) in backup set
input archived log thread=1 sequence=87 RECID=101 STAMP=973286343
input archived log thread=1 sequence=88 RECID=102 STAMP=973372275
channel oem_sbt_backup1: starting piece 1 at 13-APR-18
channel oem_sbt_backup2: starting archived log backup set
channel oem_sbt_backup2: specifying archived log(s) in backup set
input archived log thread=1 sequence=89 RECID=103 STAMP=973372545
channel oem_sbt_backup2: starting piece 1 at 13-APR-18
channel oem_sbt_backup1: finished piece 1 at 13-APR-18
piece handle=1qt08v41_1_1 tag=TAG20180413T211545 comment=API Version 2.0,MMS Version 10.4.0.4
channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
channel oem_sbt_backup2: finished piece 1 at 13-APR-18
piece handle=1rt08v41_1_1 tag=TAG20180413T211545 comment=API Version 2.0,MMS Version 10.4.0.4
channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:25
Finished backup at 13-APR-18
Starting Control File and SPFILE Autobackup at 13-APR-18
piece handle=c-1343950367-20180413-01 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 13-APR-18
released channel: oem_sbt_backup1
released channel: oem_sbt_backup2
RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';

复制代码

有什么变化：

RMAN> list copy;
specification does not match any control file copy in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
9 1 A 13-APR-18 1740881 12-APR-18
Name: +FRA/orcl/datafile/system.267.973199737
Tag: ORA_OEM_LEVEL_0
11 2 A 13-APR-18 1740881 12-APR-18
Name: +FRA/orcl/datafile/sysaux.277.973199731
Tag: ORA_OEM_LEVEL_0
10 3 A 13-APR-18 1740881 12-APR-18
Name: +FRA/orcl/datafile/undotbs1.262.973199745
Tag: ORA_OEM_LEVEL_0
8 4 A 13-APR-18 1740881 12-APR-18
Name: +FRA/orcl/datafile/users.350.973199751
Tag: ORA_OEM_LEVEL_0
7 5 A 13-APR-18 1740881 12-APR-18
Name: +FRA/orcl/datafile/example.351.973199747
Tag: ORA_OEM_LEVEL_0

复制代码