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