How to alter Database add Logfile correctly

 

Add a New Logfile Member

SQL> alter database add logfile '+DATA' to group 1;
alter database add logfile '+DATA/tansid_p2/redo01a.log' to group 1
                                                       *
ERROR at line 1:
ORA-00933: SQL command not properly ended

Error happened because missed MEMBER keyword.

SQL> alter database add logfile member '+DATA/TANSID_P2/redo01a.log','+DATA/TANSID_P2/redo01b.log' to group 1;

Database altered.

Multiple logfiles are allowable to be added in one statement as long as you use comma to delimit them.

Create a New Logfile Group

Need to specify THREAD then GROUP, logfile member follows.

SQL> alter database add logfile thread 1 group 5 ('+DATA/TANSID_P2/redo05a.log','+DATA/TANSID_p2/redo05b.log') size 10m;

Database altered.

SQL> alter database add logfile thread 2 group 6 ('+DATA/TANSID_p2/redo06a.log','+DATA/TANSID_p2/redo06b.log') size 10m;

Database altered.

Create a Standby Redo Log

alter database add standby logfile thread 1 group 13 '+DATA' size 200m;

alter database add standby logfile thread 1 group 14 '+DATA' size 200M;

alter database add standby logfile thread 2 group 15 '+DATA' size 200M;

alter database add standby logfile thread 2 group 16 '+DATA' size 200M ;

alter database add standby logfile thread 1 group 17 '+DATA' size 200M ;

alter database add standby logfile thread 2 group 18 '+DATA' size 200M ;

alter database add standby logfile thread 1 group 19 '+DATA' size 200M ;

alter database add standby logfile thread 2 group 20 '+DATA' size 200M ;