活动第34/35次(2018-07-01星期日上下午)
准备插入none-CDB(orcl2)到cdb2:$ . oraenv
ORACLE_SID = ? orcl2
The Oracle base remains unchanged with value /u01/app/oracle
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Jul 1 09:15:08 2018
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1325402232 bytes
Database Buffers 805306368 bytes
Redo Buffers 13848576 bytes
Database mounted.
SQL> alter database open read only;
Database altered.
SQL> desc dbms_pdb
FUNCTION CHECK_PLUG_COMPATIBILITY RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PDB_DESCR_FILE VARCHAR2 IN
PDB_NAME VARCHAR2 IN DEFAULT
FUNCTION CLEANUP_TASK RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_ID NUMBER IN
PROCEDURE CREATEX$PERMANENTTABLES
PROCEDURE DESCRIBE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PDB_DESCR_FILE VARCHAR2 IN
PDB_NAME VARCHAR2 IN DEFAULT
PROCEDURE DROPX$PERMANENTTABLES
PROCEDURE EXEC_AS_ORACLE_SCRIPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SQL_STMT VARCHAR2 IN
PROCEDURE NONCDB_TO_PDB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PHASE NUMBER IN
PROCEDURE POPULATESYNCTABLE
PROCEDURE RECOVER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PDB_DESCR_FILE VARCHAR2 IN
PDB_NAME VARCHAR2 IN
FILENAMES VARCHAR2 IN
PROCEDURE SYNC_PDB
FUNCTION UPDATE_CDBVW_STATS RETURNS NUMBER
FUNCTION UPDATE_COMDATA_STATS RETURNS NUMBER
FUNCTION UPDATE_OBJLINK_STATS RETURNS NUMBER
PROCEDURE UPDATE_VERSION
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string ORCL2
SQL> exec dbms_pdb.describe('/home/oracle/orcl2.xml') ;
PL/SQL procedure successfully completed.
SQL>
多租户书的这一页中的2.是完全没有必要的(原因是orcl2是OMF的数据库)
书上这么写是因为它的orcl2是普通的文件系统库,并且不是OMF的。前面讲过的,做插件数据库时,必须有自己的临时文件,所以文件名冲突就会报错。
在原处“收编”non-CDB就用nocopy,如果要拷贝方式创建就用file_name_covert:
selectcon_id, name , open_mode from v$pdbs;
alter pluggable database all open;
create pluggable database pdb_orcl2 using
'/home/oracle/orcl2.xml' nocopy;
selectcon_id, name , open_mode from v$pdbs;
第一件事情就是去清理, non-CDB中原来的undo表空间和临时文件:
$ . oraenv
ORACLE_SID = ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
$ asmcmd
ASMCMD> ls
DATA/
FRA/
ASMCMD> cd data
ASMCMD> ls
CDB1/
CDB2/
ORCL2/
ASMCMD> cd orcl2
ASMCMD> ls
AUTOBACKUP/
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfileorcl2.ora
ASMCMD> d datafile
ASMCMD-9487: 'd' cannot be run with 'sysasm' privilege
ASMCMD> cd datafile
ASMCMD> ls
EXAMPLE.270.980156363
SYSAUX.269.980156355
SYSTEM.267.980156347
UNDOTBS1.268.980156349
USERS.271.980156367
ASMCMD> rm UNDOTBS1.268.980156349
ASMCMD>
ASMCMD> cd ..
ASMCMD> ls
CDB1/
CDB2/
ORCL2/
ASMCMD> cd ORCL2/
ASMCMD> ls
AUTOBACKUP/
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfileorcl2.ora
ASMCMD> cd TEMPFILE/
ASMCMD> ls
TEMP.260.980157325
ASMCMD> rm TEMP.260.980157325
ASMCMD>
第二步:为了完成整个操作,不得不通过从PDB SYSTEM表空间中删除不必要的元数据(数据字典)来转换刚刚插入的 non-CDB到正确的PDB状态。
cdexttab.sql exfcpu.sql prvtbrse.plb prvtsnps.plb xsutil.sql
$ ls -l non*
-rw-r--r-- 1 oracle oinstall 336086月 14 2014 noncdb_to_pdb.sql
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Jul 1 09:42:48 2018
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn sys/oracle_4U@pdb_orcl2 as sysdba
Connected.
SQL> @noncdb_to_pdb.sql
SQL> SET SERVEROUTPUT ON
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL>
SQL> WHENEVER SQLERROR EXIT;
SQL>
SQL> DOC
DOC>#######################################################################
DOC>#######################################################################
DOC> The following statement will cause an "ORA-01403: no data found"
DOC> error if we're not in a PDB.
DOC> This script is intended to be run right after plugin of a PDB,
DOC> while inside the PDB.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL>
SQL> VARIABLE cdbname VARCHAR2(128)
SQL> VARIABLE pdbname VARCHAR2(128)
SQL> BEGIN
2 SELECT sys_context('USERENV', 'CDB_NAME')
3 INTO :cdbname
4 FROM dual
5 WHERE sys_context('USERENV', 'CDB_NAME') is not null;
6 SELECT sys_context('USERENV', 'CON_NAME')
7 INTO :pdbname
8 FROM dual
9 WHERE sys_context('USERENV', 'CON_NAME') <> 'CDB$ROOT';
附:如果要拷贝方式创建就用file_name_covert:
create pluggable database pdb_orcl2 using
'/home/oracle/orcl2.xml'
file_name_convert=('+data/orcl2/datafile/SYSTEM.267.980156347', '/u01/app/oracle/oradata/cdb2/pdb_orcl2/system01.dbf',
'+data/orcl2/datafile/SYSAUX.269.980156355','/u01/app/oracle/oradata/cdb2/pdb_orcl2/sysaux01.dbf',
'+data/orcl2/datafile/USERS.271.980156367','/u01/app/oracle/oradata/cdb2/pdb_orcl2/users01.dbf',
'+data/orcl2/datafile/EXAMPLE.270.980156363','/u01/app/oracle/oradata/cdb2/pdb_orcl2/example01.dbf'
);
----------------------------------------------------------------------------------------------------------------------------------------
拔出一个插件数据库:
# su - oracle
$ . oraenv
ORACLE_SID = ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Jul 1 09:55:47 2018
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> selectcon_id, name , open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ ONLY
3 PDB1_1 MOUNTED
SQL> alter pluggable database pdb1_1 open ;
Pluggable database altered.
SQL> alter pluggable database pdb1_1 unplug into '/home/oracle/pdb1_1.xml';
alter pluggable database pdb1_1 unplug into '/home/oracle/pdb1_1.xml'
*
ERROR at line 1:
ORA-65025: Pluggable database PDB1_1 is not closed on all instances.
SQL> alter pluggable database pdb1_1 close;
Pluggable database altered.
SQL> selectcon_id, name , open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ ONLY
3 PDB1_1 MOUNTED
SQL> alter pluggable database pdb1_1 unplug into '/home/oracle/pdb1_1.xml';
Pluggable database altered.
SQL> selectcon_id, name , open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ ONLY
3 PDB1_1 MOUNTED
SQL> desc cdb_pdbs
Name Null? Type
----------------------------------------- -------- ----------------------------
PDB_ID NOT NULL NUMBER
PDB_NAME NOT NULL VARCHAR2(128)
DBID NOT NULL NUMBER
CON_UID NOT NULL NUMBER
GUID RAW(16)
STATUS VARCHAR2(9)
CREATION_SCN NUMBER
VSN NUMBER
LOGGING VARCHAR2(9)
FORCE_LOGGING VARCHAR2(3)
FORCE_NOLOGGING VARCHAR2(3)
CON_ID NOT NULL NUMBER
SQL> selectPDB_NAME, CON_ID, STATUS from cdb_pdbs;
PDB_NAME
--------------------------------------------------------------------------------
CON_ID STATUS
---------- ---------
PDB1_1
3 UNPLUGGED
PDB$SEED
2 NORMAL
SQL>
keep datafiles的反义词是including datafiles(drop pluggable database pdb1_1 including datafiles):
SQL> drop pluggable database pdb1_1 keep datafiles;
Pluggable database dropped.
SQL> selectPDB_NAME, CON_ID, STATUS from cdb_pdbs;
PDB_NAME
--------------------------------------------------------------------------------
CON_ID STATUS
---------- ---------
PDB$SEED
2 NORMAL
SQL> selectcon_id, name , open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ ONLY
SQL>
对拔出来的插件数据库检查兼容性:
select* from cdb_pdbs;
declare
v1boolean;
begin
v1 := dbms_pdb.check_plug_compatibility(
pdb_descr_file => '/home/oracle/pdb1_1.xml',
pdb_name => 'PDB1_1');
if v1=true then
dbms_output.put_line('OK');
end if;
end;
select* from pdb_plug_in_violations; 插入插件数据库时,与之前的non-CDB语法是一样的:
在原处“收编”non-CDB就用nocopy,如果要拷贝方式创建就用file_name_covert。
create pluggable database pdb1_1 using '/home/oracle/pdb1_1.xml' nocopy;
selectcon_id,name,open_mode from v$pdbs;
select* from cdb_pdbs;
alter pluggable database pdb1_1 open;清理一下CRS并且注册一下Cloud Control:
$ srvctl remove database-db orcl2
是否删除数据库 orcl2? (y/) y
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cdb1.db ora....se.type OFFLINE OFFLINE
ora.cdb2.db ora....se.type ONLINE ONLINE station90
ora.cssd ora.cssd.typeONLINE ONLINE station90
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.emrep.db ora....se.type ONLINE ONLINE station90
ora.evmd ora.evm.type ONLINE ONLINE station90
ora.ons ora.ons.type OFFLINE OFFLINE
ora.orcl.db ora....se.type ONLINE ONLINE station90
$ srvctl remove database-db cdb1
是否删除数据库 cdb1? (y/) y
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cdb2.db ora....se.type ONLINE ONLINE station90
ora.cssd ora.cssd.typeONLINE ONLINE station90
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.emrep.db ora....se.type ONLINE ONLINE station90
ora.evmd ora.evm.type ONLINE ONLINE station90
ora.ons ora.ons.type OFFLINE OFFLINE
ora.orcl.db ora....se.type ONLINE ONLINE station90
$
---------------------------------------------------------------
-------------------------------------------------------------
----------------------------------------------------------
alter pluggable database all close如果关不掉,杀进程:
after startup触发器:
create or replace trigger trigger1
after startup on database
begin
execute immediate 'alter pluggable database all open';
end;
select* from cdb_triggers t where t.TRIGGER_NAME='TRIGGER1';要打开restricted模式,可以不用关闭数据库(包括插件数据库):
SQL> alter system enable restricted session;
System altered.
SQL> selectcon_id, name , open_mode , RESTRICTED from v$pdbs
2;
CON_ID NAME OPEN_MODERES
---------- ------------------------------ ---------- ---
3 PDB2_1 READ WRITE YES
代替书上:
SQL> alter pluggable database rename global_name to pdb2;
alter pluggable database rename global_name to pdb2
*
ERROR at line 1:
ORA-65045: pluggable database not in a restricted mode
SQL> alter system enable restricted session;
System altered.
SQL> selectcon_id, name , open_mode , RESTRICTED from v$pdbs
2;
CON_ID NAME OPEN_MODERES
---------- ------------------------------ ---------- ---
3 PDB2_1 READ WRITE YES
SQL> alter pluggable database rename global_name to pdb2;
Pluggable database altered.
SQL> selectcon_id, name , open_mode , RESTRICTED from v$pdbs
2;
CON_ID NAME OPEN_MODERES
---------- ------------------------------ ---------- ---
3 PDB2 READ WRITE YES
SQL> conn / as sysdba
Connected.
SQL> selectcon_id, name , open_mode , RESTRICTED from v$pdbs;
CON_ID NAME OPEN_MODERES
---------- ------------------------------ ---------- ---
2 PDB$SEED READ ONLYNO
3 PDB2 READ WRITE YES
4 PDB2_2 READ WRITE NO
5 PDB_ORCL2 READ WRITE NO
6 PDB1_1 READ WRITE NO
SQL> conn sys/oracle_4U@pdb2_1 as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Warning: You are no longer connected to ORACLE.
SQL> conn sys/oracle_4U@pdb2 as sysdba
Connected.
SQL> alter system disable restricted session;
System altered.
SQL> selectcon_id, name , open_mode , RESTRICTED from v$pdbs;
CON_ID NAME OPEN_MODERES
---------- ------------------------------ ---------- ---
3 PDB2 READ WRITE NO
SQL> conn / as sysdba
Connected.
SQL> selectcon_id, name , open_mode , RESTRICTED from v$pdbs;
CON_ID NAME OPEN_MODERES
---------- ------------------------------ ---------- ---
2 PDB$SEED READ ONLYNO
3 PDB2 READ WRITE NO
4 PDB2_2 READ WRITE NO
5 PDB_ORCL2 READ WRITE NO
6 PDB1_1 READ WRITE NO
SQL>
在多租户环境中少有的对V$视图的改变:
V$PARAMETER看自己的,而V$SYSTEM_PARAMETER看所有插件库的。
SQL> show con_name
CON_NAME
------------------------------
PDB2
SQL> selectname , value from v$system_parameterwhere name like 'optimizer_use_sql%';
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
optimizer_use_sql_plan_baselines
FALSE
SQL> conn / as sysdba
Connected.
SQL> selectname , value from v$system_parameterwhere name like 'optimizer_use_sql%';
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
optimizer_use_sql_plan_baselines
TRUE
optimizer_use_sql_plan_baselines
FALSE
SQL> select con_id, name , value from v$system_parameterwhere name like 'optimizer_use_sql%';
CON_ID
----------
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
0
optimizer_use_sql_plan_baselines
TRUE
3
optimizer_use_sql_plan_baselines
FALSE
CON_ID
----------
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
就像参数一样,表空间在插件数据库之间,也是有个性设置的:
看表空间和数据文件的关系,尽量查v$视图(关联):
-------------------------------------------------------------------
书上的多租户实验环境中的公共用户一共有多少个:
CDB$ROOT有36个:
selectu.USERNAME
fromcdb_users u where u.COMMON='YES'and con_id=1;因此由于传递性,所以PDB2、PDB2_2和PDB1_1这3个插件数据库共有36*3=108个公共用户。
独立数据库(pdb_orcl2)插入后变成插件数据库的只有33个公共用户(少3个):
selectu.USERNAME
fromcdb_users u where u.COMMON='YES'and con_id=1
minus
select u.USERNAME
fromcdb_users u where u.COMMON='YES'and con_id=5;
USERNAME
1DVF
2DVSYS
3LBACSYS
所以整个CDB2中有:36(根容器)+108+33=177个公共用户。
selectu.USERNAME
fromcdb_users u where u.COMMON='YES' ;
------------------------------------------------------------------------------------------
多租户ag书的P128页,是第一次做授权。与建用户不同的是,授权时,要明确说明container=all,才会进行公共授权(而建用户时,不写container=ALL实际上默认就是container=all):
-----------------------------------------------------------------------------------
书上的多租户实验环境中的公共角色一共有多少个:
CDB$ROOT有84个:
select * fromcdb_roles u where u.COMMON='YES'and con_id=1;因此由于传递性,所以PDB2、PDB2_2和PDB1_1这3个插件数据库共有84*3=252个公共角色。
独立数据库(pdb_orcl2)插入后变成插件数据库的只有68个公共角色(少16个):
selectrolefromcdb_roles u where u.COMMON='YES'and con_id=1
minus
selectrole fromcdb_roles u where u.COMMON='YES'and con_id=5;
ROLE
1DV_ADMIN
2DV_GOLDENGATE_ADMIN
3DV_GOLDENGATE_REDO_ACCESS
4DV_OWNER
5DV_AUDIT_CLEANUP
6DV_DATAPUMP_NETWORK_LINK
7DV_REALM_RESOURCE
8DV_XSTREAM_ADMIN
9LBAC_DBA
10DV_PATCH_ADMIN
11DV_STREAMS_ADMIN
12DV_MONITOR
13DV_PUBLIC
14DV_REALM_OWNER
15DV_ACCTMGR
16DV_SECANALYST
独立数据库(pdb_orcl2)插入后变成插件数据库还有5个本地role:
CON_IDCOMMONROLE
15NOCWM_USER
25NOOLAPI_TRACE_USER
35NOOWB$CLIENT
45NOOWB_DESIGNCENTER_VIEW
55NOOWB_USER
所以整个CDB2中有:84(根容器)+252+68+5=409个角色(其中公共角色404个,本地角色5个)。
selectr.CON_ID, r.COMMON, r.ROLE
from cdb_roles r;
-----------------------------------------------------------------------------------------
新特性container_data:
----------------------------------------
select* from cdb_container_data d
where d.USERNAMEnot like '%INTERNAL'
and d.USERNAME not like 'APP%'and d.USERNAME<>'DBSNMP';
alter user c##jfv
set container_data=(cdb$root)
for v_$session
container=current;
-----------------------------------------------
$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Jul 1 17:52:12 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates.All rights reserved.
connected to target database: CDB2 (DBID=727229478)
RMAN> ALTER SYSTEM SET db_recovery_file_dest_size=
2> 24G;
using target database control file instead of recovery catalog
Statement processed
RMAN> list backup;
specification does not match any backup in the repository
RMAN> list copy;
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
RMAN> backup tag '1T_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;
Starting backup at 2018-07-01:17:54:12
current log archived
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=320 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=326 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=62 RECID=1 STAMP=980358852
channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-01:17:54:26
channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-01:17:54:51
piece handle=01t6u5mi_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_07_01/o1_mf_1_62_fmk964v6_.arc RECID=1 STAMP=980358852
Finished backup at 2018-07-01:17:54:51
Starting backup at 2018-07-01:17:54:52
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/cdb2/system01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/cdb2/undotbs01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-01:17:54:52
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/cdb2/sysaux01.dbf
input datafile file number=00024 name=/u01/app/oracle/oradata/cdb2/cdata_01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/cdb2/users01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-01:17:54:52
channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-01:17:55:17
piece handle=02t6u5nc_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00011 name=/u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-01:17:55:17
channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-01:17:55:17
piece handle=03t6u5nc_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00013 name=/u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6FDA0B7BDBCD67DAE0535A00A8C0D512/datafile/o1_mf_sysaux_fmgo7cnk_.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-01:17:55:17
channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-01:17:55:42
piece handle=04t6u5o5_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/cdb2/pdbseed/sysaux01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-01:17:55:43
channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-01:17:55:43
piece handle=05t6u5o5_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:26
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
input datafile file number=00025 name=/u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-01:17:55:43
channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-01:17:56:08
piece handle=06t6u5ov_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00012 name=/u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6FDA0B7BDBCD67DAE0535A00A8C0D512/datafile/o1_mf_system_fmgo7cnj_.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-01:17:56:08
channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-01:17:56:08
piece handle=07t6u5ov_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/cdb2/pdbseed/system01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-01:17:56:08
channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-01:17:56:33
piece handle=08t6u5po_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-01:17:56:33
piece handle=09t6u5po_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
Finished backup at 2018-07-01:17:56:33
Starting backup at 2018-07-01:17:56:33
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=63 RECID=2 STAMP=980358994
channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-01:17:56:34
channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-01:17:56:59
piece handle=0at6u5qi_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_07_01/o1_mf_1_63_fmk9bl78_.arc RECID=2 STAMP=980358994
Finished backup at 2018-07-01:17:56:59
Starting Control File and SPFILE Autobackup at 2018-07-01:17:56:59
piece handle=c-727229478-20180701-00 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 2018-07-01:17:57:24
RMAN> report schema;
Report of database schema for database with db_unique_name CDB2
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 790 SYSTEM YES /u01/app/oracle/oradata/cdb2/system01.dbf
3 700 SYSAUX NO /u01/app/oracle/oradata/cdb2/sysaux01.dbf
4 645 UNDOTBS1 YES /u01/app/oracle/oradata/cdb2/undotbs01.dbf
5 250 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/cdb2/pdbseed/system01.dbf
6 5 USERS NO /u01/app/oracle/oradata/cdb2/users01.dbf
7 550 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/cdb2/pdbseed/sysaux01.dbf
10 260 PDB2:SYSTEM NO /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
11 580 PDB2:SYSAUX NO /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
12 260 PDB2_2:SYSTEM NO /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6FDA0B7BDBCD67DAE0535A00A8C0D512/datafile/o1_mf_system_fmgo7cnj_.dbf
13 580 PDB2_2:SYSAUX NO /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6FDA0B7BDBCD67DAE0535A00A8C0D512/datafile/o1_mf_sysaux_fmgo7cnk_.dbf
24 10 CDATA NO /u01/app/oracle/oradata/cdb2/cdata_01.dbf
25 10 PDB2:LDATA NO /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 197 TEMP 32767 /u01/app/oracle/oradata/cdb2/temp01.dbf
2 100 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/cdb2/pdbseed/pdbseed_temp012018-06-30_04-54-31-PM.dbf
3 20 PDB2:TEMP 32767 /u01/app/oracle/oradata/cdb2/pdb2_1/pdbseed_temp012018-06-30_04-54-31-PM.dbf
4 20 PDB2_2:TEMP 32767 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6FDA0B7BDBCD67DAE0535A00A8C0D512/datafile/o1_mf_temp_fmgo7cnk_.dbf
7 500 TEMP_ROOT 500 /u01/app/oracle/oradata/cdb2/temproot_01.dbf
8 100 PDB2:TEMP_PDB2 100 /u01/app/oracle/oradata/cdb2/pdb2_1/temppdb2_01.dbf
9 10 PDB2:MY_TEMP 10 /u01/app/oracle/oradata/cdb2/pdb2_1/my_temp_pdb2_01.dbf
RMAN> list backup of datafile 25;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0209.00M SBT_TAPE 00:00:10 2018-07-01:17:55:53
BP Key: 7 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 07t6u5ov_1_1 Media: station90-000004
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
25 0Incr 3792981 2018-07-01:17:55:43 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
RMAN> list backup of datafile 24;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Incr 0534.50M SBT_TAPE 00:00:14 2018-07-01:17:55:06
BP Key: 3 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 03t6u5nc_1_1 Media: station90-000004
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
24 0Incr 3792946 2018-07-01:17:54:52 /u01/app/oracle/oradata/cdb2/cdata_01.dbf
RMAN> list backup of datafile 10;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0209.00M SBT_TAPE 00:00:10 2018-07-01:17:55:53
BP Key: 7 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 07t6u5ov_1_1 Media: station90-000004
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
10 0Incr 3792981 2018-07-01:17:55:43 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
RMAN>
其中pdb2的备份:
RMAN> list backup ofdatafile 10;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0209.00M SBT_TAPE 00:00:10 2018-07-01:17:55:53
BP Key: 7 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 07t6u5ov_1_1 Media: station90-000004
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
10 0Incr 3792981 2018-07-01:17:55:43 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
RMAN> list backup ofdatafile 11;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Incr 0462.50M SBT_TAPE 00:00:12 2018-07-01:17:55:29
BP Key: 4 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 04t6u5o5_1_1 Media: station90-000003
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
11 0Incr 3792968 2018-07-01:17:55:17 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
RMAN> list backup ofdatafile 25;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0209.00M SBT_TAPE 00:00:10 2018-07-01:17:55:53
BP Key: 7 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 07t6u5ov_1_1 Media: station90-000004
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
25 0Incr 3792981 2018-07-01:17:55:43 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
新语法:插件数据库单独备份:
RMAN> backup tag '2T_PDB2_INCR0' incremental level 0 pluggable database pdb2;
Starting backup at 2018-07-01:18:03:03
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00011 name=/u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-01:18:03:03
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
input datafile file number=00025 name=/u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-01:18:03:03
channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-01:18:03:28
piece handle=0dt6u66n_1_1 tag=2T_PDB2_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-01:18:03:38
piece handle=0ct6u66n_1_1 tag=2T_PDB2_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
Finished backup at 2018-07-01:18:03:38
Starting Control File and SPFILE Autobackup at 2018-07-01:18:03:38
piece handle=c-727229478-20180701-01 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 2018-07-01:18:04:03
RMAN>
效果:
RMAN> list backup of datafile 10;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0209.00M SBT_TAPE 00:00:10 2018-07-01:17:55:53
BP Key: 7 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 07t6u5ov_1_1 Media: station90-000004
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
10 0Incr 3792981 2018-07-01:17:55:43 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Incr 0209.00M SBT_TAPE 00:00:09 2018-07-01:18:03:12
BP Key: 12 Status: AVAILABLECompressed: NOTag: 2T_PDB2_INCR0
Handle: 0dt6u66n_1_1 Media: station90-000003
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
10 0Incr 3794250 2018-07-01:18:03:03 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
RMAN> list backup of datafile 11;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Incr 0462.50M SBT_TAPE 00:00:12 2018-07-01:17:55:29
BP Key: 4 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 04t6u5o5_1_1 Media: station90-000003
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
11 0Incr 3792968 2018-07-01:17:55:17 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Incr 0462.50M SBT_TAPE 00:00:19 2018-07-01:18:03:22
BP Key: 13 Status: AVAILABLECompressed: NOTag: 2T_PDB2_INCR0
Handle: 0ct6u66n_1_1 Media: station90-000004
List of Datafiles in backup set 13
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
11 0Incr 3794249 2018-07-01:18:03:03 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
RMAN> list backup of datafile 25;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0209.00M SBT_TAPE 00:00:10 2018-07-01:17:55:53
BP Key: 7 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 07t6u5ov_1_1 Media: station90-000004
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
25 0Incr 3792981 2018-07-01:17:55:43 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Incr 0209.00M SBT_TAPE 00:00:09 2018-07-01:18:03:12
BP Key: 12 Status: AVAILABLECompressed: NOTag: 2T_PDB2_INCR0
Handle: 0dt6u66n_1_1 Media: station90-000003
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
25 0Incr 3794250 2018-07-01:18:03:03 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
RMAN>
新语法:
RMAN> backup tag '3T_PDB2:LDATA_INCR0' incremental level 0 tablespace pdb2:ldata;
Starting backup at 2018-07-01:18:07:27
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00025 name=/u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-01:18:07:27
channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-01:18:07:52
piece handle=0ft6u6ev_1_1 tag=3T_PDB2:LDATA_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
Finished backup at 2018-07-01:18:07:52
Starting Control File and SPFILE Autobackup at 2018-07-01:18:07:52
piece handle=c-727229478-20180701-02 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 2018-07-01:18:08:17
效果:
RMAN> list backup of datafile 25;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0209.00M SBT_TAPE 00:00:10 2018-07-01:17:55:53
BP Key: 7 Status: AVAILABLECompressed: NOTag: 1T_WHOLE_INCR0
Handle: 07t6u5ov_1_1 Media: station90-000004
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
25 0Incr 3792981 2018-07-01:17:55:43 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Incr 0209.00M SBT_TAPE 00:00:09 2018-07-01:18:03:12
BP Key: 12 Status: AVAILABLECompressed: NOTag: 2T_PDB2_INCR0
Handle: 0dt6u66n_1_1 Media: station90-000003
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
25 0Incr 3794250 2018-07-01:18:03:03 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
15 Incr 01.25M SBT_TAPE 00:00:09 2018-07-01:18:07:36
BP Key: 15 Status: AVAILABLECompressed: NOTag: 3T_PDB2:LDATA_INCR0
Handle: 0ft6u6ev_1_1 Media: station90-000003
List of Datafiles in backup set 15
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
25 0Incr 3794482 2018-07-01:18:07:27 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
RMAN>
页:
[1]