Oracle introduced a new command in 10g to drop a database. Before that there was a set of procedures to follow in order to get rid of a database which involved deleting all data files from the file system, deleting control files, the parameter files etc. Now after this command everything is deleted by the RDBMS and there is no chance of forgetting any file to delete.
The command is simple, “DROP DATABASE”.
And the procedure to use this command is:
sqlplus / as sysdba
SQL> shutdown immediate
ORACLE instance shut down.
SQL> startup mount exclusive restrict
ORACLE instance started.
rman target /
The database has to be started in exclusive restrict mode.
If you are running a RAC you will have to close down all instances and mount the database exclusively on one node only. The parameter file will need to be changed and the parameter “cluster_database” should be set to false. My suggestion is to create another parameter file from spfile and mount the database using that file.
CREATE PFILE=’/home/oracle/anotherpfile.ora’ from SPFILE;
The file can be modified and all RAC/node specific parameters can be removed.
|Share this post :||Social!||del.icio.us it!||digg it!||Facebook it!||live it!||reddit!||technorati!||yahoo!|