## 7.3.4 to 8.1.6 Migration issue

From: Warkentien, Stephen <warkents_at_littongcs.com>
Date: Tue, 18 Sep 2001 15:06:52 -0700
Message-ID: <F001.003919B6.20010918081017@fatcity.com>

I am migrating from 7.3.4 to 8.1.6 (Enterprise Edition) on Solaris 2.8

Before running the migration I took all the tablespaces except SYSTEM and Rollback offline as recommended.
When I issued "Alter database open resetlogs;" I got the following message for almost every file in the database:

File #3 is offline, but part of an online tablespace. Successfully brought file #3 online.

Can anyone explain this error please? Oracle support is saying that all the files should have been offline, and if not the migration must be restarted.

TIA!! Stephen Warkentien
Senior Database Administrator, Information Technology Northrop Grumman Guidance and Control Systems Division 5500 Canoga Avenue M/S W91
Woodland Hills CA 91367-6698

818-715-2860 voice
818-715-2617 FAX
mailto:warkents_at_littongcs.com
http://sonworshipper.net/techpage.htm

--

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

Author: Warkentien, Stephen
  INET: warkents_at_littongcs.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). Received on Tue Sep 18 2001 - 17:06:52 CDT