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 ;


Comments

Popular posts from this blog

How to fix Oracle SQL Developer connection issue "Got minus one from a read call"

Few Important steps of Oracle Database Clone

How to autopopulate user_guid in fnd_user table ( EBS Blank Page)