Re: DMS Datenbank mit RAW-Devices vergrößern
[ ruban.de ] [ Antworten ] [ Forum ]
Geschrieben von Gernot Ruban am Januar 16, 2004 um 12:38:
Als Antwort auf Re: DMS Datenbank mit RAW-Devices vergrößern geschrieben von Thomas on Januar 15, 2004 um 15:39:
Hi Thomas,
hier ein Beispiel! Das Redirected-Restore-Script wurde kurz nach dem Backup durch ein Perl Script für eine Solaris-Umgebung erzeugt. Input dafür war im wesentlichen der Output aus "list tablespace show detail" und "list tablespace containers for id".
Gruß
Gernot
PS: Perl-Infos (auf für Windows,z zB. ActivePerl) findest Du auf dieser Web Site! UPDATE COMMAND OPTIONS USING S ON Z ON /data02/db2/db2bak/db2iap/DBPSTAR-restore.dml.out V ON;
SET CLIENT ATTACH_NODE 0;
SET CLIENT CONNECT_NODE 0;
ECHO @---------------------------------------------------------@;
ECHO @Script created ........: 2003-11-03-11.35.53.000000 @;
ECHO @Script File ...........: /data02/db2/db2bak/db2iap/DBPSTAR-restore.dml @;
ECHO @Database to be restored: DBPSTAR (Redirected Restore) @;
ECHO @Database Object Sizing : CURRENT plus 0% growth @;
ECHO @Disclaimer: Check/edit this script to avoid loss of data! @;
----------------------------------------------------------------
RESTORE DB DBPSTAR
FROM /back-up-path
TAKEN AT yyyymmddhhmmss
TO /new-db-path
INTO new-db
NEWLOGPATH /new-logpath
WITH 2 BUFFERS BUFFER 2048
REDIRECT;
----------------------------------------------------------------
-- Comments: DO NOT CHANGE THE NAME IN 'RESTORE DB DBPSTAR'!
-- DO NOT CHANGE THE NAME IN 'RESTORE DB DBPSTAR 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 DBPSTAR ABORT;
----------------------------------------------------***
-- TS ID 0 / 0 / SYSCATSPACE
-- Space Allocated in Pages: 5401
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 0 USING (
PATH /data03/db2/db2iap/dbpstar/cscatspc
);
----------------------------------------------------***
-- TS ID 1 / 0 / TEMPSPACE1
-- Space Allocated in Pages: 1
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 1 USING (
PATH /data03/db2/db2iap/dbpstar/cstmpspc
);
----------------------------------------------------***
-- TS ID 2 / 0 / USERSPACE1
-- Space Allocated in Pages: 2
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 2 USING (
PATH /data03/db2/db2iap/dbpstar/csusrspc
);
----------------------------------------------------***
-- TS ID 3 / 0 / TEMPTS0801
-- Space Allocated in Pages: 1
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 3 USING (
PATH /data03/db2/db2iap/dbpstar/cstm0801
);
----------------------------------------------------***
-- TS ID 4 / 0 / TEMPTS0802
-- Space Allocated in Pages: 1
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 4 USING (
PATH /data03/db2/db2iap/dbpstar/cstm0802
);
...
...
...
----------------------------------------------------***
-- TS ID 34 / 0 / TSRPFVKB
-- Space Allocated in Pages: 1478320
-- High Water Mark in Pages: 1285760
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 34 USING (
FILE /data03/db2/db2iap/dbpstar/crpfvkb.001 369580
,FILE /data03/db2/db2iap/dbpstar/crpfvkb.002 369580
,FILE /data03/db2/db2iap/dbpstar/crpfvkb.003 369580
,FILE /data03/db2/db2iap/dbpstar/crpfvkb.004 369580
);
...
...
----------------------------------------------------***
-- TS ID 98 / 0 / TSRPZSKZ
-- Space Allocated in Pages: 479
-------------------------------------------------------
SET TABLESPACE CONTAINERS FOR 98 USING (
PATH /data03/db2/db2iap/dbpstar/crpzskz
);
----------------------------------------------------***
ECHO @Restored Database Size : 54279016 KBytes @;
----------------------------------------------------***
RESTORE DB DBPSTAR CONTINUE;
-- ROLLFORWARD DATABASE DBPSTAR TO END OF LOGS;
-- ROLLFORWARD DATABASE DBPSTAR 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
|