OraFAQ Forum: RAC & Failsafe » Drop RAC database

Home » Server Options » RAC & Failsafe » Drop RAC database (10g version)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop RAC database [message #328405]

Fri, 20 June 2008 01:34

grpatwari
Messages: 288
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.

Report message to a moderator

Re: Drop RAC database [message #328409 is a reply to message #328405]

Fri, 20 June 2008 01:41

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use DBCA

Report message to a moderator

Re: Drop RAC database [message #328410 is a reply to message #328409]

Fri, 20 June 2008 01:43

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

I want to drop the database manually not dbca nor RMAN.

Report message to a moderator

Re: Drop RAC database [message #328415 is a reply to message #328410]

Fri, 20 June 2008 02:04

Mahesh Rajendran
Messages: 10706
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

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Please give the steps becoz if I do normal database it is showing errors.

Report message to a moderator

Re: Drop RAC database [message #328519 is a reply to message #328447]

Fri, 20 June 2008 06:43

Mahesh Rajendran
Messages: 10706
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.

Report message to a moderator

Re: Drop RAC database [message #328533 is a reply to message #328519]

Fri, 20 June 2008 07:14

grpatwari
Messages: 288
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

Report message to a moderator

Re: Drop RAC database [message #328538 is a reply to message #328533]

Fri, 20 June 2008 07:32

Mahesh Rajendran
Messages: 10706
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

Report message to a moderator

Re: Drop RAC database [message #329046 is a reply to message #328538]

Mon, 23 June 2008 23:02

grpatwari
Messages: 288
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

Report message to a moderator

Re: Drop RAC database [message #329048 is a reply to message #328405]

Mon, 23 June 2008 23:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Drop RAC database [message #329120 is a reply to message #329048]

Tue, 24 June 2008 03:24

grpatwari
Messages: 288
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...

Report message to a moderator

Re: Drop RAC database [message #329160 is a reply to message #329046]

Tue, 24 June 2008 06:15

Mahesh Rajendran
Messages: 10706
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.

Report message to a moderator

Re: Drop RAC database [message #329171 is a reply to message #329160]

Tue, 24 June 2008 07:21

grpatwari
Messages: 288
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.

Report message to a moderator

Re: Drop RAC database [message #329175 is a reply to message #329171]

Tue, 24 June 2008 07:37

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

prove it. Post it.

Report message to a moderator

Re: Drop RAC database [message #329184 is a reply to message #329175]

Tue, 24 June 2008 08:00

grpatwari
Messages: 288
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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above

Report message to a moderator

Re: Drop RAC database [message #329210 is a reply to message #329184]

Tue, 24 June 2008 09:18

Mahesh Rajendran
Messages: 10706
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?

Report message to a moderator

Re: Drop RAC database [message #337616 is a reply to message #329210]

Thu, 31 July 2008 07:29

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

he he he

SQL> alter system set cluster_database=false scope=spfile;

Report message to a moderator

Re: Drop RAC database [message #620023 is a reply to message #337616]

Sun, 27 July 2014 23:45

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

Michel Cadot
Messages: 68418
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?

Report message to a moderator

Re: Drop RAC database [message #620030 is a reply to message #620027]

Mon, 28 July 2014 02:04

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

No Michel

Report message to a moderator

Re: Drop RAC database [message #620033 is a reply to message #620030]

Mon, 28 July 2014 02:34

Michel Cadot
Messages: 68418
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

Report message to a moderator

Re: Drop RAC database [message #620055 is a reply to message #620033]

Mon, 28 July 2014 07:47

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

Report message to a moderator

Re: Drop RAC database [message #620057 is a reply to message #620055]

Mon, 28 July 2014 07:49

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Try it.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 19:56:34 CDT 2023