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
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
