alter database drop logfile member - Controlfile - Data BasyX

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 ...

Renaming Logfiles | GEOGEEKS.NET

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.

alter database drop logfile member - Bookshelf


Pro Oracle Database 11g Administration
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 ...

OCA, Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052)
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 ...

Oracle9i new features
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. ...

Portable DBA, Oracle
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, ...

Expert Oracle database 10g administration
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 ...