RE: Cloning Database failed

Unfortunately I'm not using RMAN. If I can find the space somewhere I'll test recreating the control file route and create it with just a few tablespaces.

-----Original Message-----
Sent: Friday, September 07, 2001 2:07 PM To: Multiple recipients of list ORACLE-L

If you are using rman try doing a switch on the datafile which you moved. If you need more info write me directly.

Ruth B. Gramolini
ORACLE & DB2 DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
rgramolini_at_tax.state.vt.us
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 07, 2001 11:32 AM

> I went to replace my QC database from production yesterday (we do this
about
> once a month) and discovered that there wasn't enough room in one of the
> filesystems to copy all the hot backup files. No problem I thought, I
just
> copied one of the larger files to a different filesystem, mounted the
> database, and renamed to file to point to the new location. I then did my
> recovery, but when I tried to do ALTER DATABASE OPEN RESETLOGS I got
> ORA-01113: file 1 needs media recovery
>
> ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf'
>
> I tried applying more archive logs, eventually applying over 10 hours
worth.
> Still got the error. I redid it this morning in case I had copied the
wrong
> file somewhere, but once again...
>
> I'm now assuming that the problem was caused by my having renamed the
file.
> Can anyone confirm or deny this and give me a suggestion on how to resolve
> the issue? I'm considering rebuilding the control file without an index
> tablespace to free up space but now I'm afraid that I'll get the same
error.
>
> It's not a high priority since my SA just called to let me know he was
able
> to find a few extra Meg for the filesystem (I was only short a frustrating
> 300K), but I'd still like to know what the problem was and any suggestions
> (in case it happens again in the future).
>
> Oracle 8.0.4.3, Solaris 2.5.1
>
>
>
> TIA,
> Jay Miller
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.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).