Oracle Database Discussions

Hello Gurus,

I am getting following error, I tried following some of the suggestions from blog they didn’t help. Can some one please help me here?

oracle@bfcdridbora01:/home/oracle
. .profile.10.2.0.db_1
oracle@bfcdridbora01:/home/oracle
export ORACLE_SID=up263
oracle@bfcdridbora01:/home/oracle
sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Sun Aug 29 05:22:13 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size                  2076568 bytes
Variable Size             192938088 bytes
Database Buffers          637534208 bytes
Redo Buffers                6311936 bytes
Database mounted.
SQL> alter database recover managed standby database disconnect;
alter database recover managed standby database disconnect
*
ERROR at line 1:
ORA-01665: control file is not a standby control file


SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /app/oracle/product/10.2.0/db_
                                                 1/dbs/spfileup263.ora
SQL> show parameter controlfile
SQL> show parameter con

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_interconnects                string
control_file_record_keep_time        integer     15
control_files                        string      /up263/data001/control01.ctl,
                                                 /up263/data001/control02.ctl,
                                                 /up263/data001/control03.ctl
db_file_name_convert                 string
dg_broker_config_file1               string      /app/oracle/product/10.2.0/db_
                                                 1/dbs/dr1up263.dat
dg_broker_config_file2               string      /app/oracle/product/10.2.0/db_
                                                 1/dbs/dr2up263.dat
global_context_pool_size             string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string
log_file_name_convert                string
nls_nchar_conv_excp                  string      FALSE
SQL> select name from v$database;

NAME
---------
UP263

SQL> alter database create standby controlfile as '/up263/data001/control01.ctl';
alter database create standby controlfile as '/up263/data001/control01.ctl'
*
ERROR at line 1:
ORA-00222: operation would reuse name of a currently mounted control file
ORA-00202: control file: '/up263/data001/control01.ctl'


SQL>