课程第29次

botang · 发表于 2019-7-21 08:47:13

2019-07-21

创建RMAN的脚本必需连接recovery catalog：

[oracle@station76 ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 01:44:24 2019Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: ORCL (DBID=1541741703)RMAN> create script backupusers from file '/home/oracle/backupusers.rcv';using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of create script command at 07/21/2019 01:44:51
RMAN-06002: command not allowed when not connected to a recovery catalogRMAN>

复制代码

得出推论：控制文件不能存放太多非物理机构方面的信息，

SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7

复制代码

如果retention policy定位31天，以上参数要跟着改成31

[oracle@station76 ~]$ expdp \'sys/oracle_4U as sysdba\' directory=dir1 dumpfile=u76.dmp schemas=u76
Export: Release 11.2.0.4.0 - Production on Sun Jul 21 01:58:21 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01": "sys/******** AS SYSDBA" directory=dir1 dumpfile=u76.dmp schemas=u76
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 2.125 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "U76"."ROUT" 166.8 KB 2131 rows
. . exported "U76"."CFS" 89.86 KB 157 rows
. . exported "U76"."AL" 15.58 KB 5 rows
. . exported "U76"."BCF" 10.50 KB 4 rows
. . exported "U76"."BDF" 16.82 KB 5 rows
. . exported "U76"."BP" 16.47 KB 9 rows
. . exported "U76"."BS" 12.91 KB 9 rows
. . exported "U76"."BSF" 7.953 KB 4 rows
. . exported "U76"."CKP" 8.875 KB 5 rows
. . exported "U76"."CONF" 8.109 KB 9 rows
. . exported "U76"."CONFIG" 5.421 KB 1 rows
. . exported "U76"."DB" 5.835 KB 2 rows
. . exported "U76"."DBINC" 7.515 KB 3 rows
. . exported "U76"."DF" 15.76 KB 9 rows
. . exported "U76"."FB" 6.25 KB 1 rows
. . exported "U76"."NODE" 20.73 KB 2 rows
. . exported "U76"."OFFR" 8.828 KB 5 rows
. . exported "U76"."ORL" 8.007 KB 9 rows
. . exported "U76"."RCVER" 5.015 KB 1 rows
. . exported "U76"."RLH" 8.812 KB 5 rows
. . exported "U76"."RSR" 22.86 KB 70 rows
. . exported "U76"."RT" 7.851 KB 2 rows
. . exported "U76"."SCR" 6.25 KB 2 rows
. . exported "U76"."SCRL" 6.343 KB 2 rows
. . exported "U76"."SITE_DFATT" 6.273 KB 9 rows
. . exported "U76"."SITE_TFATT" 8.328 KB 2 rows
. . exported "U76"."TF" 8.671 KB 2 rows
. . exported "U76"."TS" 9.898 KB 11 rows
. . exported "U76"."TSATT" 7.648 KB 11 rows
. . exported "U76"."BCB" 0 KB 0 rows
. . exported "U76"."BCR" 0 KB 0 rows
. . exported "U76"."BRL" 0 KB 0 rows
. . exported "U76"."CCB" 0 KB 0 rows
. . exported "U76"."CCF" 0 KB 0 rows
. . exported "U76"."CDF" 0 KB 0 rows
. . exported "U76"."GRSP" 0 KB 0 rows
. . exported "U76"."NRSP" 0 KB 0 rows
. . exported "U76"."RR" 0 KB 0 rows
. . exported "U76"."TEMPRES" 0 KB 0 rows
. . exported "U76"."VPC_DATABASES" 0 KB 0 rows
. . exported "U76"."VPC_USERS" 0 KB 0 rows
. . exported "U76"."XAL" 0 KB 0 rows
. . exported "U76"."XCF" 0 KB 0 rows
. . exported "U76"."XDF" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/datapumpdir/u76.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Sun Jul 21 01:58:59 2019 elapsed 0 00:00:37

复制代码

[oracle@station76 ~]$ impdp \'sys/oracle_4U as sysdba\' directory=dir1 dumpfile=u76.dmp
Import: Release 11.2.0.4.0 - Production on Sun Jul 21 02:02:59 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": "sys/******** AS SYSDBA" directory=dir1 dumpfile=u76.dmp
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "U76"."ROUT" 166.8 KB 2131 rows
. . imported "U76"."CFS" 89.86 KB 157 rows
. . imported "U76"."AL" 15.58 KB 5 rows
. . imported "U76"."BCF" 10.50 KB 4 rows
. . imported "U76"."BDF" 16.82 KB 5 rows
. . imported "U76"."BP" 16.47 KB 9 rows
. . imported "U76"."BS" 12.91 KB 9 rows
. . imported "U76"."BSF" 7.953 KB 4 rows
. . imported "U76"."CKP" 8.875 KB 5 rows
. . imported "U76"."CONF" 8.109 KB 9 rows
. . imported "U76"."CONFIG" 5.421 KB 1 rows
. . imported "U76"."DB" 5.835 KB 2 rows
. . imported "U76"."DBINC" 7.515 KB 3 rows
. . imported "U76"."DF" 15.76 KB 9 rows
. . imported "U76"."FB" 6.25 KB 1 rows
. . imported "U76"."NODE" 20.73 KB 2 rows
. . imported "U76"."OFFR" 8.828 KB 5 rows
. . imported "U76"."ORL" 8.007 KB 9 rows
. . imported "U76"."RCVER" 5.015 KB 1 rows
. . imported "U76"."RLH" 8.812 KB 5 rows
. . imported "U76"."RSR" 22.86 KB 70 rows
. . imported "U76"."RT" 7.851 KB 2 rows
. . imported "U76"."SCR" 6.25 KB 2 rows
. . imported "U76"."SCRL" 6.343 KB 2 rows
. . imported "U76"."SITE_DFATT" 6.273 KB 9 rows
. . imported "U76"."SITE_TFATT" 8.328 KB 2 rows
. . imported "U76"."TF" 8.671 KB 2 rows
. . imported "U76"."TS" 9.898 KB 11 rows
. . imported "U76"."TSATT" 7.648 KB 11 rows
. . imported "U76"."BCB" 0 KB 0 rows
. . imported "U76"."BCR" 0 KB 0 rows
. . imported "U76"."BRL" 0 KB 0 rows
. . imported "U76"."CCB" 0 KB 0 rows
. . imported "U76"."CCF" 0 KB 0 rows
. . imported "U76"."CDF" 0 KB 0 rows
. . imported "U76"."GRSP" 0 KB 0 rows
. . imported "U76"."NRSP" 0 KB 0 rows
. . imported "U76"."RR" 0 KB 0 rows
. . imported "U76"."TEMPRES" 0 KB 0 rows
. . imported "U76"."VPC_DATABASES" 0 KB 0 rows
. . imported "U76"."VPC_USERS" 0 KB 0 rows
. . imported "U76"."XAL" 0 KB 0 rows
. . imported "U76"."XCF" 0 KB 0 rows
. . imported "U76"."XDF" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at Sun Jul 21 02:03:32 2019 elapsed 0 00:00:32
[oracle@station76 ~]$

复制代码

---------------------------------从此线之后做实验要两个catalog:
剪切形式的交换catalog数据：

[oracle@station76 ~]$ rman catalog u76/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:27:15 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
[oracle@station76 ~]$ rman catalog u76/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:28:14 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
Recovery Manager complete.
[oracle@station76 ~]$ rman catalog u76/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:28:54 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> import catalog uwin/oracle_4U@winorcl
2> ;
Starting import catalog at 2019-07-21:02:29:29
connected to source recovery catalog database
import validation complete
database unregistered from the source recovery catalog
Finished import catalog at 2019-07-21:02:29:32
RMAN> exit
Recovery Manager complete.
[oracle@station76 ~]$ rman target / catalog u76/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:29:48 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1541741703)
connected to recovery catalog database
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
842 857 ORCL 1541741703 PARENT 1 2013-08-24:11:37:30
842 843 ORCL 1541741703 CURRENT 925702 2019-07-18:15:49:31
RMAN> exit
Recovery Manager complete.
[oracle@station76 ~]$ rman target / catalog uwin/oracle_4U@winorcl
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:30:22 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1541741703)
connected to recovery catalog database
RMAN> list incarnation of database;
RMAN> list backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 07/21/2019 02:30:35
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
RMAN>

复制代码

复制形式的交换catalog数据：

C:\WINDOWS\system32>rman catalog uwin/oracle_4U@winorcl
恢复管理器: Release 11.2.0.4.0 - Production on 星期日 7月 21 09:40:40 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
连接到恢复目录数据库
RMAN> import catalog u76/oracle_4U@rcat dbid=1541741703 no unregister;
启动 import catalog 于 21-7月 -19
连接到源恢复目录数据库
导入验证完成
完成 import catalog 于 21-7月 -19
RMAN> exit
恢复管理器完成。

复制代码

结果：

[oracle@station76 ~]$ rman target / catalog uwin/oracle_4U@winorcl
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:41:53 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1541741703)
connected to recovery catalog database
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1023 1038 ORCL 1541741703 PARENT 1 2013-08-24:11:37:30
1023 1024 ORCL 1541741703 CURRENT 925702 2019-07-18:15:49:31
RMAN> exit
Recovery Manager complete.
[oracle@station76 ~]$ rman target / catalog u76/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:42:08 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1541741703)
connected to recovery catalog database
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
842 857 ORCL 1541741703 PARENT 1 2013-08-24:11:37:30
842 843 ORCL 1541741703 CURRENT 925702 2019-07-18:15:49:31
RMAN>

复制代码

-------------------------------------------从此线开始 rcat是虚拟专用catalog，winorcl和orcl都是它的target , 务必重在rcat上新建用户做实验：

[oracle@station76 ~]$ . oraenv
ORACLE_SID = [rcat] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@station76 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 21 02:51:34 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> create user ucatalog identified by oracle_4U default tablespace rcat quota unlimited on rcat ;
User created.
SQL> create user vcatalog1 identified by oracle_4U default tablespace rcat quota unlimited on rcat ;
User created.
SQL> create user vcatalog2 identified by oracle_4U default tablespace rcat quota unlimited on rcat ;
User created.

复制代码

一样地授权：

SQL> grant recovery_Catalog_owner to ucatalog;
Grant succeeded.
SQL> grant recovery_catalog_owner to vcatalog1;
Grant succeeded.
SQL> grant recovery_catalog_owner to vcatalog2;
Grant succeeded.

复制代码

创建base catalog:

[oracle@station76 ~]$ rman catalog ucatalog/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:56:24 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
RMAN>

复制代码

--------------让vcatalog1/2自行去注册的分支（3b）：

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@station76 ~]$ rman catalog ucatalog/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 02:56:24 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
RMAN> grant catalog for database 1541741703 to vcatalog1;
Grant succeeded.
RMAN> grant catalog for database 2162311502 to vcatalog2;
Grant succeeded.

复制代码

[oracle@station76 ~]$ rman catalog vcatalog1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 03:14:25 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog;
found ineligible base catalog owned by U76
found eligible base catalog owned by UCATALOG
created virtual catalog against base catalog owned by UCATALOG
RMAN> exit
Recovery Manager complete.
[oracle@station76 ~]$ rman catalog vcatalog2/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 03:14:40 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog;
found ineligible base catalog owned by U76
found eligible base catalog owned by UCATALOG
created virtual catalog against base catalog owned by UCATALOG
RMAN>

复制代码

[oracle@station76 ~]$ rman target / catalog vcatalog1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 03:16:48 2019
connected to target database: ORCL (DBID=1541741703)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>

复制代码

C:\WINDOWS\system32>rman target / catalog vcatalog2/oracle_4U@rcat
恢复管理器: Release 11.2.0.4.0 - Production on 星期日 7月 21 10:17:11 2019
已连接到目标数据库: WINORCL (DBID=2162311502)
连接到恢复目录数据库
RMAN> register database;
注册在恢复目录中的数据库
正在启动恢复目录的全部重新同步
完成全部重新同步

复制代码

[oracle@station76 ~]$ rman target / catalog ucatalog/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 21 03:18:18 2019
connected to target database: ORCL (DBID=1541741703)
connected to recovery catalog database
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 16 ORCL 1541741703 PARENT 1 2013-08-24:11:37:30
1 2 ORCL 1541741703 CURRENT 925702 2019-07-18:15:49:31

复制代码

C:\WINDOWS\system32>rman target / catalog ucatalog/oracle_4U@rcat
恢复管理器: Release 11.2.0.4.0 - Production on 星期日 7月 21 10:19:12 2019
已连接到目标数据库: WINORCL (DBID=2162311502)
连接到恢复目录数据库
RMAN> list incarnation of database;
数据库原型列表
DB 关键字 Inc 关键字 DB 名 DB ID STATUS 重置 SCN 重置时间
------- ------- -------- ---------------- --- ---------- ----------
186 187 WINORCL 2162311502 CURRENT 1 21-7月 -19

复制代码

-------------------------------------------------------------------------------------试试维护性通道

RMAN> allocate channel for maintenance device type sbt;
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: SID=23 device type=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup
RMAN> allocate channel for maintenance device type sbt;
allocated channel: ORA_MAINT_SBT_TAPE_2
channel ORA_MAINT_SBT_TAPE_2: SID=45 device type=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_2: Oracle Secure Backup
RMAN> delete noprompt backup;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
40 35 1 1 AVAILABLE SBT_TAPE 15u73al9_1_1
41 36 1 1 AVAILABLE SBT_TAPE c-1541741703-20190720-03
42 37 1 1 AVAILABLE SBT_TAPE 17u73aqt_1_1
43 38 1 1 AVAILABLE SBT_TAPE c-1541741703-20190720-04
44 39 1 1 AVAILABLE SBT_TAPE 19u73b0g_1_1
45 40 1 1 AVAILABLE SBT_TAPE c-1541741703-20190720-05
46 41 1 1 AVAILABLE SBT_TAPE 1bu760di_1_1
47 42 1 1 AVAILABLE SBT_TAPE c-1541741703-20190721-00
deleted backup piece
backup piece handle=15u73al9_1_1 RECID=40 STAMP=1014082217
deleted backup piece
backup piece handle=c-1541741703-20190720-03 RECID=41 STAMP=1014082244
deleted backup piece
backup piece handle=17u73aqt_1_1 RECID=42 STAMP=1014082397
deleted backup piece
backup piece handle=c-1541741703-20190720-04 RECID=43 STAMP=1014082426
deleted backup piece
backup piece handle=19u73b0g_1_1 RECID=44 STAMP=1014082576
deleted backup piece
backup piece handle=c-1541741703-20190720-05 RECID=45 STAMP=1014082604
deleted backup piece
backup piece handle=1bu760di_1_1 RECID=46 STAMP=1014170034
deleted backup piece
backup piece handle=c-1541741703-20190721-00 RECID=47 STAMP=1014170050
Deleted 8 objects
RMAN>

复制代码

--------做实验之前，请按以下设置标准的show all：

RMAN> show all;
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 SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station76)' MAXPIECESIZE 250 M;
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station76)' MAXPIECESIZE 250 M;
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 250 M;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station76)' MAXPIECESIZE 250 M;
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

复制代码