standby - ora-00209
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: standby - ora-00209

  1. #1
    Join Date
    Nov 2000
    Posts
    245
    Unix, 8.0.5. I try to create a standby site on 2nd server. here are the steps I did:
    backup all datafiles and copy to standby site
    >alter database create standby controlfile as '/ora/backup/standby.ctl';
    >alter system archive log current;
    copy(ftp) /ora/backup/standby.ctl to standby site using the current new /ora/cntl1/control01.ctl, /ora/cntl2/control02.ctl.
    make sure, init, directories all correct.
    >startup nomount
    >alter database mount standby database;
    then get error
    ora-00209

    here is the error from alert file:
    alter database mount standby database
    Wed Dec 27 14:30:53 2000
    ORA-00218: block size 0 of controlfile does not match DB_BLOCK_SIZE (8192)
    ORA-00202: controlfile: '/ora/cntl1/@/control01.ctl'
    Wed Dec 27 14:30:53 2000
    ORA-209 signalled during: alter database mount standby database...

    HELP!!! what I did wrong?



  2. #2
    Join Date
    Apr 2000
    Posts
    126

    Wink standby - ora-00209

    Is the 2nd server identical to the 1st? This error indicates that a block size larger than allowed by the operating system was specified. Do you have the same initSID.ora on the 2nd server?

  3. #3
    Join Date
    Nov 2000
    Posts
    245
    yes, identical to the 1st one. bascally I copy/ftp all DB related files (init, password, data files) then copy the control file which created using alter database.... I don't have the redo file copy (it means 2nd site, standby site no redo log file).
    anything missing?

    Jim

  4. #4
    Join Date
    Apr 2000
    Posts
    126

    Wink

    ORA-00218 indicates that the control file could be corrupt. Did you ftp binary? Have tried the whole process again?

  5. #5
    Join Date
    Nov 2000
    Posts
    245

    yes, I tried ascii and binary both mode, get the same error.
    I even shutdown the primary site, just ftp the controlfile to
    the standby site directly, still can not solve it.

    so far, I am trying to create standby on the same machine to see it works or not

  6. #6
    Join Date
    Nov 2000
    Posts
    212
    Metalink claims:
    1) it can happen if messed with db_block_size in init/ora. Could it be that standby db is using wrong init.ora file?
    2) control file is corrupt... (may be it is really corrupt?)

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