當(dāng)前位置：首頁>技術(shù)交流>Veritas NetBackup Oracle備份和恢復(fù)

Veritas NetBackup Oracle的備份和恢復(fù)

參考前面章節(jié)，配置需要備份的腳步，Netbackup 會(huì)通過設(shè)定的策略調(diào)用腳本，對(duì)oracle 數(shù)據(jù)庫進(jìn)行備份

Oracle的恢復(fù)

恢復(fù)控制文件

RUN{

SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE'

TO '%F';

ALLOCATE CHANNEL CH00 DEVICE TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=ha-oracle2';

RESTORE CONTROLFILE FROM AUTOBACKUP MAXDAYS 2;

RELEASE CHANNEL CH00;

}

將數(shù)據(jù)庫改變到MOUNT狀態(tài)

alter database mount

恢復(fù)數(shù)據(jù)文件

RUN{

ALLOCATE CHANNEL CH00 DEVICE TYPE 'SBT_TAPE';

SEND 'NB_ORA_CLIENT=ha-oracle2';

RESTORE DATABASE;

RELEASE CHANNEL CH00;

}

恢復(fù)歸檔日志

RUN{

ALLOCATE CHANNEL CH00 DEVICE TYPE 'SBT_TAPE';

SEND 'NB_ORA_CLIENT=ha-oracle2';

RESTORE ARCHIVELOG ALL;

RELEASE CHANNEL CH00;

}

進(jìn)行recover

RUN{

ALLOCATE CHANNEL CH00 DEVICE TYPE 'SBT_TAPE';

SEND 'NB_ORA_CLIENT=ha-oracle2';

RECOVER DATABASE;

RELEASE CHANNEL CH00;

}

以resetlog打開數(shù)據(jù)庫

alter database open resetlogs;

檢查數(shù)據(jù)庫內(nèi)容

SELECT NAME,STATUS FROM V$DATAFILE;