ORA-38500: USING CURRENT LOGFILE option not available without standby redo logs


bash-3.2$ sqll
SQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 28 01:04:13 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> 
SQL> 
SQL> 
SQL> 
SQL> 
SQL> STARTUP NOMOUNT
ORACLE instance started.
Total System Global Area 2.0583E+10 bytes
Fixed Size 2190488 bytes
Variable Size 3087012712 bytes
Database Buffers 1.7448E+10 bytes
Redo Buffers 45883392 bytes
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
Database altered.
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
SQL> 
SQL> 
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
Solution:
SQL> alter database add standby logfile group 11 '+NEWDATA' size 500M;
Database altered.
SQL> alter database add standby logfile group 12 '+NEWDATA' size 500M;
Database altered.
SQL> alter database add standby logfile group 13 '+NEWDATA' size 500M;
Database altered.
SQL> alter database add standby logfile group 14 '+NEWDATA' size 500M;
Database altered.
SQL> alter database add standby logfile group 15 '+NEWDATA' size 500M;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: