-
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?
-
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?
-
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
-
ORA-00218 indicates that the control file could be corrupt. Did you ftp binary? Have tried the whole process again?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|