DBspace temp1 down after restore
Posted in 2009
Topics: Backup & Restore, Storage & Space Management, Server Administration, Logging & Checkpoints, Platform-Specific Issues
Hi Guys,
had some troubles with power and lost some disks last night.
Running 9.40 FC7 on Solaris.
There were some I/O errors and 3 chunks were down.
For the moment a restore (onbar -r) is still running (could salvage the
current logical log), but I wonder what will happen when the restore is
finished.
The dbspace temp1 was down, and there is no backup for this temporary dbspace.
What's the best way to get rid of this ?
Patch it online with onspaces -s temp1 -p /xxxxxx -o 0 -O
or remove it from the config file, startup again and add a new temp1 dbspace
on the same location ?
Or will it come online again automatically ?
Thx,
Best regards,
JAcques Lapeire
If the physical and logical disks are actually OK, your restore should bring
all chunks back to online mode. If they are not, then the restore will
fail. If only the tempdb space is physically bad, you may not know until
you try to write to it.
Art
On Tue, Feb 24, 2009 at 7:52 AM, JACQUES LAPEIRE <
jacques.lapeire@fujitsu-siemens.com> wrote:
> Hi Guys,
>
> had some troubles with power and lost some disks last night.
> Running 9.40 FC7 on Solaris.
>
> There were some I/O errors and 3 chunks were down.
> For the moment a restore (onbar -r) is still running (could salvage the
> current logical log), but I wonder what will happen when the restore is
> finished.
>
> The dbspace temp1 was down, and there is no backup for this temporary
> dbspace.
> What's the best way to get rid of this ?
>
> Patch it online with onspaces -s temp1 -p /xxxxxx -o 0 -O
> or remove it from the config file, startup again and add a new temp1
> dbspace
> on the same location ?
> Or will it come online again automatically ?
>
> Thx,
> Best regards,
> JAcques Lapeire
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
--00163631059d0ac3400463abce2a