创建数据库创建逻辑备用数据库.pdf

文档介绍：: .
创建数据库:创建逻辑备用数据库
疯狂代码 ht
CREATE DATABASE LINK

CREATE PFILE FROM SPFILE

CREATE SCHEMA AUTHORIZATION

CREATE SNAPSHOTCREATE SNAPSHOT LOG

CREATE SPFILE FROM PFILE

CREATE TABLE AS SELECT FROM A CLUSTER TABLE

DROP DATABASE LINK

DROP SNAPSHOT

DROP SNAPSHOT LOG

EXPLAIN

LOCK TABLE



RENAME

SET CONSTRAINTS

SET ROLE

SET TRANSACTION





确保主数据库中表行是可以唯确认(即有表中有主键)

找出没有主键表:

SQL> SELECT OWNER, TABLE_NAME, BAD_COLUMN FROM DBA_LOGSTDBY_NOT_UNIQUE2> WHERE TABLE_NAME NOT IN (SELECT TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED);

OWNER TABLE_NAME B

------------------------------ ------------------------------ -

OUTLN OL$HINTS N

OUTLN OL$NODES N

SYSTEM MVIEW$_ADV_BASETABLE N

SYSTEM MVIEW$_ADV_SQLDEPEND N

SYSTEM MVIEW$_ADV_FILTERINSTANCE N

SYSTEM DEF$_ORIGIN N

SYSTEM REPCAT$_SNAPGROUP

N

SYSTEM REPCAT$_DDL N

SYSTEM REPCAT$_RESOLUTION_STATISTICS N

SYSTEM REPCAT$_RUNTIME_PARMS Y

SYSTEM MVIEW$_ADV_INDEX N


RELY CONSTRAINT以使有关这个表LOG可以APPLY
到逻辑备用库中.

选择出来只有SYSTEM用户下表REPCAT$_RUNTIME_PARMS需要做修改,然后SQL>DESC SYSTEM. REPCAT$:

SQL> ALTER TABLE SYSTEM. REPCAT$_RUNTIME_PARMS ADD PRIMARY KEY
(RUNTIME_PARM_ID,PARAMETER_NAME) RELY DISABLE;

修改完以后再做上面查询以确认没有表需要再做修改:

SQL> SELECT OWNER, TABLE_NAME, BAD_COLUMN FROM DBA_LOGSTDBY_NOT_UNIQUE



2> WHERE TABLE_NAME NOT IN (SELECT TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED);



OWNER TABLE_NAME B

------------------------------ ------------------------------ -

OUTLN OL$HINTS N

OUTLN OL$NODES N

SYSTEM MVIEW$_ADV_BASETABLE N

SYSTEM MVIEW$_ADV_SQLDEPEND N

SYSTEM MVIEW$_ADV_FILTERINSTANCE N

SYSTEM