View Single Post

   
  #2 (permalink)  
Old 02-25-2008, 01:56 AM
Sybrand Bakker
 
Posts: n/a
Default 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
Reply With Quote