Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> rebuilding database with different db_block_size?
Objective: rebuild Oracle 8.0.5 RDBMS using db_block_size of 4096
(or maybe 8192) on Intel PII/Red Hat Linux 5.2 (Apollo 2.0.36-3
kernel) box.
Gotchas:
According to the Oracle8 DBA Handbook (p. 275) you need to blow away the old db files. The online docs were relatively unhelpful. I'd prefer to read a well-written man page (with examples!), but Oracle doesn't have man pages.
Background:
Problem:
When I run orainst to create the database objects, it replaces my tweaked files with default files. I *have* rebuilt the data- base correctly by copying *my* config files during the orainst session, but I can't imagine that this is the *right* way to rebuild the database.
Apologies:
Sorry, I'm new to this DBA thing, but I'd rather learn how to do this now (and set it up in a semi-correct fashion) rather than wait to find out that the default orainst parameters are all screwed up.
What I Want to Know?
TIA, S.
--
Sean Yamamoto If William of Ockham had a beard, Web Cabalist it wasn't because his razor was dull. seany_at_altavista.net "Apply Occam's razor."Received on Wed Jan 27 1999 - 02:43:41 CST