RMANでRACを単一インスタンスプロセスに復元する
21967 ワード
RMANでRACを単一インスタンスプロセスに復元する
1、rmanで生産ライブラリをバックアップする-==注意:SEQUENCE、THREAD値の設定
2、バックアップセットをターゲットライブラリにコピーする
cp xxx xxx 3、復元先ライブラリ3.1復元controlfile
3.2バックアップセットを登録し、ターゲットライブラリをmount時に登録する必要がある
3.3データファイルの復元
4、リカバリ先ライブラリ
5、制御ファイルの再構築(redoパスの変更を目的とする)
6、データベースを開く
7、一時表領域の確立
8、後続作業
不要なundoを削除
1、rmanで生産ライブラリをバックアップする-==注意:SEQUENCE、THREAD値の設定
D:\>rman nocatalog
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Apr 12 14:44:57 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target sys/zboracle12@zboracle1
connected to target database: ZBORACLE (DBID=3725316683)
using target database control file instead of recovery catalog
RMAN> run{
2> backup database format='D:\dump_dir\%U';
3> sql 'alter system archive log current';
4> backup archivelog SEQUENCE=2500 THREAD=1 format='D:\dump_dir\%U';
5> backup archivelog SEQUENCE=1898 THREAD=2 format='D:\dump_dir\%U';
6> }
Starting backup at 12-APR-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=123 instance=zboracle1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=91 instance=zboracle1 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=+ORADISKGRP1/zboracle/datafile/mesapp_data.dbf
input datafile fno=00003 name=+ORADISKGRP1/zboracle/datafile/sysaux.285.683136853
input datafile fno=00005 name=+ORADISKGRP1/zboracle/datafile/undotbs2.289.683136937
input datafile fno=00002 name=+ORADISKGRP1/zboracle/datafile/undotbs1.266.683136853
channel ORA_DISK_1: starting piece 1 at 12-APR-10
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00008 name=+ORADISKGRP1/zboracle/datafile/ppms_data.dbf
input datafile fno=00001 name=+ORADISKGRP1/zboracle/datafile/system.294.683136853
input datafile fno=00007 name=+ORADISKGRP1/zboracle/datafile/mesapp_index.dbf
input datafile fno=00004 name=+ORADISKGRP1/zboracle/datafile/users.260.683136853
channel ORA_DISK_2: starting piece 1 at 12-APR-10
channel ORA_DISK_2: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A0LAUOP9_1_1 tag=TAG20100412T150057 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:36
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_2: starting piece 1 at 12-APR-10
channel ORA_DISK_2: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A1LAUOQD_1_1 tag=TAG20100412T150057 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:05
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_2: starting piece 1 at 12-APR-10
channel ORA_DISK_2: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A2LAUOQI_1_1 tag=TAG20100412T150057 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\9VLAUOP9_1_1 tag=TAG20100412T150057 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:50
Finished backup at 12-APR-10
sql statement: alter system archive log current
Starting backup at 12-APR-10
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2500 recid=4500 stamp=716137309
channel ORA_DISK_1: starting piece 1 at 12-APR-10
channel ORA_DISK_1: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A3LAUOR8_1_1 tag=TAG20100412T150200 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 12-APR-10
Starting backup at 12-APR-10
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=2 sequence=1898 recid=4501 stamp=716137269
channel ORA_DISK_1: starting piece 1 at 12-APR-10
channel ORA_DISK_1: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A4LAUORC_1_1 tag=TAG20100412T150204 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 12-APR-10
RMAN>
2、バックアップセットをターゲットライブラリにコピーする
cp xxx xxx 3、復元先ライブラリ3.1復元controlfile
C:\Documents and Settings\Administrator>rman nocatalog
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Apr 12 15:08:57 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target sys/zboracle12
connected to target database: zboracle (not mounted)
using target database control file instead of recovery catalog
RMAN> restore controlfile from 'D:\dump_dir\New Folder\A1LAUOQD_1_1';
Starting restore at 12-APR-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
output filename=D:\ORACLE\ORADATA\ZBORACLE\CONTROL01.CTL
output filename=D:\ORACLE\ORADATA\ZBORACLE\CONTROL02.CTL
output filename=D:\ORACLE\ORADATA\ZBORACLE\CONTROL03.CTL
Finished restore at 12-APR-10
3.2バックアップセットを登録し、ターゲットライブラリをmount時に登録する必要がある
RMAN> catalog backuppiece 'D:\dump_dir\New Folder\A0LAUOP9_1_1';
cataloged backuppiece
backup piece handle=D:\DUMP_DIR\NEW FOLDER\A0LAUOP9_1_1 recid=3381 stamp=7161403
41
RMAN> catalog backuppiece 'D:\dump_dir\New Folder\A1LAUOQD_1_1';
cataloged backuppiece
backup piece handle=D:\DUMP_DIR\NEW FOLDER\A1LAUOQD_1_1 recid=3382 stamp=7161403
96
RMAN> list backup tag='TAG20100412T150057'
2> ;
List of Backup Sets
===================
BS Key Type LV Size
------- ---- -- ----------
3380 Full 482.82M
List of Datafiles in backup set 3380
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2053040647 12-APR-10 +ORADISKGRP1/zboracle/datafile/system.294.68
3136853
4 Full 2053040647 12-APR-10 +ORADISKGRP1/zboracle/datafile/users.260.683
136853
7 Full 2053040647 12-APR-10 +ORADISKGRP1/zboracle/datafile/mesapp_index.
dbf
8 Full 2053040647 12-APR-10 +ORADISKGRP1/zboracle/datafile/ppms_data.dbf
Backup Set Copy #1 of backup set 3380
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:27 12-APR-10 NO TAG20100412T150057
List of Backup Pieces for backup set 3380 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
3380 1 EXPIRED D:\DUMP_DIR\A0LAUOP9_1_1
Backup Set Copy #2 of backup set 3380
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:27 12-APR-10 NO TAG20100412T150057
List of Backup Pieces for backup set 3380 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
3381 1 AVAILABLE D:\DUMP_DIR\NEW FOLDER\A0LAUOP9_1_1
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3381 Full 14.98M DISK 00:00:00 12-APR-10
BP Key: 3382 Status: AVAILABLE Compressed: NO Tag: TAG20100412T15005
7
Piece Name: D:\DUMP_DIR\NEW FOLDER\A1LAUOQD_1_1
Control File Included: Ckp SCN: 2053040709 Ckp time: 12-APR-10
RMAN> catalog backuppiece 'D:\dump_dir\New Folder\A2LAUOQI_1_1';
cataloged backuppiece
backup piece handle=D:\DUMP_DIR\NEW FOLDER\A2LAUOQI_1_1 recid=3383 stamp=7161405
12
RMAN> catalog backuppiece 'D:\dump_dir\New Folder\9VLAUOP9_1_1';
cataloged backuppiece
backup piece handle=D:\DUMP_DIR\NEW FOLDER\9VLAUOP9_1_1 recid=3384 stamp=7161405
24
RMAN> catalog backuppiece 'D:\dump_dir\New Folder\A3LAUOR8_1_1';
cataloged backuppiece
backup piece handle=D:\DUMP_DIR\NEW FOLDER\A3LAUOR8_1_1 recid=3385 stamp=7161405
42
RMAN> catalog backuppiece 'D:\dump_dir\New Folder\A4LAUORC_1_1';
cataloged backuppiece
backup piece handle=D:\DUMP_DIR\NEW FOLDER\A4LAUORC_1_1 recid=3386 stamp=7161405
52
RMAN>
3.3データファイルの復元
RMAN> run{
2> set newname for datafile 1 to 'D:\oracle\oradata\zboracle\system.dbf';
3> set newname for datafile 2 to 'D:\oracle\oradata\zboracle\undotbs1.dbf';
4> set newname for datafile 3 to 'D:\oracle\oradata\zboracle\sysaux.dbf';
5> set newname for datafile 4 to 'D:\oracle\oradata\zboracle\users.dbf';
6> set newname for datafile 5 to 'D:\oracle\oradata\zboracle\undotbs2.dbf';
7> set newname for datafile 6 to 'D:\oracle\oradata\zboracle\mesapp_data.dbf';
8> set newname for datafile 7 to 'D:\oracle\oradata\zboracle\mesapp_index.dbf';
9> set newname for datafile 8 to 'D:\oracle\oradata\zboracle\ppms_data.dbf';
10> restore database from tag = 'TAG20100412T150057';
11> SWITCH DATAFILE ALL;
12> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 12-APR-10
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORADATA\ZBORACLE\SYSTEM.DBF
restoring datafile 00004 to D:\ORACLE\ORADATA\ZBORACLE\USERS.DBF
restoring datafile 00007 to D:\ORACLE\ORADATA\ZBORACLE\MESAPP_INDEX.DBF
restoring datafile 00008 to D:\ORACLE\ORADATA\ZBORACLE\PPMS_DATA.DBF
channel ORA_DISK_1: reading from backup piece D:\DUMP_DIR\NEW FOLDER\A0LAUOP9_1_
1
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00002 to D:\ORACLE\ORADATA\ZBORACLE\UNDOTBS1.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\ZBORACLE\SYSAUX.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\ZBORACLE\UNDOTBS2.DBF
restoring datafile 00006 to D:\ORACLE\ORADATA\ZBORACLE\MESAPP_DATA.DBF
channel ORA_DISK_2: reading from backup piece D:\DUMP_DIR\NEW FOLDER\9VLAUOP9_1_
1
channel ORA_DISK_1: restored backup piece 1
piece handle=D:\DUMP_DIR\NEW FOLDER\A0LAUOP9_1_1 tag=TAG20100412T150057
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_DISK_2: restored backup piece 1
piece handle=D:\DUMP_DIR\NEW FOLDER\9VLAUOP9_1_1 tag=TAG20100412T150057
channel ORA_DISK_2: restore complete, elapsed time: 00:01:00
Finished restore at 12-APR-10
datafile 1 switched to datafile copy
input datafile copy recid=317 stamp=716140708 filename=D:\ORACLE\ORADATA\ZBORACL
E\SYSTEM.DBF
datafile 2 switched to datafile copy
input datafile copy recid=318 stamp=716140708 filename=D:\ORACLE\ORADATA\ZBORACL
E\UNDOTBS1.DBF
datafile 3 switched to datafile copy
input datafile copy recid=319 stamp=716140708 filename=D:\ORACLE\ORADATA\ZBORACL
E\SYSAUX.DBF
datafile 4 switched to datafile copy
input datafile copy recid=320 stamp=716140708 filename=D:\ORACLE\ORADATA\ZBORACL
E\USERS.DBF
datafile 5 switched to datafile copy
input datafile copy recid=321 stamp=716140708 filename=D:\ORACLE\ORADATA\ZBORACL
E\UNDOTBS2.DBF
datafile 6 switched to datafile copy
input datafile copy recid=322 stamp=716140708 filename=D:\ORACLE\ORADATA\ZBORACL
E\MESAPP_DATA.DBF
datafile 7 switched to datafile copy
input datafile copy recid=323 stamp=716140708 filename=D:\ORACLE\ORADATA\ZBORACL
E\MESAPP_INDEX.DBF
datafile 8 switched to datafile copy
input datafile copy recid=324 stamp=716140708 filename=D:\ORACLE\ORADATA\ZBORACL
E\PPMS_DATA.DBF
4、リカバリ先ライブラリ
RMAN> recover database;
Starting recover at 12-APR-10
using channel ORA_DISK_1
using channel ORA_DISK_2
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_2: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=2500
channel ORA_DISK_1: reading from backup piece D:\DUMP_DIR\NEW FOLDER\A3LAUOR8_1_1
channel ORA_DISK_2: restoring archive log
archive log thread=2 sequence=1898
channel ORA_DISK_2: reading from backup piece D:\DUMP_DIR\NEW FOLDER\A4LAUORC_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=D:\DUMP_DIR\NEW FOLDER\A3LAUOR8_1_1 tag=TAG20100412T150200
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ZBORACLE\ARCHI
VELOG\2010_04_12\O1_MF_1_2500_5W5NR37T_.ARC thread=1 sequence=2500
channel ORA_DISK_2: restored backup piece 1
piece handle=D:\DUMP_DIR\NEW FOLDER\A4LAUORC_1_1 tag=TAG20100412T150204
channel ORA_DISK_2: restore complete, elapsed time: 00:00:01
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ZBORACLE\ARCHI
VELOG\2010_04_12\O1_MF_2_1898_5W5NR389_.ARC thread=2 sequence=1898
channel default: deleting archive log(s)
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ZBORACLE\ARCHI
VELOG\2010_04_12\O1_MF_1_2500_5W5NR37T_.ARC recid=4501 stamp=716140804
unable to find archive log
archive log thread=1 sequence=2501
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/12/2010 16:00:10
RMAN-06054: media recovery requesting unknown log: thread 1 seq 2501 lowscn 2053040735
RMAN>
5、制御ファイルの再構築(redoパスの変更を目的とする)
SQL> alter database backup controlfile to trace as 'D:\dump_dir\New Folder\controlfile.sql';
Database altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP NOMOUNT
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1292036 bytes
Variable Size 205523196 bytes
Database Buffers 398458880 bytes
Redo Buffers 7094272 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "ZBORACLE" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 192
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 1024
5 MAXINSTANCES 32
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 'D:\ORACLE\ORADATA\ZBORACLE\redo1.log' SIZE 50M,
9 GROUP 2 'D:\ORACLE\ORADATA\ZBORACLE\redo2.log' SIZE 50M,
10 GROUP 5 'D:\ORACLE\ORADATA\ZBORACLE\redo3.log' SIZE 50M
11 -- STANDBY LOGFILE
12 DATAFILE
13 'D:\ORACLE\ORADATA\ZBORACLE\SYSTEM.DBF',
14 'D:\ORACLE\ORADATA\ZBORACLE\UNDOTBS1.DBF',
15 'D:\ORACLE\ORADATA\ZBORACLE\SYSAUX.DBF',
16 'D:\ORACLE\ORADATA\ZBORACLE\USERS.DBF',
17 'D:\ORACLE\ORADATA\ZBORACLE\UNDOTBS2.DBF',
18 'D:\ORACLE\ORADATA\ZBORACLE\MESAPP_DATA.DBF',
19 'D:\ORACLE\ORADATA\ZBORACLE\MESAPP_INDEX.DBF',
20 'D:\ORACLE\ORADATA\ZBORACLE\PPMS_DATA.DBF'
21 CHARACTER SET AL32UTF8
22 ;
Control file created.
SQL> select file#, recover, fuzzy, checkpoint_change# from v$datafile_header;
FILE# REC FUZ CHECKPOINT_CHANGE#
---------- --- --- ------------------
1 NO 2053040735
2 NO 2053040735
3 NO 2053040735
4 NO 2053040735
5 NO 2053040735
6 NO 2053040735
7 NO 2053040735
8 NO 2053040735
8 rows selected.
SQL>
6、データベースを開く
SQL> alter database open resetlogs;
Database altered.
7、一時表領域の確立
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
Empty temporary tablespace: MESAPP_TEMP
8、後続作業
不要なundoを削除
SQL> select instance_name,status,thread# from gv$instance;
INSTANCE_NAME STATUS THREAD#
---------------- ------------ ----------
zboracle OPEN 1
SQL> select thread#,status,enabled from v$thread;
THREAD# STATUS ENABLED
---------- ------ --------
1 OPEN PUBLIC
2 CLOSED PRIVATE
SQL> alter database disable thread 2;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ------------------
1 1 0 52428800 1 YES UNUSED
0
2 1 1 52428800 1 NO CURRENT
2446569772 02-JUL-10
3 1 0 52428800 1 YES UNUSED
0
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ------------------
4 1 0 52428800 1 YES UNUSED
0
5 1 0 52428800 1 YES UNUSED
0
6 1 0 52428800 1 YES UNUSED
0
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ------------------
7 2 1 104857600 1 NO INACTIVE
2446569772 02-JUL-10
8 2 0 104857600 1 YES UNUSED
0
8 rows selected.
SQL> alter database drop logfile group 7;
alter database drop logfile group 7
*
ERROR at line 1:
ORA-00350: log 7 of instance UNNAMED_INSTANCE_2 (thread 2) needs to be archived
ORA-00312: online log 7 thread 2:
'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ZBORACLE\ONLINELOG\O1_MF_7_62V90RY
8_.LOG'
SQL> alter database drop logfile group 8 ;
Database altered.
SQL> alter database clear unarchived logfile group 7;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ------------------
1 1 0 52428800 1 YES UNUSED
0
2 1 1 52428800 1 NO CURRENT
2446569772 02-JUL-10
3 1 0 52428800 1 YES UNUSED
0
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ------------------
4 1 0 52428800 1 YES UNUSED
0
5 1 0 52428800 1 YES UNUSED
0
6 1 0 52428800 1 YES UNUSED
0
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ------------------
7 2 0 104857600 1 YES UNUSED
2446569772 02-JUL-10
7 rows selected.
SQL> alter database drop logfile group 7;
Database altered.
SQL> select name from v$tablespace where name like 'UNDO%';
NAME
------------------------------
UNDOTBS1
UNDOTBS2
SQL> desc dba_tablespaces;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BLOCK_SIZE NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
MIN_EXTLEN NUMBER
STATUS VARCHAR2(9)
CONTENTS VARCHAR2(9)
LOGGING VARCHAR2(9)
FORCE_LOGGING VARCHAR2(3)
EXTENT_MANAGEMENT VARCHAR2(10)
ALLOCATION_TYPE VARCHAR2(9)
PLUGGED_IN VARCHAR2(3)
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)
DEF_TAB_COMPRESSION VARCHAR2(8)
RETENTION VARCHAR2(11)
BIGFILE VARCHAR2(3)
SQL> show parameter undo_tablespace;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace string UNDOTBS1
SQL> drop tablespace undotbs2 including contents and datafiles;
Tablespace dropped.