Q
Problem solve Get help with specific problems with your technologies, process and projects.

Mirroring redo log files

In my database I have three redo log groups 1,2,3, and each log group contains one member like d:oracleoradatatestredo01.log,...

d:oracleoradatatestredo02.log, d:oracleoradatatestredo03.log, respectively. I want to multiplex or mirror these log files to the c: drive. How to do this? My operating system is Windows NT.

The OS does not make a difference in this case except for specifying directory names. In Oracle-speak, mirroring this log files (which is an extremely good idea to do!) is done by adding *members* to the redo log *groups*. This can be done with the following command:

ALTER DATABASE ADD LOGFILE MEMBER 'directory/filename'
TO GROUP x;

For More Information


You'll want to make appropriate substitutions for the lower case parameters above.

Dig Deeper on Oracle database design and architecture

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close