Re: Moving redo log files on a live system

On 29 Jan 2006 11:55:29 -0800, "nmizekan_at_gmail.com" <nmizekan_at_gmail.com> wrote:

>Hello All,
>
>I am in a situation where I have to move redo logs on a live system
>hosted on hp-ux. Is there a way to do this. Any advice will be greatly
>appreciated.
>
>Thanks

alter database drop logfile group <n>

alter database add logfile group <n> ('<filename>','<filename>') size ...

You must make sure the logfile is not in use which you can verify by querying v$log.
If it is in use
alter system switch logfile

--
Sybrand Bakker, Senior Oracle DBA