Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: where to alter the path of redologs

RE: where to alter the path of redologs

From: Philip West <P.West_at_g-icap.com>
Date: Mon, 10 Jul 2000 16:15:27 +0100
Message-Id: <10554.111550@fatcity.com>


Deepak,

You need some advice !

[with database up]

Create new log groups as required.
Switch logs so that new groups are used Drop old logs
Backup controlfile so that you have record of changes Backup database at earliest opportunity

[with database down]

copy the files at o/s level (I always copy first as a precaution) startup mount
alter database rename file 'old/file/path/and/name' to 'new/file/path/and/name'
open database
delete the old versions of the files (now that you are happy) shut down the database and take a full backup

Regards

Phil West - Impex IT ltd
Unix Sys Admin and Oracle Financials DBA Services

[ all opinions - unless otherwise stated - may be ill-informed and will be defended as such! ]

-----Original Message-----
From: Deepak Sharma [mailto:sharmakdeep_at_yahoo.com] Sent: 08 July 2000 17:15
To: Multiple recipients of list ORACLE-L Subject: Re: where to alter the path of redologs

For Q No. 1, this is the quickest method I have used in the past (works only if you can afford shutting down the database)

o Create controlfile trace
o Edit the trace file and change the RedoLog Path. Save it as an SQL script
o Shutdown database
o Use svrmgrl, connect internal and run the script


Oracle DBA,
Minneapolis, MN
USA

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/
-- 
Author: Deepak Sharma
  INET: sharmakdeep_at_yahoo.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
also send the HELP command for other information (like subscribing).


*******************************************************************************
The information in this Internet e-mail is confidential and may be legally privileged.  It is intended solely for the addressee.  Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 
 When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.
Received on Mon Jul 10 2000 - 10:15:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US