1. 原理
之前有介绍过怎么使用Transport Data来升级Oracle 11.2.0.3到12.2.版本。http://blog.csdn.net/cscscscsc/article/details/78035928
这里可以发散一下思维，如果我有一套11.2.0.3的DG环境，假设，我事先在所有的节点都安装好了新的Oracle12.2的数据库软件，并且安装新的数据库且能同步。我这个时候在主库升级11.2.0.3到12.2，从库是不是也能一起升级？带着这个疑问，我们实验一把。
这里有几个条件，大家得注意坑：
l 12.2DG环境中要配置standby_file_management为auto。
l 12.2DG环境中最好不要配置db_file_name_convert，防止主库在transport datafile的时候，主库的路径和备库不一致导致备库升级失败（这里面失败后能不能恢复，我还没研究，目测应该是可以的。可以的话还是对目录做一个软链接，或者最好保持主备库路劲一致）。
l 新建12.2的数据库实例不能和11.2.0.3同名，一个服务器不能搭建两个同名实例，后期升级完了建议在12.2.上新建一个和11.2.0.3同名的service，让应用使用service连接，就不会有问题。
l 11.2.0.3升级肯定是升级到12.2.的NON-CDB。
2. 操作步骤
2.1环境介绍
11g tnsname和db_unique_name名称一样
主库：dzdadg88
备库：dzdadg89
12c tnsname和db_unique_name名称一样
主库：dzditem88
备库：dzditem89
2.2所有节点安装Oracle12.2软件
这里不介绍安装步骤。
2.2所有节点搭建12.2的DG环境（NON-CDB）
在所有节点上搭建12.2的DG环境，主库依然是在11.2.0.3的主库上。如果搭建DG我就不介绍了，新建库和搭建DG和11.2.0.3一样，没什么区别。
记得之前的注意事项吗？
SQL> show parameter db_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
pdb_file_name_convert string
SQL> show parameter standby_file_management
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
2.3将11g主库mount并刷剩余日志到从库
我担心主备库的数据文件SCN不一致会导致升级失败或者因为主从库数据文件不一致导致后期出现问题，所以我们要将主备库数据文件的SCN刷一致后升级。
主库操作：
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1.3683E+11 bytes
Fixed Size 2245480 bytes
Variable Size 9126808728 bytes
Database Buffers 1.2751E+11 bytes
Redo Buffers 189480960 bytes
Database mounted.
SQL> alter system flush redo to 'dzdadg89';
System altered.
SQL> select CHECKPOINT_CHANGE# from v$database;
CHECKPOINT_CHANGE#
------------------
464111773603
备库查询：
备库不关闭，查询SCN
SQL> select current_scn from v$database;
current_scn
------------------
464111773603这个时候我们能发现两边的SCN一致就可以了，避免出现其他问题。
2.4主库使用transport导出
导出步骤请参阅文档 http://blog.csdn.net/cscscscsc/article/details/78035928
2.4关闭11g主备库
把11g的主备库都shutdown
2.5在12.2创建目录
2.5使用transport导出文件导入12.2升级
导入命令
impdp /' / as sysdba /' parfile=profile.f
这里因为数据文件较多，所以弄了一个parfile，内容如下：
FULL=Y
DUMPFILE=csong.dmp
DIRECTORY=lee
TRANSPORT_DATAFILES=
'/data/ora01/oradata/pdata01_1.dbf',
'/data/ora04/oradata/pdata01_61.dbf',
'/data/ora01/oradata/pdata01_29.dbf',
'/data/ora01/oradata/pdata01_3.dbf',
'/data/ora01/oradata/pdata01_32.dbf',
'/data/ora01/oradata/pdata01_33.dbf',
'/data/ora01/oradata/pdata01_34.dbf',
'/data/ora01/oradata/pdata01_35.dbf',
'/data/ora01/oradata/pdata01_36.dbf',
'/data/ora01/oradata/pdata01_4.dbf',
'/data/ora01/oradata/pdata01_44.dbf',
'/data/ora01/oradata/pdata01_48.dbf',
'/data/ora01/oradata/pdata01_5.dbf',
'/data/ora01/oradata/pdata01_54.dbf',
'/data/ora01/oradata/pdata01_58.dbf',
'/data/ora01/oradata/pdata01_6.dbf',
'/data/ora01/oradata/pdata01_7.dbf',
'/data/ora01/oradata/pdata01_8.dbf',
'/data/ora01/oradata/pdata01_9.dbf',
'/data/ora02/oradata/pdata01_10.dbf',
'/data/ora02/oradata/pdata01_11.dbf',
'/data/ora02/oradata/pdata01_12.dbf',
'/data/ora02/oradata/pdata01_13.dbf',
'/data/ora02/oradata/pdata01_14.dbf',
'/data/ora02/oradata/pdata01_15.dbf',
'/data/ora02/oradata/pdata01_16.dbf',
'/data/ora02/oradata/pdata01_17.dbf',
'/data/ora02/oradata/pdata01_18.dbf',
'/data/ora02/oradata/pdata01_19.dbf',
'/data/ora02/oradata/pdata01_30.dbf',
'/data/ora02/oradata/pdata01_37.dbf',
'/data/ora02/oradata/pdata01_45.dbf',
'/data/ora02/oradata/pdata01_49.dbf',
'/data/ora02/oradata/pdata01_52.dbf',
'/data/ora02/oradata/pdata01_55.dbf',
'/data/ora02/oradata/pdata01_59.dbf',
'/data/ora03/oradata/pdata01_20.dbf',
'/data/ora03/oradata/pdata01_21.dbf',
'/data/ora03/oradata/pdata01_22.dbf',
'/data/ora03/oradata/pdata01_23.dbf',
'/data/ora03/oradata/pdata01_24.dbf',
'/data/ora03/oradata/pdata01_25.dbf',
'/data/ora03/oradata/pdata01_26.dbf',
'/data/ora03/oradata/pdata01_31.dbf',
'/data/ora03/oradata/pdata01_38.dbf',
'/data/ora03/oradata/pdata01_39.dbf',
'/data/ora03/oradata/pdata01_40.dbf',
'/data/ora03/oradata/pdata01_46.dbf',
'/data/ora03/oradata/pdata01_50.dbf',
'/data/ora03/oradata/pdata01_53.dbf',
'/data/ora03/oradata/pdata01_56.dbf',
'/data/ora03/oradata/pdata01_60.dbf',
'/data/ora04/oradata/pdata01_27.dbf',
'/data/ora04/oradata/pdata01_28.dbf',
'/data/ora04/oradata/pdata01_41.dbf',
'/data/ora04/oradata/pdata01_42.dbf',
'/data/ora04/oradata/pdata01_43.dbf',
'/data/ora04/oradata/pdata01_47.dbf',
'/data/ora04/oradata/pdata01_51.dbf',
'/data/ora04/oradata/pdata01_57.dbf',
'/data/ora01/oradata/pdata01_2.dbf',
'/data/ora04/oradata/pindex01_01.dbf',
'/data/ora04/oradata/pindex01_02.dbf',
'/data/ora04/oradata/pindex01_06.dbf',
'/data/ora04/oradata/pindex01_04.dbf',
'/data/ora04/oradata/pindex01_05.dbf',
'/data/ora04/oradata/pindex01_03.dbf'
LOGFILE=import.log
;;;
Import: Release 12.2.0.1.0 - Production on Tue Sep 19 14:53:09 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
;;; **************************************************************************
;;; Parfile values:
;;; parfile: logfile=import.log
;;; parfile: transport_datafiles=/data/ora01/oradata/pdata01_1.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_61.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_29.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_3.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_32.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_33.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_34.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_35.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_36.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_4.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_44.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_48.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_5.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_54.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_58.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_6.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_7.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_8.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_9.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_10.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_11.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_12.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_13.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_14.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_15.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_16.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_17.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_18.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_19.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_30.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_37.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_45.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_49.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_52.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_55.dbf,
;;; _parfile: /data/ora02/oradata/pdata01_59.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_20.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_21.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_22.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_23.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_24.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_25.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_26.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_31.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_38.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_39.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_40.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_46.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_50.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_53.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_56.dbf,
;;; _parfile: /data/ora03/oradata/pdata01_60.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_27.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_28.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_41.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_42.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_43.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_47.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_51.dbf,
;;; _parfile: /data/ora04/oradata/pdata01_57.dbf,
;;; _parfile: /data/ora01/oradata/pdata01_2.dbf,
;;; _parfile: /data/ora04/oradata/pindex01_01.dbf,
;;; _parfile: /data/ora04/oradata/pindex01_02.dbf,
;;; _parfile: /data/ora04/oradata/pindex01_06.dbf,
;;; _parfile: /data/ora04/oradata/pindex01_04.dbf,
;;; _parfile: /data/ora04/oradata/pindex01_05.dbf,
;;; _parfile: /data/ora04/oradata/pindex01_03.dbf
;;; parfile: directory=lee
;;; parfile: dumpfile=csong.dmp
;;; parfile: full=Y
;;; **************************************************************************
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Source time zone is +08:00 and target time zone is +00:00.
Starting "SYS"."SYS_IMPORT_FULL_01": "/******** AS SYSDBA" parfile=profile.f
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"TEMP" already exists
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
ORA-31685: Object type USER:"SYS" failed due to insufficient privileges. Failing sql is:
ALTER USER "SYS" IDENTIFIED BY VALUES 'S:0D5E902B2B0D16C8CEE1CD5F28D9238FAC5B395169F055E66FD6294B1211;8A8F025737A9097A' TEMPORARY TABLESPACE "TEMP"
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-31684: Object type USER:"OUTLN" already exists
ORA-39384: Warning: User QRYTMP has been locked and the password expired.
Processing object type DATABASE_EXPORT/ROLE
ORA-31684: Object type ROLE:"SELECT_CATALOG_ROLE" already exists
ORA-31684: Object type ROLE:"EXECUTE_CATALOG_ROLE" already exists
ORA-31684: Object type ROLE:"DBFS_ROLE" already exists
ORA-31684: Object type ROLE:"AQ_ADMINISTRATOR_ROLE" already exists
ORA-31684: Object type ROLE:"AQ_USER_ROLE" already exists
ORA-31684: Object type ROLE:"ADM_PARALLEL_EXECUTE_TASK" already exists
ORA-31684: Object type ROLE:"GATHER_SYSTEM_STATISTICS" already exists
ORA-31684: Object type ROLE:"RECOVERY_CATALOG_OWNER" already exists
ORA-31684: Object type ROLE:"SCHEDULER_ADMIN" already exists
ORA-31684: Object type ROLE:"HS_ADMIN_SELECT_ROLE" already exists
ORA-31684: Object type ROLE:"HS_ADMIN_EXECUTE_ROLE" already exists
ORA-31684: Object type ROLE:"HS_ADMIN_ROLE" already exists
ORA-31684: Object type ROLE:"GLOBAL_AQ_USER_ROLE" already exists
ORA-31684: Object type ROLE:"OEM_ADVISOR" already exists
ORA-31684: Object type ROLE:"OEM_MONITOR" already exists
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
ORA-31684: Object type DIRECTORY:"ORACLE_OCM_CONFIG_DIR" already exists
ORA-31684: Object type DIRECTORY:"DATA_PUMP_DIR" already exists
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
ORA-31684: Object type CONTEXT:"GLOBAL_AQCLNTDB_CTX" already exists
ORA-31684: Object type CONTEXT:"DBFS_CONTEXT" already exists
ORA-31684: Object type CONTEXT:"REGISTRY$CTX" already exists
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-04042: procedure, function, package, or package body does not exist
Failing sql is:
BEGIN
SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON DBMS_DEFER_SYS TO DBA');COMMIT; END;
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
. . imported "SYS"."KU$_EXPORT_USER_MAP" 5.656 KB 18 rows
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
. . imported "SYS"."AMGT$DP$AUD$" 1.895 GB 11804533 rows
. . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM$" 6.351 KB 10 rows
. . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS$" 0 KB 0 rows
. . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS$" 0 KB 0 rows
. . imported "SYS"."AMGT$DP$FGA_LOG$" 0 KB 0 rows
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
. . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP" 8.437 KB 4 rows
ORA-31693: Table data object "SYSTEM"."SCHEDULER_PROGRAM_ARGS_TMP" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-22303: type "SYS"."JDM_ATTR_NAMES" not found
ORA-21700: object does not exist or is marked for delete
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "SYSTEM"."DEF$_DESTINATION" 13.55 KB 1 rows
. . imported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" 6.320 KB 2 rows
. . imported "SYSTEM"."REPCAT$_OBJECT_TYPES" 6.875 KB 28 rows
. . imported "SYSTEM"."REPCAT$_RESOLUTION_METHOD" 5.828 KB 19 rows
. . imported "SYSTEM"."REPCAT$_TEMPLATE_STATUS" 5.476 KB 3 rows
. . imported "SYSTEM"."REPCAT$_TEMPLATE_TYPES" 6.281 KB 2 rows
. . imported "INSHOP"."TOAD_PLAN_TABLE" 0 KB 0 rows
. . imported "OUTLN"."OL$" 0 KB 0 rows
. . imported "OUTLN"."OL$HINTS" 0 KB 0 rows
. . imported "OUTLN"."OL$NODES" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_AQCALL" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_AQERROR" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_CALLDEST" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_DEFAULTDEST" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_ERROR" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_LOB" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_ORIGIN" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_PROPAGATOR" 0 KB 0 rows
. . imported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_AUDIT_COLUMN" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_COLUMN_GROUP" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_CONFLICT" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_DDL" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_EXCEPTIONS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_EXTENSION" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_FLAVORS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_GENERATED" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_GROUPED_COLUMN" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_INSTANTIATION_DDL" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_KEY_COLUMNS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_OBJECT_PARMS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_PARAMETER_COLUMN" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_PRIORITY" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_PRIORITY_GROUP" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_REFRESH_TEMPLATES" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_REPCAT" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_REPCATLOG" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_REPCOLUMN" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_REPGROUP_PRIVS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_REPOBJECT" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_REPPROP" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_REPSCHEMA" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_RESOLUTION" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_RUNTIME_PARMS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_SITES_NEW" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_SITE_OBJECTS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_SNAPGROUP" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_TEMPLATE_PARMS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_TEMPLATE_SITES" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows
. . imported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
ORA-39346: data loss in character set conversion for object COMMENT:"INSHOP"."INSHOP_API_UPDATE_LOG"
ORA-39346: data loss in character set conversion for object COMMENT:"INSHOP"."INSHOP_API_UPDATE_LOG"
ORA-39346: data loss in character set conversion for object COMMENT:"INSHOP"."INSHOP_API_UPDATE_LOG"
ORA-39346: data loss in character set conversion for object COMMENT:"INSHOP"."INSHOP_API_UPDATE_LOG"
ORA-39346: data loss in character set conversion for object COMMENT:"INSHOP"."INSHOP_API_UPDATE_LOG"
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39346: data loss in character set conversion for object TABLE_STATISTICS:"INSHOP"."HOLD_PM_INFO"
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Processing object type DATABASE_EXPORT/END_PLUGTS_BLK
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
Job "SYS"."SYS_IMPORT_FULL_01" completed with 33 error(s) at Tue Sep 19 15:02:17 2017 elapsed 0 00:09:04
2.6查看主备库alert日志
主库：
$ tail -f /u01/app/oracle/diag/rdbms/dzditem88/dzditem/trace/alert_dzditem.log
Archived Log entry 7 added for T-1.S-14 ID 0x823f9c2d LAD:1
2017-09-19T14:47:10.660184+08:00
Thread 1 cannot allocate new log, sequence 16
Checkpoint not complete
Current log# 3 seq# 15 mem# 0: /u01/app/oracle/oradata/dzditem/redo03.log
2017-09-19T14:47:10.878797+08:00
Thread 1 advanced to log sequence 16 (LGWR switch)
Current log# 1 seq# 16 mem# 0: /u01/app/oracle/oradata/dzditem/redo01.log
2017-09-19T14:47:10.885607+08:00
Archived Log entry 8 added for T-1.S-15 ID 0x823f9c2d LAD:1
2017-09-19T14:48:09.743391+08:00
Thread 1 advanced to log sequence 17 (LGWR switch)
Current log# 2 seq# 17 mem# 0: /u01/app/oracle/oradata/dzditem/redo02.log
2017-09-19T14:48:09.754307+08:00
Archived Log entry 9 added for T-1.S-16 ID 0x823f9c2d LAD:1
2017-09-19T14:49:04.419987+08:00
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';
2017-09-19T14:49:04.950403+08:00
Thread 1 cannot allocate new log, sequence 18
Checkpoint not complete
Current log# 2 seq# 17 mem# 0: /u01/app/oracle/oradata/dzditem/redo02.log
2017-09-19T14:49:07.958332+08:00
Thread 1 advanced to log sequence 18 (LGWR switch)
Current log# 3 seq# 18 mem# 0: /u01/app/oracle/oradata/dzditem/redo03.log
2017-09-19T14:49:07.960797+08:00
Archived Log entry 17 added for T-1.S-17 ID 0x823f9c2d LAD:1
2017-09-19T14:53:13.035332+08:00
DM00 started with pid=155, OS id=8536, job SYS.SYS_IMPORT_FULL_01
2017-09-19T14:53:13.953911+08:00
DW00 started with pid=156, OS id=8540, wid=1, job SYS.SYS_IMPORT_FULL_01
2017-09-19T14:53:15.409793+08:00
Resize operation completed for file# 1, old size 829440K, new size 839680K
Resize operation completed for file# 1, old size 839680K, new size 849920K
2017-09-19T14:53:18.808230+08:00
Session (1454,17419): EXTERNAL SCN ALERT: Advanced SCN by 472117 minutes worth to 0x0000006c0f343d73, by Tablespace plug-in
Session (1454,17419): EXTERNAL SCN SOURCE: Inbound connection from client
Session (1454,17419): EXTERNAL SCN SOURCE: DB Logon User: SYS, Remote Machine: SRV-300946, Program: oracle@SRV-300946 (DW00), OS User: oracle
Session (1454,17419): EXTERNAL SCN SOURCE: Could not find Client IP Address
Plug in tablespace PDATA01 with datafile
'/data/ora04/oradata/pdata01_61.dbf'
'/data/ora03/oradata/pdata01_60.dbf'
'/data/ora02/oradata/pdata01_59.dbf'
'/data/ora01/oradata/pdata01_58.dbf'
'/data/ora04/oradata/pdata01_57.dbf'
'/data/ora03/oradata/pdata01_56.dbf'
'/data/ora02/oradata/pdata01_55.dbf'
'/data/ora01/oradata/pdata01_54.dbf'
'/data/ora03/oradata/pdata01_53.dbf'
'/data/ora02/oradata/pdata01_52.dbf'
'/data/ora04/oradata/pdata01_51.dbf'
'/data/ora03/oradata/pdata01_50.dbf'
'/data/ora02/oradata/pdata01_49.dbf'
'/data/ora01/oradata/pdata01_48.dbf'
'/data/ora04/oradata/pdata01_47.dbf'
'/data/ora03/oradata/pdata01_46.dbf'
'/data/ora02/oradata/pdata01_45.dbf'
'/data/ora01/oradata/pdata01_44.dbf'
'/data/ora04/oradata/pdata01_43.dbf'
'/data/ora04/oradata/pdata01_42.dbf'
'/data/ora04/oradata/pdata01_41.dbf'
'/data/ora03/oradata/pdata01_40.dbf'
'/data/ora03/oradata/pdata01_39.dbf'
'/data/ora03/oradata/pdata01_38.dbf'
'/data/ora02/oradata/pdata01_37.dbf'
'/data/ora01/oradata/pdata01_36.dbf'
'/data/ora01/oradata/pdata01_35.dbf'
'/data/ora01/oradata/pdata01_34.dbf'
'/data/ora01/oradata/pdata01_33.dbf'
'/data/ora01/oradata/pdata01_32.dbf'
'/data/ora03/oradata/pdata01_31.dbf'
'/data/ora02/oradata/pdata01_30.dbf'
'/data/ora01/oradata/pdata01_29.dbf'
'/data/ora04/oradata/pdata01_28.dbf'
'/data/ora04/oradata/pdata01_27.dbf'
'/data/ora03/oradata/pdata01_26.dbf'
'/data/ora03/oradata/pdata01_25.dbf'
'/data/ora03/oradata/pdata01_24.dbf'
'/data/ora03/oradata/pdata01_23.dbf'
'/data/ora03/oradata/pdata01_22.dbf'
'/data/ora03/oradata/pdata01_21.dbf'
'/data/ora03/oradata/pdata01_20.dbf'
'/data/ora02/oradata/pdata01_19.dbf'
'/data/ora02/oradata/pdata01_18.dbf'
'/data/ora02/oradata/pdata01_17.dbf'
'/data/ora02/oradata/pdata01_16.dbf'
'/data/ora02/oradata/pdata01_15.dbf'
'/data/ora02/oradata/pdata01_14.dbf'
'/data/ora02/oradata/pdata01_13.dbf'
'/data/ora02/oradata/pdata01_12.dbf'
'/data/ora02/oradata/pdata01_11.dbf'
'/data/ora02/oradata/pdata01_10.dbf'
'/data/ora01/oradata/pdata01_9.dbf'
'/data/ora01/oradata/pdata01_8.dbf'
'/data/ora01/oradata/pdata01_7.dbf'
'/data/ora01/oradata/pdata01_6.dbf'
'/data/ora01/oradata/pdata01_5.dbf'
'/data/ora01/oradata/pdata01_4.dbf'
'/data/ora01/oradata/pdata01_3.dbf'
'/data/ora01/oradata/pdata01_2.dbf'
'/data/ora01/oradata/pdata01_1.dbf'
Plug in tablespace PINDEX01 with datafile
'/data/ora04/oradata/pindex01_06.dbf'
'/data/ora04/oradata/pindex01_05.dbf'
'/data/ora04/oradata/pindex01_04.dbf'
'/data/ora04/oradata/pindex01_03.dbf'
'/data/ora04/oradata/pindex01_02.dbf'
'/data/ora04/oradata/pindex01_01.dbf'
CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/data/ora04/oradata/undotbs01.dbf' SIZE 10737418240,'/data/ora04/oradata/undotbs02.dbf' SIZE 5368709120,'/data/ora04/oradata/undotbs03.dbf' SIZE 10737418240 BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ORA-1543 signalled during: CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/data/ora04/oradata/undotbs01.dbf' SIZE 10737418240,'/data/ora04/oradata/undotbs02.dbf' SIZE 5368709120,'/data/ora04/oradata/undotbs03.dbf' SIZE 10737418240 BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE...
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/data/ora04/oradata/temp02.dbf' SIZE 21474836480 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
ORA-1543 signalled during: CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/data/ora04/oradata/temp02.dbf' SIZE 21474836480 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576...
2017-09-19T14:53:19.843100+08:00
Buffer Cache Full DB Caching mode changing from FULL CACHING ENABLED to FULL CACHING DISABLED
Full DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 1207053 MBs bigger than current size.
2017-09-19T14:53:52.515690+08:00
Resize operation completed for file# 1, old size 849920K, new size 860160K
Resize operation completed for file# 1, old size 860160K, new size 870400K
Resize operation completed for file# 1, old size 870400K, new size 880640K
Resize operation completed for file# 1, old size 880640K, new size 890880K
2017-09-19T14:53:53.574141+08:00
Resize operation completed for file# 1, old size 890880K, new size 901120K
Resize operation completed for file# 1, old size 901120K, new size 911360K
Resize operation completed for file# 1, old size 911360K, new size 921600K
Resize operation completed for file# 1, old size 921600K, new size 931840K
Resize operation completed for file# 1, old size 931840K, new size 942080K
2017-09-19T14:53:54.614922+08:00
Resize operation completed for file# 1, old size 942080K, new size 952320K
Resize operation completed for file# 1, old size 952320K, new size 962560K
Resize operation completed for file# 1, old size 962560K, new size 972800K
Resize operation completed for file# 1, old size 972800K, new size 983040K
Resize operation completed for file# 1, old size 983040K, new size 993280K
2017-09-19T14:53:55.420014+08:00
Thread 1 advanced to log sequence 19 (LGWR switch)
Current log# 1 seq# 19 mem# 0: /u01/app/oracle/oradata/dzditem/redo01.log
2017-09-19T14:53:55.481642+08:00
Resize operation completed for file# 1, old size 993280K, new size 1003520K
Resize operation completed for file# 1, old size 1003520K, new size 1013760K
2017-09-19T14:53:55.696477+08:00
Resize operation completed for file# 1, old size 1013760K, new size 1024000K
2017-09-19T14:53:55.920856+08:00
Archived Log entry 20 added for T-1.S-18 ID 0x823f9c2d LAD:1
2017-09-19T14:53:55.923125+08:00
Resize operation completed for file# 1, old size 1024000K, new size 1034240K
Resize operation completed for file# 1, old size 1034240K, new size 1044480K
Resize operation completed for file# 1, old size 1044480K, new size 1054720K
Resize operation completed for file# 1, old size 1054720K, new size 1064960K
Resize operation completed for file# 1, old size 1064960K, new size 1075200K
Resize operation completed for file# 1, old size 1075200K, new size 1085440K
2017-09-19T14:53:56.784613+08:00
Resize operation completed for file# 1, old size 1085440K, new size 1095680K
Resize operation completed for file# 1, old size 1095680K, new size 1105920K
2017-09-19T14:53:57.090792+08:00
Resize operation completed for file# 1, old size 1105920K, new size 1116160K
Resize operation completed for file# 1, old size 1116160K, new size 1126400K
Resize operation completed for file# 1, old size 1126400K, new size 1136640K
Resize operation completed for file# 1, old size 1136640K, new size 1146880K
2017-09-19T14:53:57.814021+08:00
Resize operation completed for file# 1, old size 1146880K, new size 1157120K
Resize operation completed for file# 1, old size 1157120K, new size 1167360K
备库：
# tail -f /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/alert_dzditem.log
RFS[3]: Assigned to RFS process (PID:8087)
RFS[3]: No standby redo logfiles created
RFS[3]: Opened log for T-1.S-16 dbid 2185219117 branch 955034863
2017-09-19T14:48:09.842613+08:00
Archived Log entry 1 added for thread 1 sequence 16 rlc 955034863 ID 0x823f9c2d LAD2 :
2017-09-19T14:48:09.968588+08:00
Primary database is in MAXIMUM PERFORMANCE mode
RFS[4]: Assigned to RFS process (PID:8097)
RFS[4]: No standby redo logfiles created
RFS[4]: Opened log for T-1.S-17 dbid 2185219117 branch 955034863
2017-09-19T14:48:51.891544+08:00
RFS[5]: Assigned to RFS process (PID:8110)
RFS[5]: Opened log for T-1.S-11 dbid 2185219117 branch 955034863
2017-09-19T14:48:51.891776+08:00
RFS[6]: Assigned to RFS process (PID:8112)
RFS[6]: Opened log for T-1.S-12 dbid 2185219117 branch 955034863
2017-09-19T14:48:51.897462+08:00
RFS[7]: Assigned to RFS process (PID:8108)
RFS[7]: Opened log for T-1.S-10 dbid 2185219117 branch 955034863
2017-09-19T14:48:51.900209+08:00
Archived Log entry 2 added for thread 1 sequence 11 rlc 955034863 ID 0x823f9c2d LAD2 :
2017-09-19T14:48:51.901147+08:00
Archived Log entry 3 added for thread 1 sequence 12 rlc 955034863 ID 0x823f9c2d LAD2 :
RFS[5]: Opened log for T-1.S-13 dbid 2185219117 branch 955034863
RFS[6]: Opened log for T-1.S-14 dbid 2185219117 branch 955034863
2017-09-19T14:48:51.906066+08:00
Archived Log entry 4 added for thread 1 sequence 10 rlc 955034863 ID 0x823f9c2d LAD2 :
2017-09-19T14:48:51.907124+08:00
Archived Log entry 5 added for thread 1 sequence 13 rlc 955034863 ID 0x823f9c2d LAD2 :
2017-09-19T14:48:51.907998+08:00
Archived Log entry 6 added for thread 1 sequence 14 rlc 955034863 ID 0x823f9c2d LAD2 :
RFS[7]: Opened log for T-1.S-15 dbid 2185219117 branch 955034863
2017-09-19T14:48:51.911853+08:00
Archived Log entry 7 added for thread 1 sequence 15 rlc 955034863 ID 0x823f9c2d LAD2 :
2017-09-19T14:49:04.299419+08:00
alter database open
2017-09-19T14:49:04.348524+08:00
Ping without log force is disabled:
instance mounted in exclusive mode.
Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED
Signalling error 1152 for datafile 1!
2017-09-19T14:49:04.351279+08:00
Beginning Standby Crash Recovery.
2017-09-19T14:49:04.378228+08:00
Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_m000_8135.trc:
ORA-01110: data file 1: '/u01/app/oracle/oradata/dzditem/system01.dbf'
Started logmerger process
2017-09-19T14:49:04.402189+08:00
Managed Standby Recovery starting Real Time Apply
2017-09-19T14:49:04.471704+08:00
Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_m000_8135.trc:
ORA-01110: data file 3: '/u01/app/oracle/oradata/dzditem/sysaux01.dbf'
2017-09-19T14:49:04.562804+08:00
Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_m000_8135.trc:
ORA-01110: data file 4: '/u01/app/oracle/oradata/dzditem/undotbs01.dbf'
2017-09-19T14:49:04.654244+08:00
Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_m000_8135.trc:
ORA-01110: data file 7: '/u01/app/oracle/oradata/dzditem/users01.dbf'
2017-09-19T14:49:04.802553+08:00
Parallel Media Recovery started with 24 slaves
2017-09-19T14:49:04.899159+08:00
Media Recovery Log /data/arch/1_10_955034863.dbf
2017-09-19T14:49:04.981403+08:00
Incomplete Recovery applied until change 1527157 time 09/19/2017 14:40:08
2017-09-19T14:49:05.103555+08:00
Completed Standby Crash Recovery.
Endian type of dictionary set to little
2017-09-19T14:49:05.328455+08:00
Undo initialization finished serial:0 start:2559791653 end:2559791653 diff:0 ms (0.0 seconds)
Dictionary check beginning
2017-09-19T14:49:05.343344+08:00
Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_dbw0_7720.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/dzditem/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2017-09-19T14:49:05.343539+08:00
Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_dbw0_7720.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/dzditem/temp01.dbf'
2017-09-19T14:49:05.343621+08:00
File 201 not verified due to error ORA-01157
2017-09-19T14:49:05.344490+08:00
Dictionary check complete
2017-09-19T14:49:05.344958+08:00
Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_dbw0_7720.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/dzditem/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2017-09-19T14:49:05.345124+08:00
Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_dbw0_7720.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/dzditem/temp01.dbf'
2017-09-19T14:49:05.345209+08:00
File 201 not verified due to error ORA-01157
2017-09-19T14:49:05.351463+08:00
Re-creating tempfile /u01/app/oracle/oradata/dzditem/temp01.dbf
Database Characterset is UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: alter database open
2017-09-19T14:49:05.997511+08:00
Unable to obtain current patch information as the database or pluggable database was opened for read-only access.
===========================================================
Dumping current patch information
===========================================================
Unable to obtain current patch information due to error: 16000
===========================================================
2017-09-19T14:49:08.055399+08:00
Archived Log entry 8 added for thread 1 sequence 17 rlc 955034863 ID 0x823f9c2d LAD2 :
RFS[4]: No standby redo logfiles created
RFS[4]: Opened log for T-1.S-18 dbid 2185219117 branch 955034863
2017-09-19T14:49:22.327167+08:00
Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated.
Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated.
alter database recover managed standby database using current logfile disconnect from session
WARNING: There are no standby redo logs.
Standby redo logs should be configured for real time apply. Real time apply will be ignored.
2017-09-19T14:49:22.334956+08:00
Attempt to start background Managed Standby Recovery process (dzditem)
Starting background process MRP0
2017-09-19T14:49:22.351420+08:00
MRP0 started with pid=146, OS id=8667
2017-09-19T14:49:22.352574+08:00
MRP0: Background Managed Standby Recovery process started (dzditem)
2017-09-19T14:49:27.378087+08:00
Started logmerger process
2017-09-19T14:49:27.405094+08:00
Managed Standby Recovery not using Real Time Apply
2017-09-19T14:49:27.773695+08:00
Parallel Media Recovery started with 24 slaves
2017-09-19T14:49:27.829242+08:00
Waiting for all non-current ORLs to be archived
2017-09-19T14:49:27.829351+08:00
All non-current ORLs have been archived
2017-09-19T14:49:27.860130+08:00
Media Recovery Log /data/arch/1_10_955034863.dbf
2017-09-19T14:49:27.951002+08:00
Media Recovery Log /data/arch/1_11_955034863.dbf
2017-09-19T14:49:28.034022+08:00
Media Recovery Log /data/arch/1_12_955034863.dbf
2017-09-19T14:49:28.127009+08:00
Media Recovery Log /data/arch/1_13_955034863.dbf
2017-09-19T14:49:28.219992+08:00
Media Recovery Log /data/arch/1_14_955034863.dbf
2017-09-19T14:49:28.300021+08:00
Media Recovery Log /data/arch/1_15_955034863.dbf
2017-09-19T14:49:28.357869+08:00
Completed: alter database recover managed standby database using current logfile disconnect from session
2017-09-19T14:49:28.389986+08:00
Media Recovery Log /data/arch/1_16_955034863.dbf
2017-09-19T14:49:28.500105+08:00
Media Recovery Log /data/arch/1_17_955034863.dbf
Media Recovery Waiting for thread 1 sequence 18 (in transit)
2017-09-19T14:53:55.626638+08:00
Archived Log entry 9 added for thread 1 sequence 18 rlc 955034863 ID 0x823f9c2d LAD2 :
RFS[4]: No standby redo logfiles created
RFS[4]: Opened log for T-1.S-19 dbid 2185219117 branch 955034863
2017-09-19T14:53:56.044201+08:00
Media Recovery Log /data/arch/1_18_955034863.dbf
Resize operation completed for file# 1, old size 829440K, new size 839680K
Resize operation completed for file# 1, old size 839680K, new size 849920K
Resize operation completed for file# 1, old size 849920K, new size 860160K
Resize operation completed for file# 1, old size 860160K, new size 870400K
Resize operation completed for file# 1, old size 870400K, new size 880640K
Resize operation completed for file# 1, old size 880640K, new size 890880K
Resize operation completed for file# 1, old size 890880K, new size 901120K
2017-09-19T14:53:57.006511+08:00
Buffer Cache Full DB Caching mode changing from FULL CACHING ENABLED to FULL CACHING DISABLED
Full DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 1206490 MBs bigger than current size.
2017-09-19T14:53:57.207741+08:00
Resize operation completed for file# 1, old size 901120K, new size 911360K
Resize operation completed for file# 1, old size 911360K, new size 921600K
Resize operation completed for file# 1, old size 921600K, new size 931840K
Resize operation completed for file# 1, old size 931840K, new size 942080K
Resize operation completed for file# 1, old size 942080K, new size 952320K
Resize operation completed for file# 1, old size 952320K, new size 962560K
Resize operation completed for file# 1, old size 962560K, new size 972800K
Resize operation completed for file# 1, old size 972800K, new size 983040K
Resize operation completed for file# 1, old size 983040K, new size 993280K
Media Recovery Waiting for thread 1 sequence 19 (in transit)
2017-09-19T14:53:58.431707+08:00
Archived Log entry 10 added for thread 1 sequence 19 rlc 955034863 ID 0x823f9c2d LAD2 :
RFS[4]: No standby redo logfiles created
RFS[4]: Opened log for T-1.S-20 dbid 2185219117 branch 955034863
2017-09-19T14:53:59.194899+08:00
Media Recovery Log /data/arch/1_19_955034863.dbf
Resize operation completed for file# 1, old size 993280K, new size 1003520K
Resize operation completed for file# 1, old size 1003520K, new size 1013760K
Resize operation completed for file# 1, old size 1013760K, new size 1024000K
Resize operation completed for file# 1, old size 1024000K, new size 1034240K
Resize operation completed for file# 1, old size 1034240K, new size 1044480K
Resize operation completed for file# 1, old size 1044480K, new size 1054720K
Resize operation completed for file# 1, old size 1054720K, new size 1064960K
Resize operation completed for file# 1, old size 1064960K, new size 1075200K
Resize operation completed for file# 1, old size 1075200K, new size 1085440K
Resize operation completed for file# 1, old size 1085440K, new size 1095680K
Resize operation completed for file# 1, old size 1095680K, new size 1105920K
从备库alert日志能发现，从库在同步，有一些警告是import后的系统表空间创建的警告，可以忽略。
主备库校验：
主库查询：
SQL> select sequence#,applied from v$archived_log;
SEQUENCE# APPLIED
---------- ---------
64 YES
65 YES
66 YES
67 YES
68 YES
5 rows selected.
备库查询：
SQL> select sequence#,applied from v$archived_log;
SEQUENCE# APPLIED
---------- ---------
64 YES
65 YES
66 YES
67 YES
68 YES
5 rows selected.
4404
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
