Problém:
SQL> startup
Instance ORACLE spustena.
Total System Global Area 8551575552 bytes
Fixed Size 2215064 bytes
Variable Size 4966056808 bytes
Database Buffers 3556769792 bytes
Redo Buffers 26533888 bytes
Databaze pripojena (mounted).
ORA-01157: nelze identifikovat/zamknout dat. soubor 19 – viz sledovaci soubor DBWR
ORA-01110: datovy soubor 19: ‚/opt/database_tmp/oradata_tmp/ORCL/MIGRACE_SLV_2‘
Řešení:
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 32710 SYSTEM *** /opt/database/oradata/ORCL/system01.dbf
2 990 SYSAUX *** /opt/database/oradata/ORCL/sysaux01.dbf
3 32767 UNDOTBS1 *** /opt/database/oradata/ORCL/undotbs01.dbf
4 5 USERS *** /opt/database/oradata/ORCL/users01.dbf
5 64100 ORCL *** /opt/database/oradata/ORCL/ORCL.dbf
…
19 0 MIGRACE_SLV_2 *** /opt/database_tmp/oradata_tmp/ORCL/MIGRACE_SLV_2
21 0 MIGRACE_SLV *** /opt/database_tmp/oradata_tmp/ORCL/MIGRACE_SLV
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
2 32735 TEMP 32767 /opt/database/oradata/ORCL/temp02.dbf
ORCL@db /opt/database_tmp $ pwd
/opt/database_tmp
ORCL@db /opt/database_tmp $ ls -ltr
total 16
drwx—— 2 root root 16384 Nov 25 20:58 lost+found
SQL> ALTER DATABASE DATAFILE ‚/opt/database_tmp/oradata_tmp/ORCL/MIGRACE_SLV_2‘ OFFLINE DROP;
Databaze zmenena.
SQL> ALTER DATABASE DATAFILE ‚/opt/database_tmp/oradata_tmp/ORCL/MIGRACE_SLV‘ OFFLINE DROP;
Databaze zmenena.
SQL> alter database open;
Databaze zmenena.
SQL> DROP TABLESPACE MIGRACE_SLV INCLUDING CONTENTS;
Tablespace zrusen.
SQL> DROP TABLESPACE MIGRACE_SLV_2 INCLUDING CONTENTS;
Tablespace zrusen.