Solved

add standby log file

Posted on 2012-03-10
1
1,044 Views
Last Modified: 2012-03-10
Add standby log file

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

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------
         3
/u01/app/oracle/oradata/orcl11/redo03.log

         2
/u01/app/oracle/oradata/orcl11/redo02.log

         1
/u01/app/oracle/oradata/orcl11/redo01.log



SQL> ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/orcl11/redo01.log') SIZE 52428800;


ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/orcl11/redo01.log') SIZE 52428800
*
ERROR at line 1:
ORA-01577: cannot add log file '/u01/app/oracle/oradata/orcl11/redo01.log' -
file already part of database
0
Comment
Question by:b7dba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 23

Accepted Solution

by:
David earned 500 total points
ID: 37705934
01 is already in use:  
ALTER DATABASE ADD STANDBY LOGFILE ('/u01/app/oracle/oradata/orcl11/redo04.log') SIZE 52428800;

Although I'd prefer to see my logs spread to additional drives, and to have at least two members per group to avoid failure points.  HTH
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question