Discussion:
problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
(too old to reply)
Sergio
2009-10-16 15:44:36 UTC
Permalink
Hi,

I'm facing problems when I'm trying load a dump executed on
ASE 12.5.0.3.

One example is: I created my database exactly like on the
version 12.5.0.3 on 12.5.4 (with separeted devices for data
and log). But after the load, my device used for data was
changed for both data and log.

The platform of the ASE 12.5.0.3 is Solaris 8 and for 12.5.4
is Intel Solaris. I confirmed that this is supported.

So did you any idea about this problem?

Thanks in advance,

Sergio
Mark A. Parsons
2009-10-16 17:07:32 UTC
Permalink
You haven't provided enough details ...

My guess is that either a) your 'create/alter database' commands were not quite correct or b) there is some
fragmentation of devices in the 12.5.4 dataserver which is leading to more, but smaller, fragments in use by your new
database.

I'd suggest you post the results from running the following query in *both* dataservers:

=========================

-- replace <dbname> with the name of your database

select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================
Post by Sergio
Hi,
I'm facing problems when I'm trying load a dump executed on
ASE 12.5.0.3.
One example is: I created my database exactly like on the
version 12.5.0.3 on 12.5.4 (with separeted devices for data
and log). But after the load, my device used for data was
changed for both data and log.
The platform of the ASE 12.5.0.3 is Solaris 8 and for 12.5.4
is Intel Solaris. I confirmed that this is supported.
So did you any idea about this problem?
Thanks in advance,
Sergio
Mark A. Parsons
2009-10-16 17:08:08 UTC
Permalink
Go ahead and also post the 'create/alter database' commands you used to create your new 12.5.4 database.
Post by Mark A. Parsons
You haven't provided enough details ...
My guess is that either a) your 'create/alter database' commands were
not quite correct or b) there is some fragmentation of devices in the
12.5.4 dataserver which is leading to more, but smaller, fragments in
use by your new database.
=========================
-- replace <dbname> with the name of your database
select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================
Post by Sergio
Hi,
I'm facing problems when I'm trying load a dump executed on
ASE 12.5.0.3.
One example is: I created my database exactly like on the
version 12.5.0.3 on 12.5.4 (with separeted devices for data
and log). But after the load, my device used for data was
changed for both data and log.
The platform of the ASE 12.5.0.3 is Solaris 8 and for 12.5.4
is Intel Solaris. I confirmed that this is supported.
So did you any idea about this problem?
Thanks in advance,
Sergio
Sergio
2009-10-16 17:58:47 UTC
Permalink
Hi Mark,

I created the db where I loaded the data just with create
database with one device for data and another with log. The
size was a litle big that the db of the dump.

This is all info that I'm adding.

Best Regards,

Sergio
Post by Mark A. Parsons
Go ahead and also post the 'create/alter database'
commands you used to create your new 12.5.4 database.
Post by Mark A. Parsons
You haven't provided enough details ...
My guess is that either a) your 'create/alter database'
commands were not quite correct or b) there is some
fragmentation of devices in the 12.5.4 dataserver which
is leading to more, but smaller, fragments in use by
your new database.
I'd suggest you post the results from running the
=========================
-- replace <dbname> with the name of your database
select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================
Post by Sergio
Hi,
I'm facing problems when I'm trying load a dump
executed on >> ASE 12.5.0.3.
Post by Mark A. Parsons
Post by Sergio
One example is: I created my database exactly like on
the >> version 12.5.0.3 on 12.5.4 (with separeted devices
for data >> and log). But after the load, my device used
for data was >> changed for both data and log.
Post by Mark A. Parsons
Post by Sergio
The platform of the ASE 12.5.0.3 is Solaris 8 and for
12.5.4 >> is Intel Solaris. I confirmed that this is
supported. >>
Post by Mark A. Parsons
Post by Sergio
So did you any idea about this problem?
Thanks in advance,
Sergio
Mark A. Parsons
2009-10-16 21:00:20 UTC
Permalink
You haven't provided any information that we can use to help you.

If you don't want to provide any additional info (eg, the queries I asked you to run), no problem ...

This is all the suggestions I'm adding.
Post by Sergio
Hi Mark,
I created the db where I loaded the data just with create
database with one device for data and another with log. The
size was a litle big that the db of the dump.
This is all info that I'm adding.
Best Regards,
Sergio
Post by Mark A. Parsons
Go ahead and also post the 'create/alter database'
commands you used to create your new 12.5.4 database.
Post by Mark A. Parsons
You haven't provided enough details ...
My guess is that either a) your 'create/alter database'
commands were not quite correct or b) there is some
fragmentation of devices in the 12.5.4 dataserver which
is leading to more, but smaller, fragments in use by
your new database.
I'd suggest you post the results from running the
=========================
-- replace <dbname> with the name of your database
select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================
Post by Sergio
Hi,
I'm facing problems when I'm trying load a dump
executed on >> ASE 12.5.0.3.
Post by Mark A. Parsons
Post by Sergio
One example is: I created my database exactly like on
the >> version 12.5.0.3 on 12.5.4 (with separeted devices
for data >> and log). But after the load, my device used
for data was >> changed for both data and log.
Post by Mark A. Parsons
Post by Sergio
The platform of the ASE 12.5.0.3 is Solaris 8 and for
12.5.4 >> is Intel Solaris. I confirmed that this is
supported. >>
Post by Mark A. Parsons
Post by Sergio
So did you any idea about this problem?
Thanks in advance,
Sergio
Sergio
2009-10-19 16:34:10 UTC
Permalink
Hi Mark,


As I explained I'm loading information that are comming from
Sybase ASE version Adaptive Server Enterprise/12.5.0.3/EBF
11442 ESD#4/P/Sun_svr4/OS 5.8/rel12503/1939/64-bit/FBO/Sun
Sep 21 05:21:37 2003

I created the database with the create database command
using two devices for data and log.

After the load completion (and online command) I see on the
sp_helpdb output that the log is mixed as you can see
bellow.

1 - the sp_helpdb's output:

1>sp_helpdb gw_oracle
2>go
name db_size owner dbid created status

---- ------- ----- ----------- ------- ------

gw_oracle 4096.0 MB scbonfim 22 Oct 16, 2009 no options set

device_fragments size usage created free kbytes

---------------- ---- ----- ------- -----------

GWORA_DAT01 1024.0 MB data only Oct 16 2009 3:08PM 18816

GWORA_DAT01 1024.0 MB log only Oct 16 2009 3:08PM not
applicable

GWORA_DAT01 512.0 MB data only Oct 16 2009 3:08PM 17044

GWORA_LOG01 488.0 MB data only Oct 16 2009 3:08PM 494534

GWORA_LOG01 1048.0 MB log only Oct 16 2009 3:08PM not
applicable


-

log only free kbytes = 2113436

2 - the log's dump

Oct 16 15:07:58 2009: Backup Server: 6.28.1.1: Dumpfile name
'_oracle092890CB21' section number 1 mounted on disk file
'/sybase125/gw_oracle.dmp'
Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 52424 kilobytes LOADED.
Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 86670 kilobytes LOADED.
Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 138770 kilobytes LOADED.
Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 173462 kilobytes LOADED.
Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 225116 kilobytes LOADED.
Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 259808 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 294500 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 346154 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 380846 kilobytes LOADED.
Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 432822 kilobytes LOADED.
Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 467576 kilobytes LOADED.
Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 519614 kilobytes LOADED.
Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 554306 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 588998 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 640652 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 675344 kilobytes LOADED.
Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 726998 kilobytes LOADED.
Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 761690 kilobytes LOADED.
Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 813728 kilobytes LOADED.
Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 848036 kilobytes LOADED.
Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 882728 kilobytes LOADED.
Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 935150 kilobytes LOADED.
Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 969458 kilobytes LOADED.
Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1021496 kilobytes LOADED.
Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1056188 kilobytes LOADED.
Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1090880 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1142534 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1177226 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1228880 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1263572 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1315610 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1349856 kilobytes LOADED.
Oct 16 15:08:12 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1384610 kilobytes LOADED.
Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1437032 kilobytes LOADED.
Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1471278 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1523378 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1558070 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1609724 kilobytes LOADED.
Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1643264 kilobytes LOADED.
Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1686854 kilobytes LOADED.
Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1730060 kilobytes LOADED.
Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1773266 kilobytes LOADED.
Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1816344 kilobytes LOADED.
Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1859550 kilobytes LOADED.
Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1888482 kilobytes LOADED.
Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1931688 kilobytes LOADED.
Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1981038 kilobytes LOADED.
Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2023794 kilobytes LOADED.
Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2066934 kilobytes LOADED.
Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2108732 kilobytes LOADED.
Oct 16 15:08:21 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2152256 kilobytes LOADED.
Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2195842 kilobytes LOADED.
Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2238982 kilobytes LOADED.
Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2282122 kilobytes LOADED.
Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2321806 kilobytes LOADED.
Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2354194 kilobytes LOADED.
Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2392470 kilobytes LOADED.
Oct 16 15:08:25 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2435610 kilobytes LOADED.
Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2478750 kilobytes LOADED.
Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2521890 kilobytes LOADED.
Oct 16 15:08:27 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2564968 kilobytes LOADED.
Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2608492 kilobytes LOADED.
Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2652078 kilobytes LOADED.
Oct 16 15:08:29 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2695218 kilobytes LOADED.
Oct 16 15:08:30 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2738358 kilobytes LOADED.
Oct 16 15:08:31 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2781498 kilobytes LOADED.
Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2824576 kilobytes LOADED.
Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2868100 kilobytes LOADED.
Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2911686 kilobytes LOADED.
Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2954826 kilobytes LOADED.
Oct 16 15:08:34 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2997966 kilobytes LOADED.
Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3041106 kilobytes LOADED.
Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3062676 kilobytes LOADED.
Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3105688 kilobytes LOADED.
Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3147102 kilobytes LOADED.
Oct 16 15:08:37 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3194468 kilobytes LOADED.
Oct 16 15:08:38 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3235944 kilobytes LOADED.
Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3279084 kilobytes LOADED.
Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3322224 kilobytes LOADED.
Oct 16 15:08:40 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3365302 kilobytes LOADED.
Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3408826 kilobytes LOADED.
Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3452412 kilobytes LOADED.
Oct 16 15:08:42 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3491266 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3526020 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3531150 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 3.42.1.1: LOAD is
complete (database gw_oracle).

3 - the full Sybase ASE version:

Adaptive Server Enterprise/12.5.4/EBF 13395/P/Solaris
AMD64/OS 5.10/ase1254/2006/64-bit/OPT/Sat May 20 00:11:23
2006


If you need more info, please, let me know.

Thanks again,


Sergio
Post by Mark A. Parsons
You haven't provided any information that we can use to
help you.
If you don't want to provide any additional info (eg, the
queries I asked you to run), no problem ...
This is all the suggestions I'm adding.
Post by Sergio
Hi Mark,
I created the db where I loaded the data just with
create database with one device for data and another
with log. The size was a litle big that the db of the
dump.
This is all info that I'm adding.
Best Regards,
Sergio
Post by Mark A. Parsons
Go ahead and also post the 'create/alter database'
commands you used to create your new 12.5.4 database.
Post by Mark A. Parsons
You haven't provided enough details ...
My guess is that either a) your 'create/alter
database' >>> commands were not quite correct or b) there
is some >>> fragmentation of devices in the 12.5.4
dataserver which >>> is leading to more, but smaller,
fragments in use by >>> your new database.
Post by Sergio
Post by Mark A. Parsons
Post by Mark A. Parsons
I'd suggest you post the results from running the
=========================
-- replace <dbname> with the name of your database
select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================
Post by Sergio
Hi,
I'm facing problems when I'm trying load a dump
executed on >> ASE 12.5.0.3.
Post by Mark A. Parsons
Post by Sergio
One example is: I created my database exactly like on
the >> version 12.5.0.3 on 12.5.4 (with separeted
devices >> for data >> and log). But after the load, my
device used >> for data was >> changed for both data and
log. >>>> The platform of the ASE 12.5.0.3 is Solaris 8
and for >> 12.5.4 >> is Intel Solaris. I confirmed that
this is >> supported. >>
Post by Sergio
Post by Mark A. Parsons
Post by Mark A. Parsons
Post by Sergio
So did you any idea about this problem?
Thanks in advance,
Sergio
Mark A. Parsons
2009-10-19 16:57:45 UTC
Permalink
Sergio wrote:
... snip ...
Post by Sergio
If you need more info, please, let me know.
Go back and see what I requested in an earlier post:

... snip ...
Post by Sergio
Post by Mark A. Parsons
I'd suggest you post the results from running the
=========================
-- replace <dbname> with the name of your database
select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================
Sherlock, Kevin [TeamSybase]
2009-10-19 17:58:54 UTC
Permalink
You should post the output that Mark has asked for. He asks for it for a
very good reason.

In that version of ASE (12.5.0.3) the output of sp_help is ordered by device
name, and not the order in which the devices are allocated to the database.

Posting the output of Mark's queries (on your source and destination server)
will get you a resolution quicker than going in circles without them.
Post by Sergio
Hi Mark,
As I explained I'm loading information that are comming from
Sybase ASE version Adaptive Server Enterprise/12.5.0.3/EBF
11442 ESD#4/P/Sun_svr4/OS 5.8/rel12503/1939/64-bit/FBO/Sun
Sep 21 05:21:37 2003
I created the database with the create database command
using two devices for data and log.
After the load completion (and online command) I see on the
sp_helpdb output that the log is mixed as you can see
bellow.
1>sp_helpdb gw_oracle
2>go
name db_size owner dbid created status
---- ------- ----- ----------- ------- ------
gw_oracle 4096.0 MB scbonfim 22 Oct 16, 2009 no options set
device_fragments size usage created free kbytes
---------------- ---- ----- ------- -----------
GWORA_DAT01 1024.0 MB data only Oct 16 2009 3:08PM 18816
GWORA_DAT01 1024.0 MB log only Oct 16 2009 3:08PM not
applicable
GWORA_DAT01 512.0 MB data only Oct 16 2009 3:08PM 17044
GWORA_LOG01 488.0 MB data only Oct 16 2009 3:08PM 494534
GWORA_LOG01 1048.0 MB log only Oct 16 2009 3:08PM not
applicable
-
log only free kbytes = 2113436
2 - the log's dump
Oct 16 15:07:58 2009: Backup Server: 6.28.1.1: Dumpfile name
'_oracle092890CB21' section number 1 mounted on disk file
'/sybase125/gw_oracle.dmp'
Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 52424 kilobytes LOADED.
Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 86670 kilobytes LOADED.
Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 138770 kilobytes LOADED.
Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 173462 kilobytes LOADED.
Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 225116 kilobytes LOADED.
Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 259808 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 294500 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 346154 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 380846 kilobytes LOADED.
Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 432822 kilobytes LOADED.
Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 467576 kilobytes LOADED.
Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 519614 kilobytes LOADED.
Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 554306 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 588998 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 640652 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 675344 kilobytes LOADED.
Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 726998 kilobytes LOADED.
Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 761690 kilobytes LOADED.
Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 813728 kilobytes LOADED.
Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 848036 kilobytes LOADED.
Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 882728 kilobytes LOADED.
Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 935150 kilobytes LOADED.
Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 969458 kilobytes LOADED.
Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1021496 kilobytes LOADED.
Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1056188 kilobytes LOADED.
Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1090880 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1142534 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1177226 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1228880 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1263572 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1315610 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1349856 kilobytes LOADED.
Oct 16 15:08:12 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1384610 kilobytes LOADED.
Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1437032 kilobytes LOADED.
Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1471278 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1523378 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1558070 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1609724 kilobytes LOADED.
Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1643264 kilobytes LOADED.
Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1686854 kilobytes LOADED.
Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1730060 kilobytes LOADED.
Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1773266 kilobytes LOADED.
Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1816344 kilobytes LOADED.
Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1859550 kilobytes LOADED.
Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1888482 kilobytes LOADED.
Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1931688 kilobytes LOADED.
Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1981038 kilobytes LOADED.
Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2023794 kilobytes LOADED.
Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2066934 kilobytes LOADED.
Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2108732 kilobytes LOADED.
Oct 16 15:08:21 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2152256 kilobytes LOADED.
Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2195842 kilobytes LOADED.
Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2238982 kilobytes LOADED.
Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2282122 kilobytes LOADED.
Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2321806 kilobytes LOADED.
Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2354194 kilobytes LOADED.
Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2392470 kilobytes LOADED.
Oct 16 15:08:25 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2435610 kilobytes LOADED.
Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2478750 kilobytes LOADED.
Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2521890 kilobytes LOADED.
Oct 16 15:08:27 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2564968 kilobytes LOADED.
Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2608492 kilobytes LOADED.
Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2652078 kilobytes LOADED.
Oct 16 15:08:29 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2695218 kilobytes LOADED.
Oct 16 15:08:30 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2738358 kilobytes LOADED.
Oct 16 15:08:31 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2781498 kilobytes LOADED.
Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2824576 kilobytes LOADED.
Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2868100 kilobytes LOADED.
Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2911686 kilobytes LOADED.
Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2954826 kilobytes LOADED.
Oct 16 15:08:34 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2997966 kilobytes LOADED.
Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3041106 kilobytes LOADED.
Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3062676 kilobytes LOADED.
Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3105688 kilobytes LOADED.
Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3147102 kilobytes LOADED.
Oct 16 15:08:37 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3194468 kilobytes LOADED.
Oct 16 15:08:38 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3235944 kilobytes LOADED.
Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3279084 kilobytes LOADED.
Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3322224 kilobytes LOADED.
Oct 16 15:08:40 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3365302 kilobytes LOADED.
Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3408826 kilobytes LOADED.
Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3452412 kilobytes LOADED.
Oct 16 15:08:42 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3491266 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3526020 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3531150 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 3.42.1.1: LOAD is
complete (database gw_oracle).
Adaptive Server Enterprise/12.5.4/EBF 13395/P/Solaris
AMD64/OS 5.10/ase1254/2006/64-bit/OPT/Sat May 20 00:11:23
2006
If you need more info, please, let me know.
Thanks again,
Sergio
Post by Mark A. Parsons
You haven't provided any information that we can use to
help you.
If you don't want to provide any additional info (eg, the
queries I asked you to run), no problem ...
This is all the suggestions I'm adding.
Post by Sergio
Hi Mark,
I created the db where I loaded the data just with
create database with one device for data and another
with log. The size was a litle big that the db of the
dump.
This is all info that I'm adding.
Best Regards,
Sergio
Post by Mark A. Parsons
Go ahead and also post the 'create/alter database'
commands you used to create your new 12.5.4 database.
Post by Mark A. Parsons
You haven't provided enough details ...
My guess is that either a) your 'create/alter
database' >>> commands were not quite correct or b) there
is some >>> fragmentation of devices in the 12.5.4
dataserver which >>> is leading to more, but smaller,
fragments in use by >>> your new database.
Post by Sergio
Post by Mark A. Parsons
Post by Mark A. Parsons
I'd suggest you post the results from running the
=========================
-- replace <dbname> with the name of your database
select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================
Post by Sergio
Hi,
I'm facing problems when I'm trying load a dump
executed on >> ASE 12.5.0.3.
Post by Mark A. Parsons
Post by Sergio
One example is: I created my database exactly like on
the >> version 12.5.0.3 on 12.5.4 (with separeted
devices >> for data >> and log). But after the load, my
device used >> for data was >> changed for both data and
log. >>>> The platform of the ASE 12.5.0.3 is Solaris 8
and for >> 12.5.4 >> is Intel Solaris. I confirmed that
this is >> supported. >>
Post by Sergio
Post by Mark A. Parsons
Post by Mark A. Parsons
Post by Sergio
So did you any idea about this problem?
Thanks in advance,
Sergio
Sergio
2009-10-21 13:21:57 UTC
Permalink
Hi,

Thanks for your attencion on this case.

The resolution for this problem is create the database
exactly as the database where we make a dump.

This is all.

Best Regards,


Sergio
Post by Sherlock, Kevin [TeamSybase]
You should post the output that Mark has asked for. He
asks for it for a very good reason.
In that version of ASE (12.5.0.3) the output of sp_help is
ordered by device name, and not the order in which the
devices are allocated to the database.
Posting the output of Mark's queries (on your source and
destination server) will get you a resolution quicker
than going in circles without them.
Post by Sergio
As I explained I'm loading information that are comming
from Sybase ASE version Adaptive Server
Enterprise/12.5.0.3/EBF 11442 ESD#4/P/Sun_svr4/OS
5.8/rel12503/1939/64-bit/FBO/Sun Sep 21 05:21:37 2003
I created the database with the create database command
using two devices for data and log.
After the load completion (and online command) I see on
the sp_helpdb output that the log is mixed as you can
see bellow.
1>sp_helpdb gw_oracle
2>go
name db_size owner dbid created status
---- ------- ----- ----------- ------- ------
gw_oracle 4096.0 MB scbonfim 22 Oct 16, 2009 no options
set >
Post by Sergio
device_fragments size usage created free kbytes
---------------- ---- ----- ------- -----------
GWORA_DAT01 1024.0 MB data only Oct 16 2009 3:08PM 18816
GWORA_DAT01 1024.0 MB log only Oct 16 2009 3:08PM not
applicable
GWORA_DAT01 512.0 MB data only Oct 16 2009 3:08PM 17044
GWORA_LOG01 488.0 MB data only Oct 16 2009 3:08PM 494534
GWORA_LOG01 1048.0 MB log only Oct 16 2009 3:08PM not
applicable
-
log only free kbytes = 2113436
2 - the log's dump
Oct 16 15:07:58 2009: Backup Server: 6.28.1.1: Dumpfile
name '_oracle092890CB21' section number 1 mounted on
disk file '/sybase125/gw_oracle.dmp'
Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 52424 kilobytes LOADED.
Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 86670 kilobytes LOADED.
Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 138770 kilobytes LOADED.
Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 173462 kilobytes LOADED.
Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 225116 kilobytes LOADED.
Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 259808 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 294500 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 346154 kilobytes LOADED.
Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 380846 kilobytes LOADED.
Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 432822 kilobytes LOADED.
Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 467576 kilobytes LOADED.
Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 519614 kilobytes LOADED.
Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 554306 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 588998 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 640652 kilobytes LOADED.
Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 675344 kilobytes LOADED.
Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 726998 kilobytes LOADED.
Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 761690 kilobytes LOADED.
Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 813728 kilobytes LOADED.
Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 848036 kilobytes LOADED.
Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 882728 kilobytes LOADED.
Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 935150 kilobytes LOADED.
Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 969458 kilobytes LOADED.
Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1021496 kilobytes LOADED.
Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1056188 kilobytes LOADED.
Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1090880 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1142534 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1177226 kilobytes LOADED.
Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1228880 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1263572 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1315610 kilobytes LOADED.
Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1349856 kilobytes LOADED.
Oct 16 15:08:12 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1384610 kilobytes LOADED.
Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1437032 kilobytes LOADED.
Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1471278 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1523378 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1558070 kilobytes LOADED.
Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1609724 kilobytes LOADED.
Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1643264 kilobytes LOADED.
Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1686854 kilobytes LOADED.
Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1730060 kilobytes LOADED.
Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1773266 kilobytes LOADED.
Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1816344 kilobytes LOADED.
Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1859550 kilobytes LOADED.
Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1888482 kilobytes LOADED.
Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1931688 kilobytes LOADED.
Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 1981038 kilobytes LOADED.
Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2023794 kilobytes LOADED.
Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2066934 kilobytes LOADED.
Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2108732 kilobytes LOADED.
Oct 16 15:08:21 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2152256 kilobytes LOADED.
Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2195842 kilobytes LOADED.
Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2238982 kilobytes LOADED.
Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2282122 kilobytes LOADED.
Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2321806 kilobytes LOADED.
Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2354194 kilobytes LOADED.
Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2392470 kilobytes LOADED.
Oct 16 15:08:25 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2435610 kilobytes LOADED.
Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2478750 kilobytes LOADED.
Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2521890 kilobytes LOADED.
Oct 16 15:08:27 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2564968 kilobytes LOADED.
Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2608492 kilobytes LOADED.
Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2652078 kilobytes LOADED.
Oct 16 15:08:29 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2695218 kilobytes LOADED.
Oct 16 15:08:30 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2738358 kilobytes LOADED.
Oct 16 15:08:31 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2781498 kilobytes LOADED.
Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2824576 kilobytes LOADED.
Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2868100 kilobytes LOADED.
Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2911686 kilobytes LOADED.
Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2954826 kilobytes LOADED.
Oct 16 15:08:34 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 2997966 kilobytes LOADED.
Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3041106 kilobytes LOADED.
Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3062676 kilobytes LOADED.
Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3105688 kilobytes LOADED.
Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3147102 kilobytes LOADED.
Oct 16 15:08:37 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3194468 kilobytes LOADED.
Oct 16 15:08:38 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3235944 kilobytes LOADED.
Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3279084 kilobytes LOADED.
Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3322224 kilobytes LOADED.
Oct 16 15:08:40 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3365302 kilobytes LOADED.
Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3408826 kilobytes LOADED.
Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3452412 kilobytes LOADED.
Oct 16 15:08:42 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3491266 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3526020 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
gw_oracle: 3531150 kilobytes LOADED.
Oct 16 15:08:43 2009: Backup Server: 3.42.1.1: LOAD is
complete (database gw_oracle).
Adaptive Server Enterprise/12.5.4/EBF 13395/P/Solaris
AMD64/OS 5.10/ase1254/2006/64-bit/OPT/Sat May 20
00:11:23 2006
If you need more info, please, let me know.
Thanks again,
Sergio
Post by Mark A. Parsons
You haven't provided any information that we can use to
help you.
If you don't want to provide any additional info (eg,
the >> queries I asked you to run), no problem ...
Post by Sergio
Post by Mark A. Parsons
This is all the suggestions I'm adding.
Post by Sergio
Hi Mark,
I created the db where I loaded the data just with
create database with one device for data and another
with log. The size was a litle big that the db of the
dump.
This is all info that I'm adding.
Best Regards,
Sergio
Post by Mark A. Parsons
Go ahead and also post the 'create/alter database'
commands you used to create your new 12.5.4
database. >> >>
Post by Sergio
Post by Mark A. Parsons
Post by Sergio
Post by Mark A. Parsons
Post by Mark A. Parsons
You haven't provided enough details ...
My guess is that either a) your 'create/alter
database' >>> commands were not quite correct or b)
there >> is some >>> fragmentation of devices in the
12.5.4 >> dataserver which >>> is leading to more, but
smaller, >> fragments in use by >>> your new database.
Post by Sergio
Post by Mark A. Parsons
Post by Sergio
Post by Mark A. Parsons
Post by Mark A. Parsons
I'd suggest you post the results from running the
=========================
-- replace <dbname> with the name of your database
select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================
Post by Sergio
Hi,
I'm facing problems when I'm trying load a dump
executed on >> ASE 12.5.0.3.
Post by Mark A. Parsons
Post by Sergio
One example is: I created my database exactly like
on >> >> the >> version 12.5.0.3 on 12.5.4 (with separeted
Post by Sergio
Post by Mark A. Parsons
devices >> for data >> and log). But after the load, my
device used >> for data was >> changed for both data
and >> log. >>>> The platform of the ASE 12.5.0.3 is
Solaris 8 >> and for >> 12.5.4 >> is Intel Solaris. I
confirmed that >> this is >> supported. >>
Post by Sergio
Post by Mark A. Parsons
Post by Sergio
Post by Mark A. Parsons
Post by Mark A. Parsons
Post by Sergio
So did you any idea about this problem?
Thanks in advance,
Sergio
Loading...