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
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.
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.
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
Post a Comment