[ADSM-L] AW: [ADSM-L] DB2 Restore / Rollforward
2008-08-08 05:32:03
Hi,
thanks for this info. Unfortunately in the prod database is an error. And our
db2 colleague want a restore from Wednesday into another name and then compare
the both databases....so I've to rollforward old logs....
Best regards,
Boris
-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag
von BEYERS Kurt
Gesendet: Freitag, 8. August 2008 11:05
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: [ADSM-L] DB2 Restore / Rollforward
Hi,
Take a new DB2 backup as follows:
Db2 backup db PROD online use tsm include logs
The log files in use during the backup is now included in the backup image.
And restore / rollforward the database:
Db2 restore db prod use tsm taken at <TIMESTAMP> INTO test
Db2 rollforward db test stop
The database test is now up and running and available for the appications.
Best regards,
Kurt
> -----Oorspronkelijk bericht-----
> Van: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Namens
Remco
> Post
> Verzonden: vrijdag 8 augustus 2008 10:47
> Aan: ADSM-L AT VM.MARIST DOT EDU
> Onderwerp: Re: [ADSM-L] DB2 Restore / Rollforward
>
> Herrmann, Boris wrote:
> > Hello all,
> >
> > I've a question regarding db2 restore and rollforward.
> >
> > Our szenario:
> >
> > We have das datebase called "prod" and want restore this database on
the
> > SAME server into the database "test"
> > The restore database command shoud be:
> > DB2 RESTORE DB prod USE TSM TAKEN AT <TIMESTAMP> INTO test
> >
> > But how can I now rollforward the "test" db? (I don't want interfere
the
> > "prod" db). I miss somesting like rollforward >INTO<....
> >
> > Any help is appreciated....
> > With kind regards,
> > Boris
> >
> >
>
> I'd think that you would have more luck in a db2 specific forum. My
> guess would be that either you can't, or that if you restore logfies
> with the db, you could rollforward your test db to the desired point
in
> time.
>
> --
> Met vriendelijke groeten,
>
> Remco Post, PLCS
*** Disclaimer ***
Vlaamse Radio- en Televisieomroep
Auguste Reyerslaan 52, 1043 Brussel
nv van publiek recht
BTW BE 0244.142.664
RPR Brussel
http://www.vrt.be/disclaimer
|
|
|