ALTER TABLESPACE SYSAUX OFFLINE; 2005-08-01 - By Sinardy
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 (See ORA-00376.ora-code.com): file 3 cannot be read at this time
ORA-01110 (See ORA-01110.ora-code.com): data file 3: 'C:\MYORACLE\ORADATA\ORA10G\SYSAUX01.DBF'
ORA-06512 (See ORA-06512.ora-code.com): 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@(protected)>
To: "oracle-l" <oracle-l@(protected)>
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
|
|
