Oracle-L: Re: Database recovery question

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 03 Jun 2003 07:35:19 -0800
Message-ID: <F001.005A8E81.20030603073519@fatcity.com>

Restore the controlfile backup and all your datafiles to F:
Configure the init<SID>.ora to set the control_files parameter to the controlfile at F:
STARTUP MOUNT
Run the ALTER DATABASE RENAME FILE <oldfilein E:> TO <newfile in F:> for each datafile (including the SYSTEM Tablespace datafile)
RECOVER DATABASE, applying all the ArchiveLogs you have
ALTER DATABASE OPEN RESETLOGS

If you have a very large number of files to be renamed at Step 3, you could generate
the script from your source database, if you want to avoid having to manually write
the command for each file
Hemant

At 07:04 AM 03-06-03 -0800, you wrote:

>I have a hot backup of an Oracle database (all files located on E:), I now
>want to restore the hot backup location as F:.
>
>Now if this was a cold backup I could recreate the control files :-) But
>since it is a hot backup I need to do a recover database using backup
>controlfile.
>
>My question is how can I recover the database as I do not think this is
>going to work. Database size 17GB, SYSTEM/TEMP/ROLLBACK is about 500MB
>and I have only 1GB of space on the E: ?
>
>Any ideas please :-)
>
>
>Tim Clarkson
>Category Business Management System (Technical Support)
>Shell International Limited
>Shell Centre, London SE1 7NA, United Kingdom
>
>Tel: +44 (0)20 7934 4529
>Email: Timothy.Clarkson_at_shell.com
>Internet: <http://www.shell.com>http://www.shell.com

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Tue Jun 03 2003 - 10:35:19 CDT