Monday, March 14, 2011

Multiplexing of Redo logs

SELECT group#, members, status, bytes FROM v$log;
SELECT group#, member, type FROM v$logfile;

ALTER DATABASE ADD LOGFILE MEMBER 'C:\REDO1011\REDO1.LOG' TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER 'C:\REDO1011\REDO2.LOG' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER 'C:\REDO1011\REDO3.LOG' TO GROUP 3;


SELECT group#, members, status, bytes FROM v$log;
SELECT group#, member, type FROM v$logfile;

No comments:

Post a Comment

Followers