standby controlfile issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: standby controlfile issue

  1. #1
    Join Date
    Dec 2002
    Posts
    36

    standby controlfile issue

    OS Win2000
    DB 9i

    Hi all,

    I have read Oracle docs on standy DB creation and performed all the steps. When I try to mount the standby DB, I get this error:

    SQL> connect / as sysdba
    Connected to an idle instance.
    SQL> startup nomount pfile=D:\Oracle\Ora92\database\init.ora
    ORACLE instance started.

    Total System Global Area 118255568 bytes
    Fixed Size 282576 bytes
    Variable Size 83886080 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 532480 bytes
    SQL> alter database mount standby database;
    alter database mount standby database
    *
    ERROR at line 1:
    ORA-01665: controlfile is not a standby controlfile

    This controlfile file was created with the 'alter database create controlfile......' command.

    Any input will be highly appreciated.

  2. #2
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    Process error is my guess. I have used that a zillion times, just last week after rebuilding the primary control file because someone created the db with maxlogfiles=5, made new primary control file then create standby. Then 'copy' standby control file to other host and be sure its being used.

    1) use an unusual name when you create it
    2) verify it is transferred successfully
    3) verify it is going in the right location by examining spfile

  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    Re: standby controlfile issue

    Originally posted by roman33
    This controlfile file was created with the 'alter database create controlfile......' command.
    4. verify that you are using the control file that you think you created in the alter database command. use the TO 'c:\somwhere\stdby.ctl' option of the command.

  4. #4
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Re: standby controlfile issue

    SQL> alter database mount standby database;
    alter database mount standby database
    *
    ERROR at line 1:
    ORA-01665: controlfile is not a standby controlfile

    This controlfile file was created with the 'alter database create controlfile......' command.
    You have to use another command:
    CREATE STANDBY CONTROLFILE AS 'filename'
    Best wishes!
    Dmitri

  5. #5
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    Talking Re: Re: standby controlfile issue

    Originally posted by kgb
    You have to use another command:
    CREATE STANDBY CONTROLFILE AS 'filename'
    Good catch Dmitri!!!
    That fact obviously slipped past BJE_DBA and myself!!!

  6. #6
    Join Date
    Dec 2002
    Posts
    36
    Thanks gus!!!!!

  7. #7
    Join Date
    Dec 2002
    Posts
    36
    I mean thanks guys!!!!!

  8. #8
    Join Date
    Mar 2004
    Posts
    1

    ORA-00205: error in identifying controlfile, check alert log for more info

    Hello,


    I am getting this error: SQL> startup nomount pfile='c:\richard\local\pfile\init.ora'
    ORACLE instance started.

    Total System Global Area 104114204 bytes
    Fixed Size 75804 bytes
    Variable Size 57389056 bytes
    Database Buffers 46571520 bytes
    Redo Buffers 77824 bytes
    SQL> alter database mount standby database;
    alter database mount standby database
    *
    ERROR at line 1:
    ORA-00205: error in identifying controlfile, check alert log for more info

    the Alert log states:

    Wed Mar 24 13:28:37 2004
    alter database mount standby database

    Wed Mar 24 13:28:38 2004
    ORA-00202: controlfile: 'c:\richard\control01.ctl'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.

    Wed Mar 24 13:28:41 2004
    ORA-205 signalled during: alter database mount standby database


    Does that mean when moving my datafiles, standby control file and my redo log files, I also need to move my control files?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width