Create Database for Load 
Author Message
 Create Database for Load

We created a database for load that was about 50GB.  The database has
many user defined segments.  After loading the database from a
same-platform dump we got a 6902 error and all of the user segments
were gone.  The database cannot be recovered.  We went through many
procedures to try to recover the datababase, including setting the
database status to -32768 and running dbcc's on the bad/corrupted
table.  We were carefule to duplicate the sysusages table.

I have 2 questions:
        1)  What went wrong?
        2)  Can you load a database in a database that was created for load
and still have all of you user segments in tact, with all objects in
the appropriate segment?

Thanks!

Chuck



Tue, 07 Jul 1998 03:00:00 GMT
 Create Database for Load

Quote:

> We created a database for load that was about 50GB.  The database has
> many user defined segments.  After loading the database from a
> same-platform dump we got a 6902 error and all of the user segments
> were gone.  The database cannot be recovered.  We went through many
> procedures to try to recover the datababase, including setting the
> database status to -32768 and running dbcc's on the bad/corrupted
> table.  We were carefule to duplicate the sysusages table.

> I have 2 questions:
>         1)  What went wrong?
>         2)  Can you load a database in a database that was created for load
> and still have all of you user segments in tact, with all objects in
> the appropriate segment?

> Thanks!

> Chuck

        I have never had a problem with "create database for load".
        Your 6902 error occurs when the server finds a problem with
        the log during recovery. Your comment about a lot of segments
        indicates the cause of the error. Your newly created database
        must exactly mirror the original one or loaded pages will end
        up being loaded into incorrect segments. This is what I suspect
        happened in your case and you ended up with data pages loaded
        into the log space. You will need to use the "alter database
        for load" command in conjunction with the "create database
        for load" command in order to get the segment layouts consistant
        between the two versions of the databases. More than likely
        the original database has a segment layout that resembles this -
        <data segment>, <data segment>, ..., <log segment>, <data  
        segment>, ..., etc.

        Since you only used "create db for load", you would have ended
        up with the log segment being in a different position (ie. at
        the end of the list). So you will need to drop the database and
        try again.

        If you don't quite understand any of this please feel free to
        email me for clarification.

        Good luck,
                Tony.



Fri, 10 Jul 1998 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SS 6.5 problem creating database for load

2. Creating a Database using scripts, and loading initial data from text files

3. Creating a Database for Load

4. ORA-12709 error loading create database character set

5. How to execute a Create table or alter table table everytime before a data load

6. Is there a tool to create large amt of data and load into databas e

7. Loading data created with a different processor type

8. Loading up trace files created using Profiler or C2 audit flag in SQL 2k

9. Newbie: Creating XDS for SQL XML bulk load

10. Any possibility create load-balansing SQL cluster?

11. Creating intial load of sub db


 
Powered by phpBB® Forum Software