| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Rebuilding database to change block size
Rachel, Rachel,,
Sure he can skip step 4, just make sure you use 'create database controlfile reuse' and 'datafile <whatever> size <something> reuse' all over the place. I do it all the time.
As for can you create the script from the old database, sure can. I do so once a week from each of my databases to catch any structural changes. Have a Pro*C program that does the create scripts, even adds the standard packages into. Let me know if you'd like a copy.
____________________Reply Separator____________________Subject: Re: Rebuilding database to change block size Author: "Rachel Carmichael" <carmichr_at_hotmail.com> Date: 6/6/00 10:39 AM
Don't skip step 4.. you get errors if the controlfiles exist when you rebuild
7 -- I have a script to generate the create database commands, as well as the init.ora from an existing database. It's in the Annotated Archives, if you have it. Then edit to change what you want.
precreate only the tablespaces you want to change. Oracle will create the others as part of the import.
Oh, and save off any grants that sys has made that are not part of the Oracle-supplied scripts.... or you lose them
Rachel
>From: "Miller, Jay" <JayMiller_at_TDWaterhouse.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Rebuilding database to change block size
>Date: Tue, 06 Jun 2000 08:50:35 -0800
>
>Okay, we finally got enough storage space to hold an export of our
>datawarehouse so I'm going to change the block size from 4 to 16.
>
>Obviously I'm testing this on a small play database first, but I've never
>done this before so I have several questions and would welcome any
>advice/comments/criticisms. Here's what I was thinking of:
>
>1. Do a full export (consistent=y) as sys. Backup control file to trace
>(just as an extra precaution).
>2. Shutdown database.
>3. Cold backup of all files.
>4. Drop all datafiles,control files, redo logs. Any other cleanup
>necessary? Or since the CREATE DATABASE command will erase data in
>existing
>datafiles, can I just skip this step entirely?
>5. Change db_block_size in init.ora file
>6. Start database in NOMOUNT mode.
>
>Here's where I'm on somewhat thinner ice:
>7. Issue create database command. Is there a way to generate this
>automatically from the existing database? It's easy enough to write from
>scratch but I'd rather not take chances with typos if I don't have to.
>8. Change sys and system passwords.
>9. I definitely want to precreate a few tablespaces where I want to change
>the initial extent parameter. Is it necessary to precreate all tablespaces
>and users (I can generate that script very easily)?
>10. Import database as sys.
>
>
>Okay, what am I missing?
>
>Thanks to all,
>Jay
>--
>Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Tue Jun 06 2000 - 13:13:35 CDT
 |
 |