| 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: Rebuilding database to change block size - PROBLEM
--=====================_336694831==_.ALTContent-Type: text/plain; charset="us-ascii"; format=flowed
shutdown the database even if it is not open. If shutdown won't work, use shutdown abort, and then startup nomount pfile=..., then issue create database command.
> > If I try issuing an ALTER DATABASE OPEN; command I
> > get the error:
> > when attempting to open the database:
> > 01531, 00000, "a database already open by the
> > instance"
> > // *Cause: During ALTER DATABASE, an attempt was
> > made to open
> > // a database on an instance for which there
> > is already
> > // an open database.
> > // *Action: If you wish to open a new database on
> > the instance, first
> > // shutdown the instance and then startup
> > the instance and
> > // retry the operation.
> >
> >
> > But if I try selecting from a dba_ table it tells me
> > the database isn't open
> > and I can only select from fixed tables (which I can
> > with no problems).
> >
> > The ORACLE_SID is set correctly.
> >
> > Any ideas before I restore from backup tomorrow
> > morning and start over?
> > Solaris 2.6, Oracle 8.1.6
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, June 06, 2000 4:22 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Being on 8.1.6 I can change the free list parameter
> > whenever I like :).
> > But your point is well taken and it reminded me that
> > I was intending to
> > seperate my partitioned tables into one ts/partition
> > when I got the chance.
> >
> > -----Original Message-----
> > Sent: Tuesday, June 06, 2000 3:10 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Also check your I/O and see if you have any bottle
> > necks. You could use
> > this as a chance to move tablespaces easily to other
> > file systems. You
> > could move tables to different tablespaces. You can
> > change your free list
> > parameter.
> >
> > You are at a point where you can take a step back
> > and say "What can I change
> > now that I cannot easily change later?"
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, June 06, 2000 1:00 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Jay,
> >
> > I'd take this opportunity to do a little more. What
> > I've done in the past is
> >
> > to pre-create a script to create the tablespaces,
> > database objects, users,
> > etc. That way when you're done, you'll have a
> > script to create the database
> >
> > anytime you want, and you'll have a better feel for
> > your database.
> >
> > Mike
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > Sent: Tuesday, June 06, 2000 11:50 AM
> >
> >
> > > 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
> > >
> >
>--------------------------------------------------------------------
>--------------------------------------------------------------------
>--------------------------------------------------------------------
>--------------------------------------------------------------------
> > >__________________________________________________ >Do You Yahoo!? >Send online invitations with Yahoo! Invites. >http://invites.yahoo.com >-- >Author: A. Bardeen > INET: abardeen1_at_yahoo.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: 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). --=====================_336694831==_.ALTContent-Type: text/html; charset="us-ascii"
<html>
shutdown the database even if it is not open. If shutdown won't work, use
shutdown abort, and then startup nomount pfile=..., then issue create
database command.<br>
<br>
-- janardhana Babu<br>
<br> <br> <br> <blockquote type=cite cite>> If I try issuing an ALTER DATABASE OPEN;command I<br>
> get the error:<br> > when attempting to open the database:<br> > 01531, 00000, "a database already open by the<br> > instance"<br> > // *Cause: During ALTER DATABASE, an attempt was<br> > made to open<br> > // a database on aninstance for which there<br>
> // *Action: If you wish to open a new database on<br> > the instance, first<br> > // shutdownthe instance and then startup<br>
> <br> > <br> > But if I try selecting from a dba_ table it tells me<br> > the database isn't open<br> > and I can only select from fixed tables (which I can<br> > with no problems).<br> > <br> > The ORACLE_SID is set correctly.<br> > <br> > Any ideas before I restore from backup tomorrow<br> > morning and start over?<br> > Solaris 2.6, Oracle 8.1.6<br> > <br> > <br> > -----Original Message-----<br> > Sent: Tuesday, June 06, 2000 4:22 PM<br> > To: Multiple recipients of list ORACLE-L<br> > <br> > <br> > Being on 8.1.6 I can change the free list parameter<br> > whenever I like :).<br> > But your point is well taken and it reminded me that<br> > I was intending to<br> > seperate my partitioned tables into one ts/partition<br> > when I got the chance.<br> > <br> > -----Original Message-----<br> > Sent: Tuesday, June 06, 2000 3:10 PM<br> > To: Multiple recipients of list ORACLE-L<br> > <br> > <br> > <br> > Also check your I/O and see if you have any bottle<br> > necks. You could use<br> > this as a chance to move tablespaces easily to other<br> > file systems. You<br> > could move tables to different tablespaces. You can<br> > change your free list<br> > parameter.<br> > <br> > You are at a point where you can take a step back<br> > and say "What can I change<br> > now that I cannot easily change later?" <br> > <br> > <br> > -----Original Message----- <br> > Sent: Tuesday, June 06, 2000 1:00 PM <br> > To: Multiple recipients of list ORACLE-L <br> > <br> > <br> > Hi Jay, <br> > <br> > I'd take this opportunity to do a little more. What<br> > I've done in the past is<br> > <br> > to pre-create a script to create the tablespaces,<br> > database objects, users, <br> > etc. That way when you're done, you'll have a<br> > script to create the database<br> > <br> > anytime you want, and you'll have a better feel for<br> > your database. <br> > <br> > Mike <br> > <br> > <br> > <br> > <br> > <br> > ----- Original Message ----- <br> > To: Multiple recipients of list ORACLE-L<br> > <ORACLE-L_at_fatcity.com> <br> > Sent: Tuesday, June 06, 2000 11:50 AM <br> > <br> > <br> > > Okay, we finally got enough storage space to hold<br> > an export of our <br> > > datawarehouse so I'm going to change the block<br> > size from 4 to 16. <br> > > <br> > > Obviously I'm testing this on a small play<br> > database first, but I've never <br> > > done this before so I have several questions and<br> > would welcome any <br> > > advice/comments/criticisms. Here's what I was<br> > thinking of: <br> > > <br> > > 1. Do a full export (consistent=y) as sys. <br> > Backup control file to trace <br> > > (just as an extra precaution). <br> > > 2. Shutdown database. <br> > > 3. Cold backup of all files. <br> > > 4. Drop all datafiles,control files, redo logs. <br> > Any other cleanup <br> > > necessary? Or since the CREATE DATABASE command<br> > will erase data in <br> > existing <br> > > datafiles, can I just skip this step entirely? <br> > > 5. Change db_block_size in init.ora file <br> > > 6. Start database in NOMOUNT mode. <br> > > <br> > > Here's where I'm on somewhat thinner ice: <br> > > 7. Issue create database command. Is there away<br>
> to generate this <br> > > automatically from the existing database? It's<br> > easy enough to write from <br> > > scratch but I'd rather not take chances with typos<br> > if I don't have to. <br> > > 8. Change sys and system passwords. <br> > > 9. I definitely want to precreate a few<br> > tablespaces where I want to <br> > change <br> > > the initial extent parameter. Is it necessary to<br> > precreate all <br> > tablespaces <br> > > and users (I can generate that script very<br> > easily)? <br> > > 10. Import database as sys. <br> > > <br> > > <br> > > Okay, what am I missing? <br> > > <br> > > Thanks to all, <br> > > Jay <br> > > -- <br> > > Author: Miller, Jay <br> > > INET: JayMiller_at_TDWaterhouse.com <br> > > <br> > > Fat City Network Services -- (858) 538-5051<br>
> access / Mailing Lists <br> > ><br> ><br> --------------------------------------------------------------------<br> > <br> > > To REMOVE yourself from this mailing list, send an<br> > E-Mail message <br> > > to: ListGuru_at_fatcity.com (note EXACT spelling of<br> > 'ListGuru') and in <br> > > the message BODY, include a line containing: UNSUB<br> > ORACLE-L <br> > > (or the name of mailing list you want to be<br> > removed from). You may <br> > > also send the HELP command for other information<br> > (like subscribing). <br> > <br> > -- <br> > Author: Mike Lanteigne <br> > INET: mikel_at_shec.com <br>> <br>
--------------------------------------------------------------------<br> > <br> > To REMOVE yourself from this mailing list, send an<br> > E-Mail message <br> > to: ListGuru_at_fatcity.com (note EXACT spelling of<br> > 'ListGuru') and in <br> > the message BODY, include a line containing: UNSUB<br> > ORACLE-L <br> > (or the name of mailing list you want to be removed<br> > from). You may <br> > also send the HELP command for other information<br> > (like subscribing). <br> > <br> > -- <br> > Author: Miller, Jay<br> > INET: JayMiller_at_TDWaterhouse.com<br>> <br>
--------------------------------------------------------------------<br> > To REMOVE yourself from this mailing list, send an<br> > E-Mail message<br> > to: ListGuru_at_fatcity.com (note EXACT spelling of<br> > 'ListGuru') and in<br> > the message BODY, include a line containing: UNSUB<br> > ORACLE-L<br> > (or the name of mailing list you want to be removed<br> > from). You may<br> > also send the HELP command for other information<br> > (like subscribing).<br> > -- <br> > Author: Miller, Jay<br> > INET: JayMiller_at_TDWaterhouse.com<br>> <br>
--------------------------------------------------------------------<br> > To REMOVE yourself from this mailing list, send an<br> > E-Mail message<br> > to: ListGuru_at_fatcity.com (note EXACT spelling of<br> > 'ListGuru') and in<br> > the message BODY, include a line containing: UNSUB<br> > ORACLE-L<br> > (or the name of mailing list you want to be removed<br> > from). You may<br>
__________________________________________________<br>Do You Yahoo!?<br>
--------------------------------------------------------------------<br>To REMOVE yourself from this mailing list, send an E-Mail message<br> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<br> the message BODY, include a line containing: UNSUB ORACLE-L<br> (or the name of mailing list you want to be removed from). You may<br>
 |
 |