Saturday, May 3, 2008

Adding redo log groups

Always forget the syntax for redo log groups?

Note: Using ASM for database files

SQL> alter database add logfile;

SQL> alter database drop logfile group 1;

SQL> alter database add logfile member '+RECOVERY' to group 4;

***********************************
key words: add logfile
***********************************

No comments: