Hi gurus,
I have a 3-node RAC with 2 standby databases, all of them 11.2.0.3, on CentOS 5.10 64 bits.
I use Active Data Guard (with DB open in read-only mode, obviously).
My problem is that somehow I have 3 tempfiles named '+DATA' on one standby database, so I can't drop nor rename these files. Is there any way to fix this?
Looks like the tempfiles couldn't be created when the database was opened in read-only mode.
Thanks a lot for your help.
# Primary DB:
col TABLESPACE format a10
col TEMPFILE format a50
select a.name TABLESPACE, b.TS#, b.FILE#, b.name TEMPFILE, b.bytes/1024/1024 MB, b.status from v$tablespace a, v$tempfile b where a.name='TEMP';
TABLESPACE TS# FILE# TEMPFILE MB STATUS
---------- ---------- ---------- -------------------------------------------------- ---------- -------
TEMP 3 4 +DATA/racdb/tempfile/temp.382.873892319 8192 ONLINE
TEMP 3 7 +DATA/racdb/tempfile/temp.383.873892341 8192 ONLINE
TEMP 3 8 +DATA/racdb/tempfile/temp.384.873892341 8192 ONLINE
# Standby DB:
col TABLESPACE format a10
col TEMPFILE format a50
select a.name TABLESPACE, b.TS#, b.FILE#, b.name TEMPFILE, b.bytes/1024/1024 MB, b.status from v$tablespace a, v$tempfile b where a.name='TEMP';
TABLESPACE TS# FILE# TEMPFILE MB STATUS
---------- ---------- ---------- -------------------------------------------------- ---------- -------
TEMP 3 4 +DATA 0 ONLINE
TEMP 3 7 +DATA 0 ONLINE
TEMP 3 8 +DATA 0 ONLINE
TEMP 3 9 /u02/oradata/RACDBSB1/tempfile/temp_01.dbf 512 ONLINE
RMAN> report schema;
using target database control file instead of recovery catalog
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name RACDBSB1
(...)
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
4 3072 TEMP 8192 +DATA
7 3584 TEMP 8192 +DATA
8 5120 TEMP 8192 +DATA
9 512 TEMP 8192 /u02/oradata/RACDBSB1/tempfile/temp_01.dbf
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_create_file_dest string /u02/oradata
Thanks!