Re: RESTORE
[ ruban.de ] [ Antworten ] [ Forum ]
Geschrieben von Gernot Ruban on Oktober 08, 2002 um 18:19:
Als Antwort auf RESTORE geschrieben von Peter Schreiner on Oktober 02, 2002 um 11:49:
Hi Peter, (A) Mit dem db2move Utility, das intern mit EXPORT/IMPORT/LOAD arbeitet. (B) Mit einem s.g. Redirected Restore, das an DB2 Full Backup benötigt. Anbei ein Beispiel. Hier auf der Site sollte es ein Perl Script geben, das solche Restore Statements erzeugt. Kein Perl? Dann siehe bei perl.com oder active state - Links ebenfalls auf dieser Web Site. ciao
Gernot Aufruf mit "db2 -tvf file" Hier: Restore von Produktions-DB in einer anderen Umgebung. ====================================================
UPDATE COMMAND OPTIONS USING S ON Z ON /opt/xmpdba/dml/dbiods/DBPODS-DBIODS-20021008-restore.dml.out V ON;
SET CLIENT ATTACH_NODE 0;
SET CLIENT CONNECT_NODE 0;
ECHO @---------------------------------------------------------@;
ECHO @Script created ........: 2002-10-08-03.07.13.000000 @;
ECHO @Script File ...........: /data02/db2/db2bak/db2iai/dbiods-restore.dml @;
ECHO @Database to be restored: DBPODS (Redirected Restore) @;
ECHO @Database Object Sizing : CURRENT plus 0% growth @;
ECHO @Disclaimer: Check/edit this script to avoid loss of data! @;
----------------------------------------------------------------
RESTORE DB DBPODS
FROM /data12/db2/db2bak/db2iap
TAKEN AT 20021008022704
TO /data13/db2/db2iai/dbiods
INTO DBIODS
NEWLOGPATH /data13/db2/db2log/dbiods
WITH 2 BUFFERS BUFFER 2048
REDIRECT;
----------------------------------------------------------------
-- Comments: DO NOT CHANGE THE NAME IN 'RESTORE DB DBPODS'!
-- DO NOT CHANGE THE NAME IN 'RESTORE DB DBPODS CONTINUE'!
-- /back-up-path = path or location of back-up file
-- yyymmddhhmmss = back-up start timestamp, part of backup-file name
-- /new-db-path = database path, see CONTAINER statement below
-- new-db = original database name or new target db name
-- /new-logpath = path to log files, you may alter it afterwards
-- with UPDATE DB CFG FOR ... USING NEWLOGPATH ...
----------------------------------------------------------------
-- RESTORE DB DBPODS ABORT;
----------------------------------------------------***
-- TS ID 0 / 0 / SYSCATSPACE
-- Space Allocated in Pages: 2696
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 0 USING (
PATH /data13/db2/db2iai/dbiods/cscatspc
);
----------------------------------------------------***
-- TS ID 1 / 0 / TEMPSPACE1
-- Space Allocated in Pages: 1
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 1 USING (
PATH /data13/db2/db2iai/dbiods/cstmpspc
);
----------------------------------------------------***
-- TS ID 2 / 0 / USERSPACE1
-- Space Allocated in Pages: 13013
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 2 USING (
PATH /data13/db2/db2iai/dbiods/csusrspc
);
----------------------------------------------------***
-- TS ID 3 / 0 / TSRPTADO
-- Space Allocated in Pages: 24
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 3 USING (
PATH /data13/db2/db2iai/dbiods/crptado
);
----------------------------------------------------***
-- TS ID 4 / 0 / TSRPTBKO
-- Space Allocated in Pages: 707670
-- High Water Mark in Pages: 410528
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 4 USING (
FILE /data13/db2/db2iai/dbiods/crptbko.001 235890
,FILE /data13/db2/db2iai/dbiods/crptbko.002 235890
,FILE /data13/db2/db2iai/dbiods/crptbko.003 235890
);
----------------------------------------------------***
-- TS ID 5 / 0 / TSRPTPRS
-- Space Allocated in Pages: 43493
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 5 USING (
PATH /data13/db2/db2iai/dbiods/crptprs
);
...
...
...
----------------------------------------------------***
ECHO @Restored Database Size : 13733412 KBytes @;
----------------------------------------------------***
RESTORE DB DBPODS CONTINUE;
-- ROLLFORWARD DATABASE DBPODS TO END OF LOGS;
-- ROLLFORWARD DATABASE DBPODS STOP;
----------------------------------------------------------------
-- Comments: Use ROLLFORWARD TO END OF LOGS, if log files will
-- contain important information which will bring the
-- database to latest consistent state. Use STOP to
-- ignore log files at all. Do not use CANCEL keyword!
----------------------------------------------------------------
Schreibe eine Antwort
|