| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: rebuilding database with different db_block_size?
A copy of this was sent to rspeaker_at_my-dejanews.com
(if that email address didn't require changing)
On Fri, 29 Jan 1999 18:50:22 GMT, you wrote:
>Sorry, I don't have the exact syntax handy, but I believe this is what you
>need to do: alter database backup controlfile to trace; exit from svrmgr.
>Then rename the trace file to something ending in .sql (recr_con.sql). Edit
>the trace file, remove the trace header information & change block size.
>shutdown the database and take a FULL backup. Remove the current controlfiles
>from the OS level reconnect to svrmgrl as internal run the script
>@recr_con.sql alter database open noresetlogs;
>
no, you cannot do this!!!
once a block size is set for a set of datafiles, its that size forever. You must EXP or otherwise unload your data and create a brand new database with brand new datafiles with the new blocksize.
Doing the above will trash your datafiles.
>You may also want to search Oracle's website for any whitepapers about this.
>
>HTH,
>Roy
>
>In article <36AED1BD.C1B8F65B_at_altavista.net>,
> seany_at_altavista.net wrote:
>> 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:
>>
>> 1. The filesystem has been built with a 4096 block size (using
>> mkfs.ext2) and tune2fs confirms it.
>> 2. Used ORACLE_HOME/bin/exp to export the entire database
>> 3. dbshut
>> 4. Hand edited the files in:
>> ORACLE_BASE/admin/[sid]/pfile
>> ORACLE_HOME/dbs
>> and added db_block_size = 4096
>> 5. Blew away the stuff in /u0[n]/oradata/[sid]
>>
>> 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?
>>
>> 1. How to rebuild the database from customized parameters?
>> 2. Where does that config file live?
>>
>> 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."
>>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jan 29 1999 - 13:36:28 CST
 |
 |