oracle backup & recovery測試

    今天在hp的dp上，做了一次資料庫的備份和恢復測試，大概的思路是這樣的：
    1.備份策略:
        資料庫全備份 backup database
        資料庫歸檔日誌備份 backup archivelog

    2.恢復策略
        a) 基於表空間的恢復
             shutdown immeidate;            
             mv data.dbf data.dbf.bak
             startup mount
             alter database open -> can't open db,because data.dbf not exist.
             use hp dp to restore tablespace data. 
             alter database open -> testing successfully.
        b) 資料庫完全恢復
             shutdown immeidate;
             dd if=/dev/rlvdata66 of=/dev/rlvdata01 bs=8192k
             startup mount
             alter database open->can't open db, because rlvdata01 not exist.
             use hp dp to restore database , recover database.
             alter database open -> testing successfully.
         c)資料庫不完全恢復(基於時間點的恢復)
            shutdown immediate;
            drop table test
            startup mount
            use hp dp to restore database to xxxx(time)
            alter database open resetlogs. 
            check select count(*) from test -> testing successfully.