ORACLE數(shù)據(jù)庫(kù)備份與恢復(fù)方案?jìng)浞莘桨冈O(shè)計(jì)前提：數(shù)據(jù)庫(kù)設(shè)置為歸檔模式，不使用恢復(fù)目錄數(shù)據(jù)庫(kù)1、一個(gè)月一次在線全庫(kù)備份2、每天歸檔日志備份3、每周一次exp導(dǎo)出4、每天一次exp增量導(dǎo)出5、保留最近兩次全備和歸檔日志的備份6、至少保留最近一個(gè)月exp文件7、既備份到磁盤也備份到磁帶Win2000下oracle8i/9i的備份方案的實(shí)現(xiàn)說(shuō)明：數(shù)據(jù)庫(kù)實(shí)例：ora9i，備份目錄為e:\backup每個(gè)月一次全備1、備份命令文件：fullbackup.batrmancmdfile=fullbackup.rcvcopyC:\oracle\oradata\ora9i\CONTROL01.CTLe:\backup\CONTROL01.CTL/y2、RMAN參數(shù)文件：fullbackup.rcvconnecttargetsystem/manager@ora9i;run{allocatechannelc1typedisk;backupfulltag'dbfull'format'e:\backup\dbfull%u_%s_%p'database;sql'altersystemarchivelogcurrent';backuparchivelogalldeleteinputformat'e:\backup\arch%u_%s_%p';releasechannelc1;}3、任務(wù)計(jì)劃增加一個(gè)每月1號(hào)1點(diǎn)開始執(zhí)行的任務(wù)計(jì)劃fullbackup每天一次歸檔日志的備份1、備份命令文件：archbackup.batrmancmdfile=archbackup.rcv2、RMAN參數(shù)文件：archbackup.rcvconnecttargetsystem/manager@ora9i;run{allocatechannelc1typedisk;sql'altersystemarchivelogcurrent';backuparchivelogalldeleteinputformat'e:\backup\arch%u_%s_%p';releasechannelc1;}3、任務(wù)計(jì)劃增加一個(gè)每天2點(diǎn)開始執(zhí)行的任務(wù)計(jì)劃archbackupUNIX下oracle8i/9i的備份方案的實(shí)現(xiàn)基本相同，但計(jì)劃任務(wù)得用crontab來(lái)實(shí)現(xiàn)恢復(fù)方案設(shè)計(jì)Win2000下oracle8i/9i的恢復(fù)方案的實(shí)現(xiàn)一、故障描述：磁盤損壞，數(shù)據(jù)庫(kù)徹底癱瘓?zhí)幚矸椒ǎ焊鼡Q磁盤，重新安裝ORACLE（如果數(shù)據(jù)庫(kù)安裝的磁盤也損壞的話），重新創(chuàng)建實(shí)例ora9i，讓數(shù)據(jù)庫(kù)處于shutdown狀態(tài)。將控制文件還原copye:\backup\CONTROL01.CTLC:\oracle\oradata\ora9i\CONTROL01.CTL/ycopye:\backup\CONTROL01.CTLC:\oracle\oradata\ora9i\CONTROL02.CTL/ycopye:\backup\CONTROL01.CTLC:\oracle\oradata\ora9i\CONTROL03.CTL/y將數(shù)據(jù)庫(kù)mount上：startupmount;進(jìn)行恢復(fù)rmancmdfile=fullrecover.rcv文件fullrecover.rcvconnecttargetsystem/manager@ora9irun{allocatechannelc1typedisk;restoredatabase;restorearchivelogall;recoverdatabase;sql"alterdatabaseopen";releasechannelc1; }二、重做日志文件丟失將數(shù)據(jù)庫(kù)mount上：startupmount;恢復(fù)connecttargetsystem/manager@ora9irun{allocatechannelc1typedisk;restorearchivelogall;recoverdatabase;releasechannelc1;}三、Datafilerecovery數(shù)據(jù)文件恢復(fù)RMAN>run{

2>allocatechannelc1typedisk;

3>sql"altertablespaceusersofflineimmediate";

4>restoredatafile4;

5>recoverdatafile4;

6>sql"altertablespaceusersonline";

7>releasechannelc1;

8>}

四、Tablespacerecovery表空間恢復(fù)

RMAN>run{

2>allocatechannelc1typedisk;

3>sql"altertablespaceusersofflineimmediate";

4>restoretablespaceusers;

5>recover