load from 12.5 dump file to 15.0.3
andkylee
i saw from one article that cross-platform dump/load on the same
processor-architecture was supported.So,i got the dump file from ASE12.5 and
loaded it to ASE15.no problem with the process of Loading DB.But,i could not
bring the database online. Here is the details:
the original ASE:
----------------------------------------------------------------------------------------
Adaptive Server Enterprise/12.5/SWR 9616 GA/P/NT (IX86)/OS
4.0/main/1647/32-bit/
OPT/Fri Jun 01 16:58:25 2001
Character Set:iso_1
Pagesize:2K
the destination ASE:
----------------------------------------------------------------------------------------
Adaptive Server Enterprise/15.0.3/EBF 16550 ESD#1/P/NT (IX86)/Windows
2003/ase1
503/2680/32-bit/OPT/Thu Mar 05 00:21:40 2009
Character Set:iso_1
Pagesize:2K
After the loading process,i restarted the ASE,the error log as follows:
00:00000:00001:2009/11/29 23:34:10.43 server Database 'escourt5',
checkpoint=(138947, 6), first=(138947, 6), last=(138947, 6).
00:00000:00001:2009/11/29 23:34:10.43 server Completed estimating recovery
log boundaries for database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.43 server Started ANALYSIS pass for
database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.43 server Completed ANALYSIS pass for
database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.43 server Log contains all committed
transactions until 2009/11/29 23:16:58.67 for database escourt5.
00:00000:00001:2009/11/29 23:34:10.43 server Started REDO pass for database
'escourt5'. The total number of log records to process is 1.
00:00000:00001:2009/11/29 23:34:10.45 server Completed REDO pass for
database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.45 server Recovery of database
'escourt5' will undo incomplete nested top actions.
00:00000:00001:2009/11/29 23:34:10.45 server Started recovery checkpoint
for database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.45 server Completed recovery checkpoint
for database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.45 server Started filling free space
info for database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.54 server Completed filling free space
info for database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.54 server Started cleaning up the
default data cache for database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.54 server Completed cleaning up the
default data cache for database 'escourt5'.
00:00000:00001:2009/11/29 23:34:10.54 server Checking external objects.
00:00000:00001:2009/11/29 23:34:10.56 server Database 'escourt5' appears to
be at an older revision than the present installation; ASE will assess it,
and upgrade it as required.
00:00000:00001:2009/11/29 23:34:10.59 server Database 'escourt5': beginning
upgrade step [ID 2]: validate basic system type data
00:00000:00001:2009/11/29 23:34:10.65 server Database 'escourt5': beginning
upgrade step [ID 7]: insert rows into syspartitions for each system
table and index
00:00000:00001:2009/11/29 23:34:10.65 server Error: 8204, Severity: 20,
State: 5
00:00000:00001:2009/11/29 23:34:10.65 server Expected to receive system
catalog id. Instead 108 was received.
00:00000:00001:2009/11/29 23:34:10.67 server Error: 3454, Severity: 20,
State: 1
00:00000:00001:2009/11/29 23:34:10.67 server Database 'escourt5': ASE could
not completely upgrade this database; upgrade item 1331 could not be
installed.
00:00000:00001:2009/11/29 23:34:10.67 server ASE could not bring database
'escourt5' online.
00:00000:00001:2009/11/29 23:34:10.68 server Recovery has restored the
value of 'local async prefetch limit' for '16K' pool in 'default data cache'
from '80' to 'DEFAULT'.
00:00000:00001:2009/11/29 23:34:10.68 server Recovery has restored the
value of 'local async prefetch limit' for '2K' pool in 'default data cache'
from '80' to 'DEFAULT'.
00:00000:00001:2009/11/29 23:34:10.68 server background task error 17260:
Can't run sp_poolconfig from within a transaction.
00:00000:00001:2009/11/29 23:34:10.68 server Recovery has restored the
original size for '16K' pool and '2K' pool in 'default data cache'.
00:00000:00001:2009/11/29 23:34:10.68 server Recovery complete.
00:00000:00001:2009/11/29 23:34:10.68 kernel Reenlistment of DTC
Transactions Complete
00:00000:00001:2009/11/29 23:34:10.68 server ASE's default unicode sort
order is 'binary'.
00:00000:00001:2009/11/29 23:34:10.68 server ASE's default sort order is:
00:00000:00001:2009/11/29 23:34:10.68 server 'bin_iso_1' (ID = 50)
00:00000:00001:2009/11/29 23:34:10.68 server on top of default character
set:
00:00000:00001:2009/11/29 23:34:10.68 server 'iso_1' (ID = 1).
00:00000:00001:2009/11/29 23:34:10.68 server Master device size: 30
megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00000:2009/11/29 23:34:11.74 kernel Cannot get value First Counter
from Performance registry key.
00:00000:00000:2009/11/29 23:34:11.74 kernel Cannot get value Last Counter
from Performance registry key.
00:00000:00000:2009/11/29 23:34:11.74 kernel Cannot get value First Help
from Performance registry key.
00:00000:00000:2009/11/29 23:34:11.74 kernel Cannot get value Last Help
from Performance registry key.
00:00000:00016:2009/11/29 23:35:57.95 server Error: 8204, Severity: 20,
State: 5
00:00000:00016:2009/11/29 23:35:57.95 server Expected to receive system
catalog id. Instead 108 was received.
00:00000:00016:2009/11/29 23:35:57.95 server Error: 3454, Severity: 20,
State: 1
00:00000:00016:2009/11/29 23:35:57.95 server Database 'escourt5': ASE could
not completely upgrade this database; upgrade item 1331 could not be
installed.
Once the ASE15.0.3 started,i manually brought the DB online. Here is the
error messages:
1> online database escourt5
2> go
Database 'escourt5' appears to be at an older revision than the present
installation; ASE will assess it, and upgrade it as required.
Database 'escourt5': beginning upgrade step [ID 2]: validate basic
system
type data
Database 'escourt5': beginning upgrade step [ID 7]: insert rows into
syspartitions for each system table and index
Msg 8204, Level 20, State 5:
Server 'WIN2003SERVER_2K', Line 1:
Expected to receive system catalog id. Instead 108 was received.
Msg 3454, Level 20, State 1:
Server 'WIN2003SERVER_2K', Line 1:
Database 'escourt5': ASE could not completely upgrade this database; upgrade
item 1331 could not be installed.
ASE could not bring database 'escourt5' online.
1> select @@trancount
2> go
-----------
1
(1 row affected)
1> commit
2> go
1> dbcc traceon(3604)
2> go
DBCC execution completed. If DBCC printed error messages, contact a user
with
System Administrator (SA) role.
1> dbcc rebuild_log(escourt5,1,1)
2> go
This utility can only be run on a database that has been placed in special
recovery bypass mode
DBCC execution completed. If DBCC printed error messages, contact a user
with
System Administrator (SA) role.
1> dbcc rebuild_log(escourt5,1,0)
2> go
This utility can only be run on a database that has been placed in special
recovery bypass mode
DBCC execution completed. If DBCC printed error messages, contact a user
with
System Administrator (SA) role.
1> dbcc rebuild_log(escourt5,0,0)
2> go
Failed attempt to remove old log extents
DBCC execution completed. If DBCC printed error messages, contact a user
with
System Administrator (SA) role.
1> dbcc rebuild_log(escourt5,0,1)
2> go
This utility can only be run on a database that has been placed in special
recovery bypass mode
DBCC execution completed. If DBCC printed error messages, contact a user
with
System Administrator (SA) role.
1> dbcc rebuild_log(escourt5,1,1)
2> go
This utility can only be run on a database that has been placed in special
recovery bypass mode
DBCC execution completed. If DBCC printed error messages, contact a user
with
System Administrator (SA) role.
thanks for any suggestion!
Manoj
Cross platform dump & load of transaction log is not supported. Before
taking database dump from source, ensure there is no transaction to roll
forward or roll backward in destination database.
regards
Manoj
"andkylee" <andk...@gmail.com> wrote in message
news:4b129afc@forums-1-dub...
John Flynn
> Cross platform dump & load of transaction log is not supported.
Seems to me he is not doing a cross-platform dump and load. He's dumping
12.5 and loading into 15.0.3, but same platform.
Mark A. Parsons
a database).
In one case it's recommended to increase the number of database/object/index/partition descriptors in the dataserver
(eg, make sure the 15.0.3 dataserver has at least as many database/object/index descriptors as the 12.5 dataserver, then
make sure the 15.0.3 dataserver also has a partition descriptor count equal to (object + index).)
A couple other cases mention an issue with a builtin function being called with an invalid object id ... but that issue
was supposedly fixed in ASE 12.5.4.
One other case mentions the possibility of database corruption. You could try running a full set of dbcc's on the
source to see if there are any issues; if so, fix said issues prior to performing the dump. (I'd start with a quick run
of 'dbcc checkcatalog' to see if there are any orphan id's in the system tables.)
I'd recommend you contact Sybase TechSupport for assistance; they may be able to find a case that more closely matches
your situation.
vivekkak
Hello ,
I had faced similar issues when I tried to upgrade a legacy
system. Can you ensure that dbcc is clean in original 12.x
environment , especially checkcatalog. I had some
corruptions reported which I had overlooked initially. Also
are you using any user defined datatypes in your
environment. If yes, ensure that they are not keywords in
15.x.
HTH,
Vivek
andkylee
some DBCC works before dump the older ASE DB(in my case is ASE12.5).I missed
this database consistency checking job,wondering if this was the causes.
There was no any user defined datatypes!
I will try doing DBCC before dump db.
<Vivek Kak> д����Ϣ����:4b2852cf.201...@sybase.com...