Scenario when the controlfile is lost and there was a datafile added to an existing table space after backup of the controlfile was taken so the controlfile does not know about the new datafile. 1) Start database in nomount state SQL> connect /as sysdba SQL> startup nomount ORACLE instance started. Total System Global Area 209715200 … Continue reading Scenario when the controlfile is lost and there was a datafile added
Tag: datafile
How to move datafiles in temp tablespace?
One can't move the temp tablespace during mount stage like other datafiles using "ALTER DATABASE RENAME FILE.." so a workaround this issue is to create a new temp tablespace. SQL> drop tablespace temp; drop tablespace temp * ERROR at line 1: ORA-12906: cannot drop default temporary tablespace -- create a new temp tablespace SQL> CREATE … Continue reading How to move datafiles in temp tablespace?
alexlima.com 