Answer / Satish Chandra

To drop an Oracle database, you must first shut it down using the SQL*Plus command `SHUTDOWN IMMEDIATE`, then connect as SYSDBA (sysasm owner) and use the `DROP DATABASE` command.n```sqlnSQL> STARTUP MOUNT;
SQL> ALTER DATABASE OPEN READ ONLY;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP NOMOUNT;
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/your/destination';
SQL> CREATE DATABASE datafile1, datafile2, ...;
SQL> ALTER SYSTEM ARCHIVE LOG TRUNCATE;
SQL> ALTER SYSTEM SWITCH LOG FILE;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP NOMOUNT EXCLUSIVE;
SQL> DROP DATABASE;```

What is the advantage of using rman?

1 Answers  

---

What is the difference between cold backup and hot backup?

1 Answers  

---

What are the main functions of dba?

1 Answers  

---

What is dump destination? What are bdump, cdump and udump?

1 Answers  

---

What are the requirements of simple database?

1 Answers  

---

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

1 Answers  

---

How do I become a database administrator?

1 Answers  

---

What are the functions of administration?

1 Answers  

---

What do you understand by the term 'normalization'?

1 Answers  

---

When should you increase copy latches?

1 Answers  

---

Explain the wait events in statspack report 'db sequential real'?

1 Answers  

---

When using oracle export/import what character set concerns might come up? How do you handle them?

1 Answers  

---