Re: How to move activie redo log ?

From: Igor Ushkalo <igorus_at_protek.ru>
Date: Wed, 27 Feb 2002 17:22:14 +0300
Message-ID: <a5iq1r$opj$1@news.sovam.com>

Hello, kw!
You wrote on Wed, 27 Feb 2002 14:22:01 +0100:

 k> Hi all

 k> I moved database between 2 Win2000 boxes as ordinary files after
 k> clean shutdown.
 k> Everything goes ok, but on 1'st box my redo was on drive h: and on
 k> 2'nd there was no such drive!
 k> Moving data files and not active redo log works ok, but if i try to
 k> move that active it give me error (couldn't find redo log at original
 k> location - h:)

startupo mount
alter database rename file 'h:\........' to 'g:\........'; alter database open;

 k> I couldn’t even switch logfile to new one on proper location or do  k> anything else!!!
You don't need to switch logfile, just rename it.

 k> Fortunately there was some space on box2 and after creating drive h:
 k> and moving redo database works normal, but I wonder what to do if I
 k> couldn’t create drive h: on box2 nor move redo on box1 ?

 k> ENV:
 k> Win2000, OEE 8.1.7 in Archivelog

 k> Thanks in advance

• Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru, ICQ #19972198

Received on Wed Feb 27 2002 - 08:22:14 CST