RE: alter tablespace offline

Hi Sinardy,

 

Instance was terminated when opening

 

Errors in file /opt/oracle/product/admin/DECA/udump/deca_ora_28080.trc:

ORA-00376: file 6 cannot be read at this time

ORA-01110: data file 6: '/migratie_deca/DECA/DATA/tools01.dbf'

Error 376 happened during db open, shutting down database

USER: terminating instance due to error 376

Instance terminated by USER, pid = 28080

ORA-1092 signalled during: ALTER DATABASE OPEN...

 

Regards,

 

Jeroen

-----Oorspronkelijk bericht-----
Van: Sinardy Xing [mailto:SinardyXing@bkgcomsvc.com]
Verzonden: Tuesday, December 16, 2003 11:44
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: alter tablespace offline

 

-----Original Message-----
From: Jeroen van Sluisdam [mailto:jeroen.van.sluisdam@vrijuit.nl]
Sent: 16 December 2003 18:12
To: Multiple recipients of list ORACLE-L
Subject: alter tablespace offline

 

Hi,

 

This weekend I was migrating an oracle 7.3.4 environment to oracle 9.2.0.4 and we encountered

a strange problem in issueing alter tablespace name offline.

I had to reorganize tablespace and when testing this I did this manually and no problem at all.

I put the statements in a script.

 

Executing the script put the tablespace offlline

with exactly : alter tablespace name offline

Moving the file with os and then starting up the database in mount phase lead to the problem it would not do this.

 

Backtracking this to a test environment and rereading the docs lead me to that I should have used

alter tablespace name offline normal

 

I cannot remember whether I did this ok in the first tests but I might have copied it wrong into my script.

What is the problem in issueing a alter tablespace name offline so without the normal clause?

 

Details: HP-UX11.11, Oracle 9.2.0.4

 

Regards,

 

Jeroen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeroen van Sluisdam
  INET: jeroen.van.sluisdam_at_vrijuit.nl

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).