SQL Anywhere database - Another problem with dbspaces

Author

Another problem with dbspaces

Jon Springs

2005-04-18, 11:23 am

I created a separate dbspace 'dbspace1', populated it, had a problem with it
and created a second dbspace 'dbspace2'. All goes well with 'dbspace2' so I
delete the file 'dbspace1.db'.

Now, I start up the server (service won't start, I suspect because of
missing 'dbspace1') and it tells me it can't find 'dbspace1' but comes up
anyway. All is well.

Now I try to backup up database. Won't work because of missing 'dbspace1'.

Question? How do I now get rid of 'dbspace1'?

Thanks,

-----Jon Springs-----

Alex Whitney

2005-04-18, 1:23 pm

You have to drop the dbspace from the database before deleting the actual
file.

Do you have a backup of the original dbspace that was deleted? If you do,
then restore the file and then drop it form the DB. If you don't have it, a
unload/reload cycle of the DB will get you back to where you need to be.

Alex
"Jon Springs" <jsprings@jontanshe.org> wrote in message
news:4263e01a$1@foru
ms-2-dub...
> I created a separate dbspace 'dbspace1', populated it, had a problem with
it
> and created a second dbspace 'dbspace2'. All goes well with 'dbspace2' so
I
> delete the file 'dbspace1.db'.
>
> Now, I start up the server (service won't start, I suspect because of
> missing 'dbspace1') and it tells me it can't find 'dbspace1' but comes up
> anyway. All is well.
>
> Now I try to backup up database. Won't work because of missing 'dbspace1'.
>
> Question? How do I now get rid of 'dbspace1'?
>
> Thanks,
>
> -----Jon Springs-----
>
>

Jon Springs

2005-04-18, 8:23 pm

There has to be another way, this database is 60gb.

Thanks,

-----Jon-----

"Alex Whitney" <alexw55@pdq.net> wrote in message
news:4263edea$1@foru
ms-2-dub...
> You have to drop the dbspace from the database before deleting the actual
> file.
>
> Do you have a backup of the original dbspace that was deleted? If you do,
> then restore the file and then drop it form the DB. If you don't have it,
> a
> unload/reload cycle of the DB will get you back to where you need to be.
>
> Alex
> "Jon Springs" <jsprings@jontanshe.org> wrote in message
> news:4263e01a$1@foru
ms-2-dub...
> it
> I
>
>

Rob Waywell

2005-04-19, 7:23 am

What version and build number?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Jon Springs" <jsprings@jontanshe.org> wrote in message
news:426409f9$1@foru
ms-2-dub...
> There has to be another way, this database is 60gb.
>
> Thanks,
>
> -----Jon-----
>
> "Alex Whitney" <alexw55@pdq.net> wrote in message
> news:4263edea$1@foru
ms-2-dub...
actual[color=darkred
]
do,[color=darkred]
it,[color=darkred]
with[color=darkred]
so[color=darkred]
up[color=darkred]
>
>

Jon Springs

2005-04-19, 1:23 pm

Rob,

ASA9 build 9.0.2.3044.

Thanks,

-----Jon-----

"Rob Waywell" <rwaywell@no_spam.ianywhere.com> wrote in message
news:4264f602$1@foru
ms-2-dub...
> What version and build number?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> Developer Community at www.ianywhere.com/developer
> "Jon Springs" <jsprings@jontanshe.org> wrote in message
> news:426409f9$1@foru
ms-2-dub...
> actual
> do,
> it,
> with
> so
> up
>
>

John Smirnios

2005-04-19, 8:23 pm

ASA tries to allow you to drop a dbspace even if it cannot open the
file; however, to do that you must get the database started. If the
server won't start, it is probably because it is going through recovery.
Try renaming your log file to any other name and starting with '-f'
(note that the server will then shut itself down automatically and then
you must start it without '-f').

If the server still won't start, there may be undo operations referring
to the lost dbspace. In that case, you may have to resort to using the
'-ho' switch (also known as -O) which is a hidden switch which should
avoid applying undo operations. **WARNING** I don't recommend using this
switch AT ALL because it can leave your database in an inconsistent
state! If you use it, you should (at the very least) run dbvalid to
check your database. Even better would be to unload/reload.

If you can get your server started, you should be able to execute DROP
DBSPACE dbspace1.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Jon Springs wrote:

> Rob,
>
> ASA9 build 9.0.2.3044.
>
> Thanks,
>
> -----Jon-----
>
> "Rob Waywell" <rwaywell@no_spam.ianywhere.com> wrote in message
> news:4264f602$1@foru
ms-2-dub...
>
>
>

Rob Waywell

2005-04-20, 9:23 am

Hi Jon,
At that version you should be able to start the database and then run
the ALTER DBSPACE command to tell the database where it can now find that
dbspace. What happens when you try that?

I would suggest that since you are in a recovery situation (or perhaps
salvage by this point) that you open a case with Tech Support to work with
you directly in determining the best approach to resolving your issue.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Jon Springs" <jsprings@jontanshe.org> wrote in message
news:42653b88$1@foru
ms-2-dub...
> Rob,
>
> ASA9 build 9.0.2.3044.
>
> Thanks,
>
> -----Jon-----
>
> "Rob Waywell" <rwaywell@no_spam.ianywhere.com> wrote in message
> news:4264f602$1@foru
ms-2-dub...
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug[color=darkred]
'dbspace2'[color=dar
kred]
of[color=darkred]
comes[color=darkred]

>
>

Sponsored Links