RE: Regarding Redo log

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Thu, 9 Nov 2000 17:12:20 +1100
Message-Id: <10674.121538@fatcity.com>

Hi Saroj

I thought you were working on the create table problem or are we just multitasking today.

alter database rename file 'D:/xhy/a.dbf ' to 'D:\xys/a.log' In this statement there is a problem with the slashes "\". in NT you use the "\" (BackSlash)
By running the above statement all you doing is updating the dictionary. So I think you may have updated the dictionary incorrectly with the wrong "\" (BackSlash)

So try to startup the database again in mount state. alter database rename file 'D:\xhy\a.dbf' to 'D:\xys\a.log';

then try to open the database by issuing alter datbase open;

HTH Suhen

-----Original Message-----
From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash_at_gecapital.com] Sent: Thursday, 9 November 2000 16:00
To: Multiple recipients of list ORACLE-L Subject: Regarding Redo log

Hello,

I need to rename the redo log files,

1.First i copy the  current redo log file to new redo log file in OS level .
2. after that i open the database in mount mode.
3. rename the redo log file like

alter database rename file 'D:/xhy/a.dbf ' to 'D:\xys/a.log' 4. Alter databsee open
then i want to see the v$logilfe,I found the status of thse file are INVALID. Then i force to do
alter system switch logfile 3 times.Now the status are showing Null.

Now please tell me what is the menaing of INVALID status. Is there any problem if it shows invalid.

Now please suggest me the orginal redo log file is still on OS level. can I delete that file from OS level.

Waiting for reply asap.

I know the status are stale,Incomplete and NULL,what is the meaning of INVALID.
Saroj.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Dash, Saroj (CAP,CEF)
  INET: Saroj.Dash_at_gecapital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Thu Nov 09 2000 - 00:12:20 CST