單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(9)

cow977發表於2011-07-13
LinuxOracle 10g

單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(1)：http://space.itpub.net/81227/viewspace-701181

單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(2)：http://space.itpub.net/81227/viewspace-701198

單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(3)：http://space.itpub.net/81227/viewspace-701231

單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(4)：http://space.itpub.net/81227/viewspace-701293

單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(5)：http://space.itpub.net/81227/viewspace-702254

單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(6)：http://space.itpub.net/81227/viewspace-702263

單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(7)：http://space.itpub.net/81227/viewspace-702264

單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(8)：http://space.itpub.net/81227/viewspace-702270

 

安裝過程中遇到的問題：ORA-38500: USING CURRENT LOGFILE option not available without stand

 

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT

*

ERROR at line 1:

ORA-38500: USING CURRENT LOGFILE option not available without stand

standby庫沒有standby logfile，建立standby logfile，大小與primary的redo logfile的相同。

 

alter database add standby logfile group 11 '/home/oracle/software/app/oracle/oradata/orcl/redo11.log' size 50M;

alter database add standby logfile group 12 '/home/oracle/software/app/oracle/oradata/orcl/redo12.log' size 50M;

alter database add standby logfile group 13 '/home/oracle/software/app/oracle/oradata/orcl/redo13.log' size 50M;

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/81227/viewspace-702272/，如需轉載，請註明出處，否則將追究法律責任。

相關文章