RE: where to alter the path of redologs

From: Deepak Sharma <sharmakdeep_at_yahoo.com>
Date: Mon, 10 Jul 2000 10:56:18 -0700 (PDT)
Message-Id: <10554.111584@fatcity.com>

Your's is a different solution than mine. That's all !!

• Philip West <P.West_at_g-icap.com> wrote:
  > 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-----
  > Sent: 08 July 2000 17:15
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > 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
  >
  > -- Deepak
  >
  > --- aheda_at_cdotd.ernet.in wrote:
  > >
  > > I am facin certain problems while tuning the
  > > performance of oracle .It
  > > would be of great help if somebody can give
  > > suggestions over:
  > > 1).how can we change the redolog files path on a
  > > running system.
  > > 2). If we are havinfg two datafiles under one
  > > tablespace how can we move
  > > one move certain tables to one file completely
  > >
  > >
  > >
  > > Arvind
  > >
  > >
  > >
  > > --
  > > Author:
  > > INET: aheda_at_cdotd.ernet.in
  > >
  > > 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).
  >
  >
  > =====
  > 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.
  >

  ---

  
  > --
  > Author: Philip West
  > INET: P.West_at_g-icap.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).
  

  ---

Oracle DBA, Received on Mon Jul 10 2000 - 12:56:18 CDT