DROP DATABASE



Say if you have to drop the database, this can be carried out if the database is registed with RMAN.
Easy steps.

Verify the Database.

export ORACLE_SID=khan
$ sqlplus / as sysdba
SQL> startup
SQL>  select name from v$datafile;
SQL> select member from v$logfile;
SQL> select name from v$controlfile;
SQL> select name , open_mode , log_mode from v$database;
SQL> shutdown immediate;

On RMAN CONSOLE**

Connect to RMAN

$ORACLE_HOME/bin/rman catalog=rcat_testdb_khant/rcat@rman
RMAN> connect target/
RMAN> startup force mount
RMAN> SQL 'ALTER SYSTEM ENABLE RESTRICTED SESSION';
sql statement: ALTER SYSTEM ENABLE RESTRICTED SESSION

RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;


This drops the database and backups and unregister the database from catalog Database.

 

Comments

Post a Comment

Welcome to the Oracle DBA Blog.

Stay Hungry Stay Foolish

Popular posts from this blog

how to find database is running on PFILE or SPFILE

Below script will tells us if the database is running on PFILE or SPFILE  SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile'; OR SQL> show parameter spfile; NAME TYPE VALUE —— —— ———————————————— spfile string /u01/apps/oracle/10g/dbs/spfileorclkhan.ora parameter will tell you the location where the SPFILE is present as well.
Read more

Oracle Lock

Oracle Locks User must request a resource (i.e row,table,index etc) before using it and must release that resource after using it. Without following above approach there would be collision among user requests which result data to be in inconsistent.To avoid data inconsistency a lock mechanisim adopted within different database,Every database has its own locking mechanism. Oracle uses two modes in a multiuser database either its on table or row Exclusive lock mode Exclusive lock mode never allowed the associates resource from being shared.This lock mode is obtained to modify data.Only one exclusive lock can be placed on a resource (such as a row or a table). i.e From one session i acquire the exclusive lock on resource (emp table) Session a SQL> lock table emp in exclusive mode nowait   2   / Table(s) Locked. Note : The optional keyword NOWAIT tells Oracle not to wait for a table if it has been locked by another user. From another session i tr...
Read more

Oracle Dba Jobs Interview Question and Answers. PART-2

Continued from: http://ghufranahmedkhan.blogspot.com/2015/06/oracle-dba-jobs-interview-question-and.html 1. How many memory layers are in the shared pool? Ans:  The shared pool portion of the SGA contains three major areas: library cache(contains parsed sql statements,cursor information,execution plans), dictionary cache (contains cache -user account information,privileges information,data file,segment and extent information), buffers for parallel execution messages, and control structure. 2. How do you find out from the RMAN catalog if a particular archive log has been backed-up? Ans:  list archivelog all; 3. How can you tell how much space is left on a given file system and how much space each of the file system’s subdirectories take-up? Ans: df -kh and du-sh 4. Define the SGA and: i)  How you would configure SGA for a mid-sized OLTP environment? ii) What is involved in tuning the SGA? Ans: SGA: The System Global Area (SGA) is a grou...
Read more