Home » Server Options » Data Guard » drop physical standby database
drop physical standby database [message #319585] Mon, 12 May 2008 05:28 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

hi i want to drop my physical standby database can any body tell me how i can do this?
Re: drop physical standby database [message #319594 is a reply to message #319585] Mon, 12 May 2008 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove all the files.

Regards
Michel
Re: drop physical standby database [message #319595 is a reply to message #319594] Mon, 12 May 2008 05:59 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

if i will drop all files related this physical standby database then it(database) will be completely drop in oracle?

[oracle9i@datastorage oradata]$ export ORACLE_SID=TESTBMPS
[oracle9i@datastorage oradata]$ sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on Mon May 12 17:06:24 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production


SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u02/app/oracle/product/9.2.0.4
initTESTBMPS.ora'
SQL>

is there my physical standby database remove completely.
if yes then why it display the RED FONT msg.
not 'Connected to an idle instance.' msg display.

[Updated on: Mon, 12 May 2008 06:08]

Report message to a moderator

Re: drop physical standby database [message #319606 is a reply to message #319595] Mon, 12 May 2008 06:36 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Set your ORACLE_SID to anything you want for instance MALVIKA and you will see the same messages.

You can start an instance for a non-existing database, actually you must do it is you want to create a database.

"Connected to an idle instance." just means that nothing is currently started, it is a potential instance something that might be created.

Regards
Michel
Previous Topic: TableSpace Creation Problem in Standby database
Next Topic: step for creating physical standby database (merged)
Goto Forum:
  


Current Time: Thu Mar 28 10:56:58 CDT 2024