传输数据库升级11.2.0.3 DG集群到12.2
来源:互联网 发布:linux vi 批量删除 编辑:程序博客网 时间:2024/06/06 19:12
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 stringpdb_file_name_convert stringSQL> show parameter standby_file_management NAME TYPE VALUE------------------------------------ ----------- ------------------------------standby_file_management string AUTO
2.3将11g主库mount并刷剩余日志到从库
我担心主备库的数据文件SCN不一致会导致升级失败或者因为主从库数据文件不一致导致后期出现问题,所以我们要将主备库数据文件的SCN刷一致后升级。
主库操作:
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started. Total System Global Area 1.3683E+11 bytesFixed Size 2245480 bytesVariable Size 9126808728 bytesDatabase Buffers 1.2751E+11 bytesRedo Buffers 189480960 bytesDatabase 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=YDUMPFILE=csong.dmpDIRECTORY=leeTRANSPORT_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/unloadedSource time zone is +08:00 and target time zone is +00:00.Starting "SYS"."SYS_IMPORT_FULL_01": "/******** AS SYSDBA" parfile=profile.fProcessing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKERProcessing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKERProcessing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLKProcessing object type DATABASE_EXPORT/TABLESPACEORA-31684: Object type TABLESPACE:"UNDOTBS1" already existsORA-31684: Object type TABLESPACE:"TEMP" already existsProcessing object type DATABASE_EXPORT/PROFILEProcessing object type DATABASE_EXPORT/SYS_USER/USERORA-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/USERORA-31684: Object type USER:"OUTLN" already existsORA-39384: Warning: User QRYTMP has been locked and the password expired.Processing object type DATABASE_EXPORT/ROLEORA-31684: Object type ROLE:"SELECT_CATALOG_ROLE" already existsORA-31684: Object type ROLE:"EXECUTE_CATALOG_ROLE" already existsORA-31684: Object type ROLE:"DBFS_ROLE" already existsORA-31684: Object type ROLE:"AQ_ADMINISTRATOR_ROLE" already existsORA-31684: Object type ROLE:"AQ_USER_ROLE" already existsORA-31684: Object type ROLE:"ADM_PARALLEL_EXECUTE_TASK" already existsORA-31684: Object type ROLE:"GATHER_SYSTEM_STATISTICS" already existsORA-31684: Object type ROLE:"RECOVERY_CATALOG_OWNER" already existsORA-31684: Object type ROLE:"SCHEDULER_ADMIN" already existsORA-31684: Object type ROLE:"HS_ADMIN_SELECT_ROLE" already existsORA-31684: Object type ROLE:"HS_ADMIN_EXECUTE_ROLE" already existsORA-31684: Object type ROLE:"HS_ADMIN_ROLE" already existsORA-31684: Object type ROLE:"GLOBAL_AQ_USER_ROLE" already existsORA-31684: Object type ROLE:"OEM_ADVISOR" already existsORA-31684: Object type ROLE:"OEM_MONITOR" already existsProcessing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANTProcessing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANTProcessing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANTProcessing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLEProcessing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTAProcessing object type DATABASE_EXPORT/RESOURCE_COSTProcessing object type DATABASE_EXPORT/TRUSTED_DB_LINKProcessing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCEProcessing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANTProcessing object type DATABASE_EXPORT/DIRECTORY/DIRECTORYORA-31684: Object type DIRECTORY:"ORACLE_OCM_CONFIG_DIR" already existsORA-31684: Object type DIRECTORY:"DATA_PUMP_DIR" already existsProcessing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANTProcessing object type DATABASE_EXPORT/CONTEXTORA-31684: Object type CONTEXT:"GLOBAL_AQCLNTDB_CTX" already existsORA-31684: Object type CONTEXT:"DBFS_CONTEXT" already existsORA-31684: Object type CONTEXT:"REGISTRY$CTX" already existsProcessing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYMProcessing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPECProcessing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEMProcessing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJProcessing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEMORA-39083: Object type PROCACT_SYSTEM failed to create with error:ORA-04042: procedure, function, package, or package body does not exist Failing sql is:BEGINSYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON DBMS_DEFER_SYS TO DBA');COMMIT; END;Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMAProcessing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLEProcessing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA. . imported "SYS"."KU$_EXPORT_USER_MAP" 5.656 KB 18 rowsProcessing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKERProcessing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLEProcessing 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 rowsProcessing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLEProcessing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA. . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP" 8.437 KB 4 rowsORA-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 calloutORA-22303: type "SYS"."JDM_ATTR_NAMES" not foundORA-21700: object does not exist or is marked for deleteProcessing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKERProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLEProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTIONProcessing 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 rowsProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANTProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENTORA-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_SPECProcessing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDUREProcessing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDUREProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEXProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEXProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINTProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICSProcessing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEWProcessing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODYProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICSORA-39346: data loss in character set conversion for object TABLE_STATISTICS:"INSHOP"."HOLD_PM_INFO"Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTIONProcessing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGERProcessing object type DATABASE_EXPORT/END_PLUGTS_BLKProcessing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKERProcessing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMAProcessing object type DATABASE_EXPORT/AUDITProcessing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKERJob "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.logArchived Log entry 7 added for T-1.S-14 ID 0x823f9c2d LAD:12017-09-19T14:47:10.660184+08:00Thread 1 cannot allocate new log, sequence 16Checkpoint not complete Current log# 3 seq# 15 mem# 0: /u01/app/oracle/oradata/dzditem/redo03.log2017-09-19T14:47:10.878797+08:00Thread 1 advanced to log sequence 16 (LGWR switch) Current log# 1 seq# 16 mem# 0: /u01/app/oracle/oradata/dzditem/redo01.log2017-09-19T14:47:10.885607+08:00Archived Log entry 8 added for T-1.S-15 ID 0x823f9c2d LAD:12017-09-19T14:48:09.743391+08:00Thread 1 advanced to log sequence 17 (LGWR switch) Current log# 2 seq# 17 mem# 0: /u01/app/oracle/oradata/dzditem/redo02.log2017-09-19T14:48:09.754307+08:00Archived Log entry 9 added for T-1.S-16 ID 0x823f9c2d LAD:12017-09-19T14:49:04.419987+08:00ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';2017-09-19T14:49:04.950403+08:00Thread 1 cannot allocate new log, sequence 18Checkpoint not complete Current log# 2 seq# 17 mem# 0: /u01/app/oracle/oradata/dzditem/redo02.log2017-09-19T14:49:07.958332+08:00Thread 1 advanced to log sequence 18 (LGWR switch) Current log# 3 seq# 18 mem# 0: /u01/app/oracle/oradata/dzditem/redo03.log2017-09-19T14:49:07.960797+08:00Archived Log entry 17 added for T-1.S-17 ID 0x823f9c2d LAD:12017-09-19T14:53:13.035332+08:00DM00 started with pid=155, OS id=8536, job SYS.SYS_IMPORT_FULL_012017-09-19T14:53:13.953911+08:00 DW00 started with pid=156, OS id=8540, wid=1, job SYS.SYS_IMPORT_FULL_012017-09-19T14:53:15.409793+08:00Resize operation completed for file# 1, old size 829440K, new size 839680KResize operation completed for file# 1, old size 839680K, new size 849920K2017-09-19T14:53:18.808230+08:00Session (1454,17419): EXTERNAL SCN ALERT: Advanced SCN by 472117 minutes worth to 0x0000006c0f343d73, by Tablespace plug-inSession (1454,17419): EXTERNAL SCN SOURCE: Inbound connection from clientSession (1454,17419): EXTERNAL SCN SOURCE: DB Logon User: SYS, Remote Machine: SRV-300946, Program: oracle@SRV-300946 (DW00), OS User: oracleSession (1454,17419): EXTERNAL SCN SOURCE: Could not find Client IP AddressPlug 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 AUTOALLOCATEORA-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 1048576ORA-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:00Buffer Cache Full DB Caching mode changing from FULL CACHING ENABLED to FULL CACHING DISABLEDFull DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 1207053 MBs bigger than current size.2017-09-19T14:53:52.515690+08:00Resize operation completed for file# 1, old size 849920K, new size 860160KResize operation completed for file# 1, old size 860160K, new size 870400KResize operation completed for file# 1, old size 870400K, new size 880640KResize operation completed for file# 1, old size 880640K, new size 890880K2017-09-19T14:53:53.574141+08:00Resize operation completed for file# 1, old size 890880K, new size 901120KResize operation completed for file# 1, old size 901120K, new size 911360KResize operation completed for file# 1, old size 911360K, new size 921600KResize operation completed for file# 1, old size 921600K, new size 931840KResize operation completed for file# 1, old size 931840K, new size 942080K2017-09-19T14:53:54.614922+08:00Resize operation completed for file# 1, old size 942080K, new size 952320KResize operation completed for file# 1, old size 952320K, new size 962560KResize operation completed for file# 1, old size 962560K, new size 972800KResize operation completed for file# 1, old size 972800K, new size 983040KResize operation completed for file# 1, old size 983040K, new size 993280K2017-09-19T14:53:55.420014+08:00Thread 1 advanced to log sequence 19 (LGWR switch) Current log# 1 seq# 19 mem# 0: /u01/app/oracle/oradata/dzditem/redo01.log2017-09-19T14:53:55.481642+08:00Resize operation completed for file# 1, old size 993280K, new size 1003520KResize operation completed for file# 1, old size 1003520K, new size 1013760K2017-09-19T14:53:55.696477+08:00Resize operation completed for file# 1, old size 1013760K, new size 1024000K2017-09-19T14:53:55.920856+08:00Archived Log entry 20 added for T-1.S-18 ID 0x823f9c2d LAD:12017-09-19T14:53:55.923125+08:00Resize operation completed for file# 1, old size 1024000K, new size 1034240KResize operation completed for file# 1, old size 1034240K, new size 1044480KResize operation completed for file# 1, old size 1044480K, new size 1054720KResize operation completed for file# 1, old size 1054720K, new size 1064960KResize operation completed for file# 1, old size 1064960K, new size 1075200KResize operation completed for file# 1, old size 1075200K, new size 1085440K2017-09-19T14:53:56.784613+08:00Resize operation completed for file# 1, old size 1085440K, new size 1095680KResize operation completed for file# 1, old size 1095680K, new size 1105920K2017-09-19T14:53:57.090792+08:00Resize operation completed for file# 1, old size 1105920K, new size 1116160KResize operation completed for file# 1, old size 1116160K, new size 1126400KResize operation completed for file# 1, old size 1126400K, new size 1136640KResize operation completed for file# 1, old size 1136640K, new size 1146880K2017-09-19T14:53:57.814021+08:00Resize operation completed for file# 1, old size 1146880K, new size 1157120KResize operation completed for file# 1, old size 1157120K, new size 1167360K
备库:
# tail -f /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/alert_dzditem.logRFS[3]: Assigned to RFS process (PID:8087)RFS[3]: No standby redo logfiles createdRFS[3]: Opened log for T-1.S-16 dbid 2185219117 branch 9550348632017-09-19T14:48:09.842613+08:00Archived Log entry 1 added for thread 1 sequence 16 rlc 955034863 ID 0x823f9c2d LAD2 :2017-09-19T14:48:09.968588+08:00Primary database is in MAXIMUM PERFORMANCE modeRFS[4]: Assigned to RFS process (PID:8097)RFS[4]: No standby redo logfiles createdRFS[4]: Opened log for T-1.S-17 dbid 2185219117 branch 9550348632017-09-19T14:48:51.891544+08:00RFS[5]: Assigned to RFS process (PID:8110)RFS[5]: Opened log for T-1.S-11 dbid 2185219117 branch 9550348632017-09-19T14:48:51.891776+08:00RFS[6]: Assigned to RFS process (PID:8112)RFS[6]: Opened log for T-1.S-12 dbid 2185219117 branch 9550348632017-09-19T14:48:51.897462+08:00RFS[7]: Assigned to RFS process (PID:8108)RFS[7]: Opened log for T-1.S-10 dbid 2185219117 branch 9550348632017-09-19T14:48:51.900209+08:00Archived Log entry 2 added for thread 1 sequence 11 rlc 955034863 ID 0x823f9c2d LAD2 :2017-09-19T14:48:51.901147+08:00Archived 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 955034863RFS[6]: Opened log for T-1.S-14 dbid 2185219117 branch 9550348632017-09-19T14:48:51.906066+08:00Archived Log entry 4 added for thread 1 sequence 10 rlc 955034863 ID 0x823f9c2d LAD2 :2017-09-19T14:48:51.907124+08:00Archived Log entry 5 added for thread 1 sequence 13 rlc 955034863 ID 0x823f9c2d LAD2 :2017-09-19T14:48:51.907998+08:00Archived 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 9550348632017-09-19T14:48:51.911853+08:00Archived Log entry 7 added for thread 1 sequence 15 rlc 955034863 ID 0x823f9c2d LAD2 :2017-09-19T14:49:04.299419+08:00alter database open2017-09-19T14:49:04.348524+08:00Ping without log force is disabled: instance mounted in exclusive mode.Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLEDSignalling error 1152 for datafile 1!2017-09-19T14:49:04.351279+08:00Beginning Standby Crash Recovery.2017-09-19T14:49:04.378228+08:00Errors 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 process2017-09-19T14:49:04.402189+08:00Managed Standby Recovery starting Real Time Apply2017-09-19T14:49:04.471704+08:00Errors 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:00Errors 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:00Errors 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:00Parallel Media Recovery started with 24 slaves2017-09-19T14:49:04.899159+08:00Media Recovery Log /data/arch/1_10_955034863.dbf2017-09-19T14:49:04.981403+08:00Incomplete Recovery applied until change 1527157 time 09/19/2017 14:40:082017-09-19T14:49:05.103555+08:00Completed Standby Crash Recovery.Endian type of dictionary set to little2017-09-19T14:49:05.328455+08:00Undo initialization finished serial:0 start:2559791653 end:2559791653 diff:0 ms (0.0 seconds)Dictionary check beginning2017-09-19T14:49:05.343344+08:00Errors 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 fileORA-01110: data file 201: '/u01/app/oracle/oradata/dzditem/temp01.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 72017-09-19T14:49:05.343539+08:00Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_dbw0_7720.trc:ORA-01186: file 201 failed verification testsORA-01157: cannot identify/lock data file 201 - see DBWR trace fileORA-01110: data file 201: '/u01/app/oracle/oradata/dzditem/temp01.dbf'2017-09-19T14:49:05.343621+08:00File 201 not verified due to error ORA-011572017-09-19T14:49:05.344490+08:00Dictionary check complete2017-09-19T14:49:05.344958+08:00Errors 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 fileORA-01110: data file 201: '/u01/app/oracle/oradata/dzditem/temp01.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 72017-09-19T14:49:05.345124+08:00Errors in file /u01/app/oracle/diag/rdbms/dzditem89/dzditem/trace/dzditem_dbw0_7720.trc:ORA-01186: file 201 failed verification testsORA-01157: cannot identify/lock data file 201 - see DBWR trace fileORA-01110: data file 201: '/u01/app/oracle/oradata/dzditem/temp01.dbf'2017-09-19T14:49:05.345209+08:00File 201 not verified due to error ORA-011572017-09-19T14:49:05.351463+08:00Re-creating tempfile /u01/app/oracle/oradata/dzditem/temp01.dbfDatabase Characterset is UTF8No Resource Manager plan activereplication_dependency_tracking turned off (no async multimaster replication found)Physical standby database opened for read only access.Completed: alter database open2017-09-19T14:49:05.997511+08:00Unable 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:00Archived Log entry 8 added for thread 1 sequence 17 rlc 955034863 ID 0x823f9c2d LAD2 :RFS[4]: No standby redo logfiles createdRFS[4]: Opened log for T-1.S-18 dbid 2185219117 branch 9550348632017-09-19T14:49:22.327167+08:00Warning: 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 sessionWARNING: 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:00Attempt to start background Managed Standby Recovery process (dzditem)Starting background process MRP02017-09-19T14:49:22.351420+08:00MRP0 started with pid=146, OS id=86672017-09-19T14:49:22.352574+08:00MRP0: Background Managed Standby Recovery process started (dzditem)2017-09-19T14:49:27.378087+08:00 Started logmerger process2017-09-19T14:49:27.405094+08:00Managed Standby Recovery not using Real Time Apply2017-09-19T14:49:27.773695+08:00Parallel Media Recovery started with 24 slaves2017-09-19T14:49:27.829242+08:00Waiting for all non-current ORLs to be archived2017-09-19T14:49:27.829351+08:00All non-current ORLs have been archived2017-09-19T14:49:27.860130+08:00Media Recovery Log /data/arch/1_10_955034863.dbf2017-09-19T14:49:27.951002+08:00Media Recovery Log /data/arch/1_11_955034863.dbf2017-09-19T14:49:28.034022+08:00Media Recovery Log /data/arch/1_12_955034863.dbf2017-09-19T14:49:28.127009+08:00Media Recovery Log /data/arch/1_13_955034863.dbf2017-09-19T14:49:28.219992+08:00Media Recovery Log /data/arch/1_14_955034863.dbf2017-09-19T14:49:28.300021+08:00Media Recovery Log /data/arch/1_15_955034863.dbf2017-09-19T14:49:28.357869+08:00Completed: alter database recover managed standby database using current logfile disconnect from session2017-09-19T14:49:28.389986+08:00Media Recovery Log /data/arch/1_16_955034863.dbf2017-09-19T14:49:28.500105+08:00Media Recovery Log /data/arch/1_17_955034863.dbfMedia Recovery Waiting for thread 1 sequence 18 (in transit)2017-09-19T14:53:55.626638+08:00Archived Log entry 9 added for thread 1 sequence 18 rlc 955034863 ID 0x823f9c2d LAD2 :RFS[4]: No standby redo logfiles createdRFS[4]: Opened log for T-1.S-19 dbid 2185219117 branch 9550348632017-09-19T14:53:56.044201+08:00Media Recovery Log /data/arch/1_18_955034863.dbfResize operation completed for file# 1, old size 829440K, new size 839680KResize operation completed for file# 1, old size 839680K, new size 849920KResize operation completed for file# 1, old size 849920K, new size 860160KResize operation completed for file# 1, old size 860160K, new size 870400KResize operation completed for file# 1, old size 870400K, new size 880640KResize operation completed for file# 1, old size 880640K, new size 890880KResize operation completed for file# 1, old size 890880K, new size 901120K2017-09-19T14:53:57.006511+08:00Buffer Cache Full DB Caching mode changing from FULL CACHING ENABLED to FULL CACHING DISABLEDFull DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 1206490 MBs bigger than current size.2017-09-19T14:53:57.207741+08:00Resize operation completed for file# 1, old size 901120K, new size 911360KResize operation completed for file# 1, old size 911360K, new size 921600KResize operation completed for file# 1, old size 921600K, new size 931840KResize operation completed for file# 1, old size 931840K, new size 942080KResize operation completed for file# 1, old size 942080K, new size 952320KResize operation completed for file# 1, old size 952320K, new size 962560KResize operation completed for file# 1, old size 962560K, new size 972800KResize operation completed for file# 1, old size 972800K, new size 983040KResize operation completed for file# 1, old size 983040K, new size 993280KMedia Recovery Waiting for thread 1 sequence 19 (in transit)2017-09-19T14:53:58.431707+08:00Archived Log entry 10 added for thread 1 sequence 19 rlc 955034863 ID 0x823f9c2d LAD2 :RFS[4]: No standby redo logfiles createdRFS[4]: Opened log for T-1.S-20 dbid 2185219117 branch 9550348632017-09-19T14:53:59.194899+08:00Media Recovery Log /data/arch/1_19_955034863.dbfResize operation completed for file# 1, old size 993280K, new size 1003520KResize operation completed for file# 1, old size 1003520K, new size 1013760KResize operation completed for file# 1, old size 1013760K, new size 1024000KResize operation completed for file# 1, old size 1024000K, new size 1034240KResize operation completed for file# 1, old size 1034240K, new size 1044480KResize operation completed for file# 1, old size 1044480K, new size 1054720KResize operation completed for file# 1, old size 1054720K, new size 1064960KResize operation completed for file# 1, old size 1064960K, new size 1075200KResize operation completed for file# 1, old size 1075200K, new size 1085440KResize operation completed for file# 1, old size 1085440K, new size 1095680KResize 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.
- 传输数据库升级11.2.0.3 DG集群到12.2
- DG 检查日志文件是否传输到备用数据库
- 传输数据库升级Oracle11.2.0.3到Oracle12.2
- oracle数据库升级11.2.0.3升级到11.2.0.4
- Oracle DG之--通过Oracle 逻辑DG 实现数据库滚动升级
- dg日志传输服务
- 探索Oracle之数据库升级二 11.2.0.3升级到11.2.0.4完整步骤
- 探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤
- oracle数据库升级记(记一次10.2.0.3版本升级到11.2.0.1版本的过程)
- dg(dg相关数据库参数)
- 探索Oracle之数据库升级二 11.2.0.3升级到11.2.0.4完整步骤--测试成功版本
- oracle数据库升级记(从10.2.0.3版本升级到11.2.0.1版本)[使用database update assistant工具]
- SQL2005到2008数据库升级
- slq2000数据库升级到sql2012
- 11.2.0.1 单实例数据库升级到 11.2.0.3.18 的步骤
- oracle数据库升级 11.2.0 到11.2.4
- MySQL数据库5.0升级到5.1,再升级到5.5
- DG检测归档是否传输到备库
- HDU
- android-java Error:(29, 37) 错误: 程序包org.apache.http.client.entity不存在
- 临时撤销段(TEMPORARY UNDO)
- JVM介绍
- 质因数的个数
- 传输数据库升级11.2.0.3 DG集群到12.2
- 647. Palindromic Substrings
- Java--变量
- HashMap的工作原理【面试】
- FTPrep, 73 Set Matrix Zeroes
- thinking in java——复用类
- 【算法设计作业】week3
- GIT学习笔记
- LeetCode 136. Single Number (Easy)