数据库恢复问题

回复 3# abcd097s


   db2inst1@AIXEDB02 /home/db2inst1$ db2 backup db sample

Backup successful. The timestamp for this backup image is : 20150707104013


db2inst1@AIXEDB02 /home/db2inst1$ db2 drop db sample
DB20000I  The DROP DATABASE command completed successfully.
db2inst1@AIXEDB02 /home/db2inst1$ db2 restore db sample redirect generate script sample.sql
DB20000I  The RESTORE DATABASE command completed successfully.


db2inst1@AIXEDB02 /home/db2inst1$ vi sample.sql


-- *****************************************************************************
    +2  -- ** automatically created redirect restore script
    +3  -- *****************************************************************************
    +4  UPDATE COMMAND OPTIONS USING S ON Z ON SAMPLE_NODE0000.out V ON;
    +5  SET CLIENT ATTACH_MEMBER  0;
    +6  SET CLIENT CONNECT_MEMBER 0;
    +7  -- *****************************************************************************
    +8  -- ** automatically created redirect restore script
    +9  -- *****************************************************************************
   +10  RESTORE DATABASE SAMPLE
   +11  -- USER  
   +12  -- USING ''
   +13  FROM '/home/db2inst1'
   +14  TAKEN AT 20150707104013
   +15  ON '/home/db2inst1'  -- 修改此处
   +16  -- DBPATH ON ''
   +17  INTO SAMPLE
   +18  -- NEWLOGPATH '/home/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/'
   +19  -- WITH BUFFERS
   +20  -- BUFFER
   +21  -- REPLACE HISTORY FILE
   +22  -- REPLACE EXISTING
   +23  REDIRECT
   +24  -- PARALLELISM
   +25  WITHOUT ROLLING FORWARD
   +26  -- WITHOUT PROMPTING



db2inst1@AIXEDB02 /home/db2inst1$ db2 -tvf sample.sql
UPDATE COMMAND OPTIONS USING S ON Z ON SAMPLE_NODE0000.out V ON
DB20000I  The UPDATE COMMAND OPTIONS command completed successfully.

SET CLIENT ATTACH_MEMBER  0
DB20000I  The SET CLIENT command completed successfully.

SET CLIENT CONNECT_MEMBER 0
DB20000I  The SET CLIENT command completed successfully.

RESTORE DATABASE SAMPLE FROM '/home/db2inst1' TAKEN AT 20150707104013 ON '/home/db2inst1/test' INTO SAMPLE REDIRECT WITHOUT ROLLING FORWARD
SQL1277W  A redirected restore operation is being performed. During a table
space restore, only table spaces being restored can have their paths
reconfigured. During a database restore, storage group storage paths and DMS
table space containers can be reconfigured.
DB20000I  The RESTORE DATABASE command completed successfully.

RESTORE DATABASE SAMPLE CONTINUE
DB20000I  The RESTORE DATABASE command completed successfully.

db2inst1@AIXEDB02 /home/db2inst1$ db2 connect to sample

   Database Connection Information

Database server        = DB2/AIX64 10.1.4
SQL authorization ID   = DB2INST1
Local database alias   = SAMPLE

db2inst1@AIXEDB02 /home/db2inst1$收起

回复 2# zsj2002


    刚刚接触DB2，能否给个小例子收起

重定向恢复可以随便挪位置收起