DBA 大小事處理記錄

在進行資料庫還原後，要將資訊庫轉為 standby 模式時，出現 ORA-38500

SQL> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
ERROR at line 1:
ORA-38500: USING CURRENT LOGFILE option not available without standby redo logs

原因是新建立的 standby db server 並未加入 standby log 關係導致此錯誤

建立 standby logfile 即可

SQL> alter database add standby logfile group 4 '/oracle/oradata/johnson/redo4.log' size 50m;

SQL> alter database add standby logfile group 5 '/oracle/oradata/johnson/redo5.log' size 50m;

SQL> alter database add standby logfile group 6 '/oracle/oradata/johnson/redo6.log' size 50m;

加入後的 logfile 狀態

SQL> select group#, type from v$logfile;

    GROUP# TYPE
---------- -------
     3 ONLINE
     2 ONLINE
     1 ONLINE
     4 STANDBY
     5 STANDBY
     6 STANDBY

6 rows selected.

重新執行一次，即可通過

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.