Create Controlfile Script Refers To Dropped Tablespaces (Doc ID 1369949.1)

Last updated on FEBRUARY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Feb-2017***

Symptoms

Previously dropped read-only tablespaces appear in the trace file portion of the create controlfile trace file output.

Simple test case (on Windows) exhibiting the problem:

create tablespace FOOBAR_DEL_ME
datafile 'D:\ORACLE\ORADATA\V11202\DEL_ME.DBF' size 5M reuse
extent management local autoallocate
segment space management auto;

create tablespace FOOBAR_READONLY
datafile 'D:\ORACLE\ORADATA\V11202\READ_ONLY.DBF' size 5M reuse
extent management local autoallocate
segment space management auto;

alter tablespace foobar_readonly read only;

drop tablespace FOOBAR_DEL_ME including contents and datafiles;

REM drop tablespace FOOBAR_READONLY including contents and datafiles;

alter database backup controlfile to trace;



NOTE:
The issue does not reproduce when the read only tablespace is also dropped in the test case.



The create controlfile script shows the following relevant symptoms:

--  Datafile clause:

...
DATAFILE
'D:\ORACLE\ORADATA\V11202\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\V11202\SYSAUX01.DBF',
'D:\ORACLE\ORADATA\V11202\UNDOTBS01.DBF',
'D:\ORACLE\ORADATA\V11202\USERS01.DBF'
CHARACTER SET AL32UTF8
;
...


-- Opening the database:

...
ALTER DATABASE OPEN;
-- Files in read-only tablespaces are now named.
ALTER DATABASE RENAME FILE 'MISSING00006'
TO 'D:\ORACLE\ORADATA\V11202\READ_ONLY.DBF';
-- Online the files in read-only tablespaces.
ALTER TABLESPACE "FOOBAR_DEL_ME" ONLINE;
ALTER TABLESPACE "FOOBAR_READONLY" ONLINE;
...



NOTE:
The datafile 'D:\ORACLE\ORADATA\V11202\READ_ONLY.DBF' is not included in the datafile list but added by renaming a 'MISSING...' file.

Changes

Upgrade to Oracle 11.2.0.2.0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms