Home » Server Options » RAC & Failsafe » Drop RAC database (10g version)
Drop RAC database [message #328405] Fri, 20 June 2008 01:34 Go to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

I want to drop the RAC database. I am using two ASM environment.(ASM1 and ASM2)

Please give me the steps to follow.
Re: Drop RAC database [message #328409 is a reply to message #328405] Fri, 20 June 2008 01:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use DBCA
Re: Drop RAC database [message #328410 is a reply to message #328409] Fri, 20 June 2008 01:43 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
I want to drop the database manually not dbca nor RMAN.
Re: Drop RAC database [message #328415 is a reply to message #328410] Fri, 20 June 2008 02:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Same as a regular,single instance database.
Drop the files, clean oratab, clean init.ora files, clean $ORACLE_BASE...

Additonally, you need to use srvctl to remove specific instances and database settings from CRS.
If you are using dedicated diskgroups for ASM, clean them if you want.
Using DBCA is most recommended.

[Updated on: Fri, 20 June 2008 02:05]

Report message to a moderator

Re: Drop RAC database [message #328447 is a reply to message #328415] Fri, 20 June 2008 03:58 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
Please give the steps becoz if I do normal database it is showing errors.
Re: Drop RAC database [message #328519 is a reply to message #328447] Fri, 20 June 2008 06:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Please give the steps
I would not recommend something which i would not do it myself for my databases. Smile
As said before, the manual 'steps' are not standard. It depends on your environment.
>> if I do normal database it is showing errors.
What errors?
Post exactly what you did (your session screen shots) along with errors.
Re: Drop RAC database [message #328533 is a reply to message #328519] Fri, 20 June 2008 07:14 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
I followed below steps in instance1.

connect SYS/sWaZeru4 as SYSDBA
shutdown immediate
startup mount restrict
drop database;
exit;

Giving the error...

drop database
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation
Re: Drop RAC database [message #328538 is a reply to message #328533] Fri, 20 June 2008 07:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Since this is a RAC database,
you need to set
CLUSTER_DATABASE=FALSE
and do a
startup mount restrict
Re: Drop RAC database [message #329046 is a reply to message #328538] Mon, 23 June 2008 23:02 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
I think we can not give CLUSTER_DATABASE = FALSE becoz before that database is shutting down.So How to include and Where we have to set the CLUSTER_DATABASE = FALSE.

IF i set in the script it is giving errors...

connect SYS/<syspwd> as SYSDBA
shutdown immediate
CLUSTER_DATABASE=FALSE
startup mount restrict
drop database;
exit;


SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 24 10:27:13 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
SP2-0734: unknown command beginning "CLUSTER_DA..." - rest of line ignored.
ORACLE instance started.

Total System Global Area 364904448 bytes
Fixed Size 1219448 bytes
Variable Size 113247368 bytes
Database Buffers 247463936 bytes
Redo Buffers 2973696 bytes
Database mounted.
drop database
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation
Re: Drop RAC database [message #329048 is a reply to message #328405] Mon, 23 June 2008 23:14 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
>connect SYS/<syspwd> as SYSDBA
>shutdown immediate
>CLUSTER_DATABASE=FALSE

I hope this database does not contain anything of value.

WOW, it appears you have decided to avoid reading any documentation & have proceeded into wonton flailing at Oracle.

You'd be better off just reformatting the whole system.

I refuse to give a loaded weapon to a child.
Re: Drop RAC database [message #329120 is a reply to message #329048] Tue, 24 June 2008 03:24 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount restrict
ORACLE instance started.

Total System Global Area 364904448 bytes
Fixed Size 1219448 bytes
Variable Size 117441672 bytes
Database Buffers 243269632 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation


SQL> shut immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount exclusive
ORACLE instance started.

Total System Global Area 364904448 bytes
Fixed Size 1219448 bytes
Variable Size 117441672 bytes
Database Buffers 243269632 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation


When I mount the database in exclusive mode / restrict mode it is giving same error.

Please advice...
Re: Drop RAC database [message #329160 is a reply to message #329046] Tue, 24 June 2008 06:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I think we can not give CLUSTER_DATABASE = FALSE
Did you at least google? Check documentation?
>> So How to include and Where we have to set the CLUSTER_DATABASE = FALSE.

If you are not aware of setting init.ora parameters, you are not supposed to be doing these kind of operations.


Quoting Ana
>>I refuse to give a loaded weapon to a child.

Much true.
Re: Drop RAC database [message #329171 is a reply to message #329160] Tue, 24 June 2008 07:21 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
Already the parameter "cluster_database= false" in both the instances of cluster environment. If I do the below steps I am getting the below errors.

I know how to change the cluster_database parameter but already it is false.
Re: Drop RAC database [message #329175 is a reply to message #329171] Tue, 24 June 2008 07:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
prove it. Post it.
Re: Drop RAC database [message #329184 is a reply to message #329175] Tue, 24 June 2008 08:00 Go to previous messageGo to next message
grpatwari
Messages: 198
Registered: June 2008
Location: Hyderabad
Senior Member
see the below o/p from my database...

SQL> l
  1* select * from v$parameter where name='cluster_database'
SQL> set lines 1000
SQL> /

       NUM NAME                                                                                   TYPE VALUE
---------- -------------------------------------------------------------------------------- ----------  ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------------------------------
DISPLAY_VALUE                                                                                                                ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP DESCRIPTION
 ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------- ----- --------- ----- ---------- ----- -----  ------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------
UPDATE_COMMENT                                                                                                                    HASH
 ------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- ----------
       548 cluster_database                                                                          1 TRUE
TRUE                                                                                                                         FALSE      FALSE FALSE     FALSE FALSE      FALSE FALSE if TRUE startup in cluster database mode
                                                                                                                            3044213568

[Updated on: Tue, 24 June 2008 09:16] by Moderator

Report message to a moderator

Re: Drop RAC database [message #329199 is a reply to message #328405] Tue, 24 June 2008 08:29 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above
Re: Drop RAC database [message #329210 is a reply to message #329184] Tue, 24 June 2008 09:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Without proper formatting, I am not sure.
But it seeems that
Quote:
cluster_database 1 TRUE


What do you think?
Re: Drop RAC database [message #337616 is a reply to message #329210] Thu, 31 July 2008 07:29 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member

he he he Very Happy Laughing

SQL> alter system set cluster_database=false scope=spfile;
Re: Drop RAC database [message #620023 is a reply to message #337616] Sun, 27 July 2014 23:45 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,
Quote:
Using DBCA is most recommended.

Is it enough if we use dbca to delete a 2 node rac database ? or Is something else should be done before invoke dbca to delete database like remove instance , stop database or deleting database files manually etc...

Pls note that this question is related to delete a multiple node rac database using dbca utility.

Regards,
Srini

[Updated on: Sun, 27 July 2014 23:49]

Report message to a moderator

Re: Drop RAC database [message #620027 is a reply to message #620023] Mon, 28 July 2014 00:12 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Didn't you say in one of your recent topics that you have already used dbca to drop a RAC database?

Re: Drop RAC database [message #620030 is a reply to message #620027] Mon, 28 July 2014 02:04 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

No Michel
Re: Drop RAC database [message #620033 is a reply to message #620030] Mon, 28 July 2014 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/193737/619576/#msg_619576

Database admin wrote on Wed, 23 July 2014 15:34
Hello ,

I once used the following command to drop a database in RAC environment and it was successful.
/u01/app/oracle/product/11.2.0/DB1/bin/dbca -silent -deleteDatabase -sourceDB AD0001C -sysDBAUserName SYS -sysDBAPassword Passw0rd
then insure that /etc/oratab is clean on all nodes

My question is shall i use the same command to drop a database for standalone database ?
Can you clarify ?

Regards,
Srini

Re: Drop RAC database [message #620055 is a reply to message #620033] Mon, 28 July 2014 07:47 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Micehl,

I wanted to use this dbca -silent -deleteDatabase command but not sure it will be successful.I had used this command long ago.So wanted to know by using dbca would work or not.

Regards,
Srini

Re: Drop RAC database [message #620057 is a reply to message #620055] Mon, 28 July 2014 07:49 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Try it.

Previous Topic: listener is down: TNS-12543: TNS:destination host unreachable
Next Topic: Verify Service in RAC
Goto Forum:
  


Current Time: Sat Aug 30 15:15:44 CDT 2014

Total time taken to generate the page: 0.16324 seconds