FreeLists / oracle-l / Re: ALTER TABLESPACE SYSAUX OFFLINE;

[oracle-l] || [Date Prev] [08-2005 Date Index] [Date Next] || [Thread Prev] [08-2005 Thread Index] [Thread Next]

Re: ALTER TABLESPACE SYSAUX OFFLINE;

From: "Sinardy" <all_about_oracle@xxxxxxxxxx>
To: <dba.orcl@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 1 Aug 2005 15:41:46 +0800

Hi, 

Your db can't work properly with sysaux offline.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 1 15:38:09 2005

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select count(*) from all_objects
  2  where status = 'VALID';

  COUNT(*)
----------
     48887

SQL> alter tablespace sysaux offline;

Tablespace altered.

SQL> select count(*) from all_objects
  2  where status = 'VALID';
where status = 'VALID'
                     *
ERROR at line 2:
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: 'C:\MYORACLE\ORADATA\ORA10G\SYSAUX01.DBF'
ORA-06512: at "SYS.XML_SCHEMA_NAME_PRESENT", line 17


SQL> alter tablespace sysaux online;

Tablespace altered.

SQL> select count(*) from all_objects
  2  where status = 'VALID';

  COUNT(*)
----------
     48887

SQL>




----- Original Message ----- 
From: "Sami Seerangan" <dba.orcl@xxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, July 31, 2005 2:34 AM
Subject: ALTER TABLESPACE SYSAUX OFFLINE;


> I remember the document says that we cannot put SYSAUX in offline.
> 
> SQL> ALTER TABLESPACE SYSAUX OFFLINE;
> 
> Tablespace altered.
> 
> SQL> select * from v$version;
> 
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
> PL/SQL Release 10.1.0.2.0 - Production
> CORE    10.1.0.2.0      Production
> TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
> NLSRTL Version 10.1.0.2.0 - Production
> 
> 
> SQL> select open_mode,name from v$database;
> 
> OPEN_MODE  NAME
> ---------- ---------
> READ WRITE WIN2K10G
> --
> http://www.freelists.org/webpage/oracle-l
> 


--
http://www.freelists.org/webpage/oracle-l