asked on
add standby log file
Add standby log file
SQL> select group#,member from v$logfile;
GROUP#
----------
MEMBER
--------------------------
3
/u01/app/oracle/oradata/or
2
/u01/app/oracle/oradata/or
1
/u01/app/oracle/oradata/or
SQL> ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/
ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/
*
ERROR at line 1:
ORA-01577: cannot add log file '/u01/app/oracle/oradata/o
file already part of database
SQL> select group#,member from v$logfile;
GROUP#
----------
MEMBER
--------------------------
3
/u01/app/oracle/oradata/or
2
/u01/app/oracle/oradata/or
1
/u01/app/oracle/oradata/or
SQL> ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/
ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/
*
ERROR at line 1:
ORA-01577: cannot add log file '/u01/app/oracle/oradata/o
file already part of database
Linux NetworkingOracle Database
Last Comment
David VanZandt
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.