Thursday, August 27, 2020

Drop an oracle database

Whether the database is primary db or standby db we can efficiently drop the database according to its service name.

The following steps we need to perform: 

1. [oracle@rnddb /]$ ps -ef | grep pmon

2. kill -9 process_id

4. RMAN> CONNECT TARGET SYS@test1
5. RMAN> STARTUP FORCE MOUNT
6. RMAN> SQL 'ALTER SYSTEM ENABLE RESTRICTED SESSION';
7. RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;
Finally wait a while to finish the job Recovery Manager complete.

No comments:

Post a Comment

Change Sys Password

Change Sys password at primary and standby database (ADG) server: +++++++++++++++++++++++++++++++++++++++++++++++++++++ step 1: cancel MRP p...

Data Guard Broker Configuration