-
编辑 删除
Oracle Logical Standby 维护常用命令
// 执行跳过，跳过的结果在 execute dbms_logstdby.skip(stmt => 'DML',schema_name => '%', object_name => '%'); stmt的取值可以是： http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_lsbydb.htm#997290 // 跳过的内容记载在下面 select * from dba_logstdby_skip // 停止apply [@more@]alter database stop logical standby apply; alter database abort logical standby apply; // 执行apply alter database start logical standby apply; // 实时apply alter database start logical standby apply
-
编辑 删除
tempfile文件过大问题处理 for logical standby
SQL> select tablespace_name from dba_tablespaces;TABLESPACE_NAME------------------------------SYSTEMUNDOTBS1SYSAUXTEMPSMPERP_MVSMPERP_MV_IDXUSERSSQL> select name from v$tempfile;NAME--------------------------------------------------------------------------------/ora103/oradata/STCSAPP/temp01.dbf/ora103/oradata/STCSAPP/temp02.dbf/ora103/oradata/STCSAPP/temp03.dbf/ora103/oradata/STCSAPP/temp04.dbf/ora103/oradata/STCSAPP/temp05.dbf/ora103/oradata/STCSAPP/temp06.dbfSQL> create temporary tab
-
编辑 删除
Create Logical Standby For Oracle 10G
一、create physical standby1.Enable force logging on PrimarySQL>alter database force logging;SQL> select FORCE_LOGGING from v$database;FOR---YES2.Enable archivelogSQL>shutdown immediate;SQL>startup mount;SQL>alter database archivelog;SQL>archive log list;[@more@]3.Check redo log status on primarySQL> select GROUP# ,STATUS ,TYPE ,MEMBER from v$logfile;4.Create Standby Redo LogSQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 '/ora101/oradata/STCSMES/redostb01.log' size 300m;
