ITPub博客

oracle 11g standby (one instance)primary xx.xx.xx.100   (node2)standby xx.xx.xx.35    (oracle)1.standby server add listener and tnsnames[oracle@oracle6 admin]$ more listener.ora SID_LIST_LISTENER2 =  (SID_LIST =    (SID_DESC =   &...

data guard的结构常识(转载)http://www.gomudemi.org/?p=176

在执行logical standby switchover的时候，出现了ORA-16217: prepare to switchover has not completed错误.[@more@]SQL> alter database prepare to switchover to logical standby;Database altered.SQL> select switchover_status from v$database;SWITCHOVER_STATUS--------------------PREPARING SWITCHOVERSQL> alter database commit to switchover to logical standby;alter database commit to switchover to logical standby*ERROR at line 1:ORA-16217: prepare to switchover has not completedOR

今天做dataguard的时候出现了如下错误：[@more@]primary database使用的是asm，standby database 使用的系统文件ERROR: slave communication error with ASM; terminating process 3364Errors in file /u01/oracle/diag/rdbms/asmdg/asm/trace/asm_lgwr_3364.trc:Sat Mar 09 15:57:31 2013PMON (ospid: 3344): terminating the instance due to error 470Sat Mar 09 15:57:32 2013ORA-1092 : opitsk aborting processInstance terminated by PMON, pid = 3344原来以前创建dataguard的时候，在primary database中已经建立了standby_logfile

配置dataguard出现ORA-19527 physical standby redo log must be renamed错误的时候，需要在 pfile中加入 log_file_name_convert='/u01/oradata/node','/u01/oradata/node'即可解决ora-19527错误oracle@node_standby...

今天duplicate database for standby的时候，出现了RMAN-05001错误:RMAN> duplicate target database for standby;Starting Duplicate Db at 18-OCT-12using channel ORA_AUX_DISK_1contents of Memory Script.:{&nb...