recreating undo tablespace


bash-3.2$ ps -afe | grep smon
 root 823 1 0 Dec 23 ? 88:28 /u02/app/oracle/product/grid/db_1/bin/osysmond.bin
 oracle 19016 1 0 Jun 20 ? 7:01 asm_smon_+ASM1
 oracle 4844 1 0 Dec 22 ? 0:55 ora_smon_ANARDB1
 oracle 22215 23124 0 13:41:02 pts/2 0:00 grep smon




bash-3.2$ sqll
SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 26 13:41:03 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select name , open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ANARDB READ WRITE




SQL> SELECT name,value FROM v$parameter WHERE name IN (‘undo_management’,’undo_tablespace’);
NAME VALUE
————————
undo_management AUTO
undo_tablespace UNDOTBS01
SQL>

SQL> CREATE UNDO TABLESPACE undotbs02
DATAFILE ‘/u01/app/oracle/oradata/ANARDB/undotbs02.dbf’ SIZE 1024M
REUSE AUTOEXTEND ON NEXT 4096K MAXSIZE 10240M;
SQL> ALTER SYSTEM SET undo_tablespace = ‘UNDOTBS02′;

SQL> ALTER TABLESPACE undotbs01 OFFLINE;
SQL> DROP TABLESPACE undotbs01 INCLUDING CONTENTS AND DATAFILES;

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: