Wednesday, November 20, 2013

Drop datafile of temp tablespace

ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata3/temp_5/temp.data5';
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata6/temp_6/temp.data6';
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata6/temp_7/temp.data7';

cd /oracle/PIP/sapdata3/
rmdir temp_5


cd /oracle/PIP/sapdata6/
rmdir temp_6

cd /oracle/PIP/sapdata6/
rmdir temp_7

Tuesday, November 19, 2013

Switching oracle database archive to non archive mode and vice versa.

switching off archive mode.
    shutdown immediate;
    startup mount;
    alter database noarchivelog;
    alter database open;
switching on archive mode.
    shutdown immediate;
    startup mount;
    alter database archivelog;
    alter database open;