Re: Moving redo log files on a live system On 29 Jan 2006 11:55:29 -0800, "nmizekan@gmail.com"
<nmizekan@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 |