Oracle DBA Lite: an introduction to Oracle administration, part 2
for regular access. A simple alter database command does the trick, which I can follow with “alter database open” to make the database accessible ...
for regular access. A simple alter database command does the trick, which I can follow with “alter database open” to make the database accessible ...
If you want to move logfile to another destination or you just want to give it the meaningful name you should do the logfile renaming. Renaming logfiles in Oracle database requires several steps to be performed.
|
679 pages |
Pro Oracle Database 11g Administration Dropping an online redo-log group doesn't remove the log files from the OS. You have to use an OS command to ... Use the ALTER DATABASE ADD LOGFILE MEMBER ... |
|
1152 pages |
OCA, Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) To drop a redo log member, use the DROP LOGFILE MEMBER clause of the ALTER DATABASE command: ALTER DATABASE DROP LOGFILE MEMBER ... |
|
254 pages |
Oracle9i new features You can drop an OMF redo log member, however, with the alter database drop logfile member. In this event, Oracle will remove the dropped redo log member. ... |
|
598 pages |
Portable DBA, Oracle Dropping a Logfile Group Member To drop a member from an existing logfile group (but not drop the entire logfile group), use the alter database command, ... |
|
1276 pages |
Expert Oracle database 10g administration ... command: SQL> ALTER DATABASE DROP LOGFILE GROUP 3; To drop a single member of an ... the log file first, after which you can drop it: SQL> ALTER SYSTEM ... |