|
|
Re: drop physical standby database [message #319595 is a reply to message #319594] |
Mon, 12 May 2008 05:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
malvika
Messages: 55 Registered: May 2008 Location: india
|
Member |
![mistry_malvika056%40yahoo.com](/forum/theme/orafaq/images/yahoo.png) ![malvika.mistry@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 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
|
|
|