Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
6  8305 
Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have had
some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent consistent
state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIE W.COM.TW> wrote in message
news:85******** *************** ***@posting.goo gle.com... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have had
some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent consistent
state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIE W.COM.TW> wrote in message
news:85******** *************** ***@posting.goo gle.com... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
Thanks Steve.
Do you know what is causing this kind of problem? I attempted to
restore the same database with rolling foward, again. The result was
identical to the previous attempt, those same tablespaces were still
offline.
Regards,
T.C. Sheng
"Steve Pearson" <st*******@my-deja.com> wrote in message news:<c7******* ***@hanover.tor olab.ibm.com>.. . Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have had
some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent consistent
state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIE W.COM.TW> wrote in message
news:85******** *************** ***@posting.goo gle.com... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
Thanks Steve.
Do you know what is causing this kind of problem? I attempted to
restore the same database with rolling foward, again. The result was
identical to the previous attempt, those same tablespaces were still
offline.
Regards,
T.C. Sheng
"Steve Pearson" <st*******@my-deja.com> wrote in message news:<c7******* ***@hanover.tor olab.ibm.com>.. . Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have had
some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent consistent
state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIE W.COM.TW> wrote in message
news:85******** *************** ***@posting.goo gle.com... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
I'm not exactly an expert on this area, but...
I would expect repeatable behavior on this. The tablespaces
are likely being marked offline due to the replay of some log record
and each time you try to rollforward through that you will likely
get the same result. I expect there may be some messaging in
the admin log or db2diag.log concerning this.
I don't know what all kinds of operations may have this effect, but
I believe that one example is if one performs a non-logged LOAD
operation and during the recovery there is not a "load copy" file
available to the rollforward, it will mark the tablespace offline.
(Because the load data is not available and was not logged, the
rollforward cannot correctly recovery the tablespace.) I believe
there should be info in the docs about how to repair a tablespace
after such an occurrence if this was the cause.
I expect there are other possible reasons too, but I don't know
any specific details concerning them.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIE W.COM.TW> wrote in message
news:85******** *************** ***@posting.goo gle.com... Thanks Steve.
Do you know what is causing this kind of problem? I attempted to
restore the same database with rolling foward, again. The result was
identical to the previous attempt, those same tablespaces were still
offline.
Regards,
T.C. Sheng
"Steve Pearson" <st*******@my-deja.com> wrote in message
news:<c7******* ***@hanover.tor olab.ibm.com>.. . Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have
had some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent
consistent state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIE W.COM.TW> wrote in message
news:85******** *************** ***@posting.goo gle.com... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
I'm not exactly an expert on this area, but...
I would expect repeatable behavior on this. The tablespaces
are likely being marked offline due to the replay of some log record
and each time you try to rollforward through that you will likely
get the same result. I expect there may be some messaging in
the admin log or db2diag.log concerning this.
I don't know what all kinds of operations may have this effect, but
I believe that one example is if one performs a non-logged LOAD
operation and during the recovery there is not a "load copy" file
available to the rollforward, it will mark the tablespace offline.
(Because the load data is not available and was not logged, the
rollforward cannot correctly recovery the tablespace.) I believe
there should be info in the docs about how to repair a tablespace
after such an occurrence if this was the cause.
I expect there are other possible reasons too, but I don't know
any specific details concerning them.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIE W.COM.TW> wrote in message
news:85******** *************** ***@posting.goo gle.com... Thanks Steve.
Do you know what is causing this kind of problem? I attempted to
restore the same database with rolling foward, again. The result was
identical to the previous attempt, those same tablespaces were still
offline.
Regards,
T.C. Sheng
"Steve Pearson" <st*******@my-deja.com> wrote in message
news:<c7******* ***@hanover.tor olab.ibm.com>.. . Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have
had some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent
consistent state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIE W.COM.TW> wrote in message
news:85******** *************** ***@posting.goo gle.com... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jens Kalkbrenner |
last post by:
MS SQL-Server 7.0
Bypassing recovery for database 'EfW_765' because it is marked IN LOAD.
What does this mean?
Our customer is backing up is maindatabase and is recovering it to this
database for testing.
Our custumer tries it serveral times and then the recovery works and the
data are corrupt.
I have written a little programm which does some selects to this database.
The program is stopped during recovery but our customer beleves that...
|
by: mediodia |
last post by:
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:? :(
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
·"Full Path\Name.MDF is not a primary database file." (This is one of
|
by: andyjgw |
last post by:
Hi
I was in the situation of cloning a SQL server database last night.
Today, a dependent application was behaving a little erratically though
most things were fine after sorting out some ntfs permissions. I've
recovered this database from backup exec before from a hot-backup, this
is the first time I've attempted this procedure though.
Could I check with the experts here as to whether what I did was OK?
Been googling to see if it is...
|
by: T.C. Sheng |
last post by:
Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
|
by: llothar |
last post by:
When i use -W4 on visual c 7.0 i get warning C4054
translator1.c(1703) : warning C4054: 'type cast' : from function
pointer 'void * (__cdecl *)(se_agent *)' to data pointer 'void *'
translator1.c(1703) : warning C4152: nonstandard extension, function/
data pointer conversion in expression
whenever i cast a function pointer to a void* or back.
Is there any reason for this warning ? Looks like good C code for me.
| | |
by: okonita |
last post by:
Hi all, I am running a recover tocopy procedure and twice with different image copy I found this informational message AND no data recovered:
DSNUCBAL - THE IMAGE COPY DATA SET DPDD.IMAG.ANG00001.TS00011S.G0118
IS PARTICIPATING IN RECOVERY OF TABLESPACE ANG00001.TS00011S
DSNUCBMD - MERGE STATISTICS FOR TABLESPACE ANG00001.TS00011S -
NUMBER OF COPIES=1
NUMBER OF PAGES MERGED=154543
ELAPSED...
|
by: Okonita |
last post by:
Hi all, I am running a recover tocopy procedure and twice with
different image copy I found this informational message AND no data
recovered:
DSNUCBAL - THE IMAGE COPY DATA SET DPDD.IMAG.ANG00001.TS00011S.G0118
IS PARTICIPATING IN RECOVERY OF TABLESPACE
ANG00001.TS00011S
DSNUCBMD - MERGE STATISTICS FOR TABLESPACE ANG00001.TS00011S -
NUMBER OF COPIES=1
NUMBER OF PAGES MERGED=154543
|
by: Lexxzy |
last post by:
Hi to all,
I've a problem about to attach a recovered database file in the enterprise manager.
My problem goes this way, I want to attach a recovered database file. So when I followed this steps:
1.) Open enterprise manager.
2.) All task and then attach database.
|
by: Albert |
last post by:
Hi,
i want to send the recovered password using Maildefinition. But i don't find
any "password" to add to the control PasswordRecovery1 as body of the email.
It works but only the username is in the email, not the recovered password.
Any idea how to do that?
thanks
Albert
<asp:PasswordRecovery ID="PasswordRecovery1" runat="server"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
