Oracle DBA Lite: an introduction to Oracle administration, part 2
tells which redo log group is currently active. To add a new redo log file to a group, I just have to issue the command Alter database add ' ...
alter database add logfile member - Management - Data BasyX
Migrate a normal file-system Oracle database to ASM database
Michael Georgiou currently works at the National Bank of Greece (Cyprus Branch) as an Oracle Database and Oracle Application Server Administrator. He earned an M. Sc. degree in Computer Science from the University of Cyprus (2011) and Bsc degree in Computer Science from Cyprus College (2004).
alter database add logfile member - Bookshelf
|
729 pages |
Backup & recovery To do this, we issue the following commands: SQL> alter database add logfile member '/logs2/redolog01.log' to group 1; Selection processed SQL> alter ... |
|
707 pages |
Unix backup and recovery ... Selection processed SVRMGR > alter database add logfile member Vlogs3redolog01.log1 to group 1; Selection processed SVRMGR > alter database add logfile ... |
|
629 pages |
Oca, Oracle 10g Workshop I Study Guide If you know the group number, use the following statement to add a member to group 2: ALTER DATABASE ADD LOGFILE MEMBER '/ora04/oradata/MYDB01/redo0203.log' ... |
|
254 pages |
Oracle9i new features Adding a Redo Log Group When we created our database, ... log group member that is an OMF (that is, alter database add logfile member to group 2). ... |
|
888 pages |
OCP: Oracle Database 11g Administrator Certified Professional Study Guide, (Exam 1Z0-053) You can simply re-create the member using the alter database add logfile member command. For example, you might see this error in the alert log: ORA-00313: ... |