Discussion:
Device allocation after load
(too old to reply)
unknown
2006-02-25 07:37:16 UTC
Permalink
This is the situation:

I took a dump of my database database and dropped the
database and its devices. I then created a new database with
a different device structure but the same size as the
original. On Loading the dump to the new database, the
database allocation in the devices was distorted. eg some
log and data on the same device etc.
How would you load into the new database without affecting
the database allocation structure in the devices

Martin
Mark K
2006-03-02 06:13:45 UTC
Permalink
You can't and you shouldn't. The layout of the target database should be the
same as the source, or some bad things can happen.

Mark Kusma
http://www.sybase.com/support/aboutsupport/otherservices
Post by unknown
I took a dump of my database database and dropped the
database and its devices. I then created a new database with
a different device structure but the same size as the
original. On Loading the dump to the new database, the
database allocation in the devices was distorted. eg some
log and data on the same device etc.
How would you load into the new database without affecting
the database allocation structure in the devices
Martin
Sherlock, Kevin
2006-03-02 23:52:53 UTC
Permalink
and as mentioned in an earlier thread, you don't need to create log segments on
the target database, just create the fragments in the same order, but they can
be mixed data and log when you create the target database. The restore will fix
up the segment mappings in sysusages after the restore is done.
Post by Mark K
You can't and you shouldn't. The layout of the target database should be the
same as the source, or some bad things can happen.
Mark Kusma
http://www.sybase.com/support/aboutsupport/otherservices
Post by unknown
I took a dump of my database database and dropped the
database and its devices. I then created a new database with
a different device structure but the same size as the
original. On Loading the dump to the new database, the
database allocation in the devices was distorted. eg some
log and data on the same device etc.
How would you load into the new database without affecting
the database allocation structure in the devices
Martin
unknown
2006-03-03 13:53:42 UTC
Permalink
Thankyou for that information.

Speaking of dumps, is it possible to take a dump of a
database and leave out certain database objects such as a
table. if possible, how can you do it.

Regards,

Martin
Post by Sherlock, Kevin
and as mentioned in an earlier thread, you don't need to
create log segments on the target database, just create
the fragments in the same order, but they can be mixed
data and log when you create the target database. The
restore will fix up the segment mappings in sysusages
after the restore is done.
Post by Mark K
shouldn't. The layout of the target database should be
the same as the source, or some bad things can happen. >
Post by Mark K
Mark Kusma
http://www.sybase.com/support/aboutsupport/otherservices
the situation: >
Post by unknown
I took a dump of my database database and dropped the
database and its devices. I then created a new
database with a different device structure but the
same size as the original. On Loading the dump to the
new database, the database allocation in the devices
was distorted. eg some log and data on the same device
etc. How would you load into the new database without
affecting the database allocation structure in the
devices >
Post by unknown
Martin
Sherlock, Kevin
2006-03-06 18:46:02 UTC
Permalink
Not using the Sybase backup server dumps. You get a physical page-for-page dump
of the database. You can not exclude objects from those dumps.
Post by unknown
Thankyou for that information.
Speaking of dumps, is it possible to take a dump of a
database and leave out certain database objects such as a
table. if possible, how can you do it.
Regards,
Martin
Post by Sherlock, Kevin
and as mentioned in an earlier thread, you don't need to
create log segments on the target database, just create
the fragments in the same order, but they can be mixed
data and log when you create the target database. The
restore will fix up the segment mappings in sysusages
after the restore is done.
Post by Mark K
shouldn't. The layout of the target database should be
the same as the source, or some bad things can happen. >
Post by Mark K
Mark Kusma
http://www.sybase.com/support/aboutsupport/otherservices
the situation: >
Post by unknown
I took a dump of my database database and dropped the
database and its devices. I then created a new
database with a different device structure but the
same size as the original. On Loading the dump to the
new database, the database allocation in the devices
was distorted. eg some log and data on the same device
etc. How would you load into the new database without
affecting the database allocation structure in the
devices >
Post by unknown
Martin
Bret Halford
2006-03-06 22:45:59 UTC
Permalink
You can, however, take that dump, load it into another database,
drop all the objects you don't want included, then dump again.

-bret
Post by Sherlock, Kevin
Not using the Sybase backup server dumps. You get a physical page-for-page dump
of the database. You can not exclude objects from those dumps.
Post by unknown
Thankyou for that information.
Speaking of dumps, is it possible to take a dump of a
database and leave out certain database objects such as a
table. if possible, how can you do it.
Regards,
Martin
Post by Sherlock, Kevin
and as mentioned in an earlier thread, you don't need to
create log segments on the target database, just create
the fragments in the same order, but they can be mixed
data and log when you create the target database. The
restore will fix up the segment mappings in sysusages
after the restore is done.
Post by Mark K
shouldn't. The layout of the target database should be
the same as the source, or some bad things can happen. >
Post by Mark K
Mark Kusma
http://www.sybase.com/support/aboutsupport/otherservices
the situation: >
Post by unknown
I took a dump of my database database and dropped the
database and its devices. I then created a new
database with a different device structure but the
same size as the original. On Loading the dump to the
new database, the database allocation in the devices
was distorted. eg some log and data on the same device
etc. How would you load into the new database without
affecting the database allocation structure in the
devices >
Post by unknown
Martin
Sherlock, Kevin
2006-03-07 21:01:25 UTC
Permalink
Yes. :()
Post by Bret Halford
You can, however, take that dump, load it into another database,
drop all the objects you don't want included, then dump again.
-bret
Post by Sherlock, Kevin
Not using the Sybase backup server dumps. You get a physical page-for-page dump
of the database. You can not exclude objects from those dumps.
Post by unknown
Thankyou for that information.
Speaking of dumps, is it possible to take a dump of a
database and leave out certain database objects such as a
table. if possible, how can you do it.
Regards,
Martin
Post by Sherlock, Kevin
and as mentioned in an earlier thread, you don't need to
create log segments on the target database, just create
the fragments in the same order, but they can be mixed
data and log when you create the target database. The
restore will fix up the segment mappings in sysusages
after the restore is done.
Post by Mark K
shouldn't. The layout of the target database should be
the same as the source, or some bad things can happen. >
Post by Mark K
Mark Kusma
http://www.sybase.com/support/aboutsupport/otherservices
the situation: >
Post by unknown
I took a dump of my database database and dropped the
database and its devices. I then created a new
database with a different device structure but the
same size as the original. On Loading the dump to the
new database, the database allocation in the devices
was distorted. eg some log and data on the same device
etc. How would you load into the new database without
affecting the database allocation structure in the
devices >
Post by unknown
Martin
Loading...