We have done some testing with mixed and forgotten results. So I'm
hoping that asking here can clarify some issues for us. Right now we do
one weekly warm backup. Throughout the week there are multiple
unrecoverable loads. We are tyring to come up with the best backup
strategy for this system? It is a large dev data warehouse.
What happens when a table is loaded unrecoverable and then we need to
restore (no DDL has been done)? Can we recover using our last warm
backup if we rollforward just to before the load?
What about a table in a multi-table tablespace, what happens to other
tables? We have found that after an unrecoverable load the only thing
we can do is drop the table but most times the table is one of many.
What happens in a multi-partition environment? Let's say our table is
across 2 partitions?
What if we have a tablespace backup taken right after the unrecoverable
load but before the next full backup, can we do a restore then? How?
What happens to the backup with the unrecoverable load is happening at
the same time as the backup?
Thanks for any comment,
DBAGIRLTX 1 3828
Well, I guess you are living in intresting times !!!
See below. ######
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"dbagirltx" <db*******@yaho o.com> a écrit dans le message de news: 11************* *********@b68g2 00...legr oups.com... We have done some testing with mixed and forgotten results. So I'm hoping that asking here can clarify some issues for us. Right now we do one weekly warm backup. Throughout the week there are multiple unrecoverable loads. We are tyring to come up with the best backup strategy for this system? It is a large dev data warehouse.
What happens when a table is loaded unrecoverable and then we need to restore (no DDL has been done)? Can we recover using our last warm backup if we rollforward just to before the load?
#######
It does not matter whether DDl has been done. You cannot do a tablespace
restore/rollforward prior to drop.
You have to a full db restore/ rollforward to Point in Tine prior to drop.
Extract ddl and data the inactive objct in tablespace. Then re restore the
full db, roll it forward to end of logs which is through the load, drop the
inactive nonrecoverable load table, and then use extracted ddl and data to
reconstruct. What about a table in a multi-table tablespace, what happens to other tables? We have found that after an unrecoverable load the only thing we can do is drop the table but most times the table is one of many.
#######
See above, The pint is that a nonrecoverable load brings the minimum PIT of
the tablespace to the timestamp of the load. From that point on the
tablespace can only be recovered at leas to that minimum PIT but not before
it.
Method 1 above answers to protecting the other tables in the tablespace as
the second restore/rollforward will put them consistent with the db and also
the inactive table is then dropped and rebuilt. What happens in a multi-partition environment? Let's say our table is across 2 partitions?
#######
I believe that because the tabvlespace which has the table is on more than
one partition, you would have to apply the step above to all partutions on
which the tablespace is defined. What if we have a tablespace backup taken right after the unrecoverable load but before the next full backup, can we do a restore then? How?
#######
In this case, your strategy becomes:
Resotre the image taken after the unrecoverable load and roll it forward as
as you need, iff you only want to recover it.
For a full db restore where theimage of the db is prior to the unrecoverable
load, thwen your strategy is as follows:
restore the full db
restore the tablespace image taken after the unrecoverable load
roll forward the whole db to the end of the logs.
As the tablespace has been restored it is consistent as of the time of its
backup. The roll forward will ignore any transaction for that table space
which precedes the timestamp of the restored image. What happens to the backup with the unrecoverable load is happening at the same time as the backup?
#######
If tyou are executing a load on a table, the db puts the tablespace in load
pending or other states as the load progress. For a tablespace to be backed
up it "must" be in normal state so the backup request will not launch.
Similarly, if the tablespace backup is launched the load command will bounce
so that the two cannot ever happen concurrently. Thanks for any comment, DBAGIRLTX
HTH, Pierre. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Vincento Harris |
last post by:
I implement manual log shipping per
http://www.sql-server-performance.com/sql_server_log_shipping.asp
Full Backups are configured to overwrite current backups(backup with
init)
The process works great till any scheduled backup takes place then
all transaction log restores fail.
i.e After the first database backup transaction log backups work till
the next database backup.
|
by: Rob Oldfield |
last post by:
The other day I restarted my machine and suddenly couldn't open any of my
existing VB.Net projects. I reinstalled the (1.1) framework and got around
that one.... but....
Since then, if I try to build a setup project I'm getting "unrecoverable
build error" from VS.Net. I've tried repairing my VS.Net and installing the
SDK installer 2.0 but am still getting the same error.
Any suggestions very welcome as I'm completely scr*wed at the...
|
by: JS |
last post by:
EE instance DB2 v7.2.0 fixpack 3 on WIN2K.
I select some data from a table A and write it to a file using the COALESCE
function and whitespace as the null character:
eg coalesce(col1, ' '). This column has 10,000 nulls in table A.
Select count(*) from table A where col1 is null=10,000
Using the load utlity, I load the data file as follows into table B which
has not null constraint on col1:
LOAD FROM LOAD.TEST OF ASC
MODIFIED BY...
|
by: Wenhai Fu |
last post by:
Hi, guys,
I am practicing the setup wizard of VC.Net. When I build the setup project,
I am always told "unrecoverable build error". I really have no clue what's
going on here.
I tried this on W2K and windows XP. Start the setup wizard, select the setup
for a windows application, and include the release .exe file, and then
build. I think this is all I need to do.
Anybody can tell me what's going on here?
Thanks a lot for your attention....
|
by: Stormy |
last post by:
when I compile my program I get "fatal error C1506: unrecoverable block
scoping error". Can anyone tell me why? Thank you very much in advance.
namespace unManaged
{
template<class L>
class Mytemplate : public myUnManagedClassA
{
};
| |
by: Schoo |
last post by:
I was working in VS creating web pages and testing them in debug for our
intranet site, when suddenly I went to run the app and got the error message
that there were build errors. To my suprise there were suddenly build
errors for all the pages in the project! Following the errors, I find that
the System objects are no longer recognized and have blue lines under them
indicting they are not defined. The references section of the project...
|
by: amber |
last post by:
Help!
All of a sudden my solution won't build!
If I'm in debug mode, it builds fine, but if I switch to release mode, I get
the error message:
"Unrecoverable Build Error."
That's it...nothing else...I have no idea where to begin...
I'm using .NET 2005.
Amber
|
by: andrewcw |
last post by:
I am moving some code forward from .NET 1.1. I was able to load the XSL file
and perform the transform. The MSDN documentation looks like it should be
easy. But I get a compile error. Ideas ? How can I share my XSLT ( there
are 2 helper stylesheets, and I check that they are also available... the
loaded xsl makes reference to the helper xsl files. Where should I start
looking ?
// Load the stylesheet.
errBefore =...
|
by: rdudejr |
last post by:
Hi all,
I hardly ever make a post unless I am having a very purplexing issue,
so this one should be good...
I am trying to do a load against a database on an AIX server into a
DB2 v9.1 database, using SAN for storage. The table has a few CLOBs
(smallish clobs but we are storing XML data in non-native format).
Here is the load command I am using:
|
by: cryogeneric |
last post by:
Hello everybody,
I'm not all that familiar with backing up and restoring databases on SQL 2005 and I have a question. First, let me give you a little insight into how we're setup and what we want to do.
We have two servers--live & test. Currently, we perform a full back of the live server each night and restore it to the test server. This all runs automatically. It's been requested that it would be nice to have the test server receive...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |