Standby ERROR

SQL> startup mount;
ORACLE instance started.

Total System Global Area  276824064 bytes
Fixed Size                  2020160 bytes
Variable Size              96472256 bytes
Database Buffers          176160768 bytes
Redo Buffers                2170880 bytes
Database mounted.
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 stand


SQL>

错误原因，在standby库没有standby logfile，在maxmize pretection，maxmize availability中必须要有standby logfile，为了避免数据的损失最少，maxmize performance 也最好创建standby logfile，考虑角色切换
primary库也要创建standby logfile，

standby logfile创建的要求， 与primary的redo logfile的大小相同，个数要至少多一个


SQL> alter database add standby logfile group 4 '/opt/oracle/oradata/TVMDB/standby01.log' size 50m;

Database altered.

SQL> alter database add standby logfile group 5 '/opt/oracle/oradata/TVMDB/standby02.log' size 50m;

Database altered.

SQL> alter database add standby logfile group 6 '/opt/oracle/oradata/TVMDB/standby03.log' size 50m;

Database altered.

SQL>


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

Database altered.

SQL>