- 最后登录
- 2015-4-22
- 在线时间
- 122 小时
- 威望
- 133
- 金钱
- 1304
- 注册时间
- 2012-2-22
- 阅读权限
- 50
- 帖子
- 144
- 精华
- 1
- 积分
- 133
- UID
- 254
|
1#
发表于 2012-5-11 10:22:18
|
查看: 7357 |
回复: 4
DataGuard Logic Standby升级,10.2.0.5->11.2.0.2.0
执行完catupgrd.SQL 所有组件都是有效的
SQL> @ utlu112s.SQL
SQL> @ catuppst.SQL
SQL> @utlrp.SQL- sys@SAUPDG> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;
- COMP_NAME STATUS VERSION
- ---------------------------------------- ---------------------- --------------------
- JServer JAVA Virtual Machine VALID 11.2.0.2.0
- OLAP Analytic Workspace VALID 11.2.0.2.0
- OLAP Catalog INVALID 11.2.0.2.0
- Oracle Data Mining VALID 11.2.0.2.0
- Oracle Database Catalog Views VALID 11.2.0.2.0
- Oracle Database Java Packages VALID 11.2.0.2.0
- Oracle Database Packages and Types VALID 11.2.0.2.0
- Oracle Enterprise Manager VALID 11.2.0.2.0
- Oracle Expression Filter VALID 11.2.0.2.0
- Oracle Multimedia VALID 11.2.0.2.0
- Oracle OLAP API VALID 11.2.0.2.0
- Oracle Rule Manager VALID 11.2.0.2.0
- Oracle Text VALID 11.2.0.2.0
- Oracle Workspace Manager VALID 11.2.0.2.0
- Oracle XDK VALID 11.2.0.2.0
- Oracle XML Database VALID 11.2.0.2.0
- Spatial VALID 11.2.0.2.0
- 17 rows selected.
复制代码 附除catupgrd.SQL 以外的输出文件
简单在Primary插入数据,在Logic Standby可以接收。
补充:
- saup@SAUPDG> select * from dba_objects where status='INVALID';
- OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID
- ------------ ---------------------------------------- ------------------------------ ---------- --------------
- OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS T G S NAMESPACE
- ---------------------------------------- ------------------- ------------------- ------------------- ------- - - - ----------
- EDITION_NAME
- ------------------------------
- SH FWEEK_PSCAT_SALES_MV 52473
- MATERIALIZED VIEW 2012-04-28 13:48:00 2012-04-28 13:48:00 2012-04-28:13:48:00 INVALID N N N 19
- 1 row selected.
复制代码
[ 本帖最后由 saup007 于 2012-5-11 10:38 编辑 ] |
|