SEO

#1 (**permalink**) 02-25-2008, 01:56 AM

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

#2 (**permalink**) 02-25-2008, 01:56 AM

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

#3 (**permalink**) 02-25-2008, 01:56 AM

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
>

Step by step demo in Morgan's Library at www.psoug.org
click on Log Files
Drop them at one location ... create new ones at the other.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

#4 (**permalink**) 02-25-2008, 01:56 AM

Sybrand Bakker wrote:
>
> 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

and to make life easier for yourself, create the
new ones before you drop the old ones.
Then all you need is to switch logfile when you hit
the old one that is still being used.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Moving redo log files on a live system