发布网友 发布时间:2022-04-11 19:11
共3个回答
热心网友 时间:2022-04-11 20:40
========================备份控制文件====================backup current controlfilebackup database include current controlfile=======================RMAN恢复================在非catalog模式下9517备份的信息存储在controlfile文件中vzdh如果controlfile文件发生毁坏,那么就不能能够进行恢复,使用在备份的时候需要把controlfile也进行自动备份 RMAN>show all;using target database control file instead of recovery catalogRMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/home/oracle/proct/10.20/dbs/snapcf_ora10g.f'; # default其中CONFIGURE CONTROLFILE AUTOBACKUP OFF; 没有对controlfile进行 autobackupjnrv使用我们需要运行下面命令来对controlfile进行自动备份RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;RMAN> show all; 手动备份控制文件:backup current controlfileDbid表示database的一个ID3将来用于恢复spfile和controlfile时候要用到.RMAN> c......余下全文>>热心网友 时间:2022-04-11 21:58
楼主有答案了么,我和你出现的问题一样,有答案告知下,谢谢~