Solved

add standby log file

Posted on 2012-03-10
1
1,018 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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
data lookup in Oracle - need suggestions 55 121
Create file system directory from Oracle 10g 4 25
Fill Null values 5 28
oracle numeric condition check 4 27
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 …
Note: for this to work properly you need to use a Cross-Over network cable. 1. Connect both servers S1 and S2 on the second network slots respectively. Note that you can use the 1st slots but usually these would be occupied by the Service Provide…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

830 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