oracle恢复基础
1.恢复online redo log方法startup mountrecover database until cancel using backup controlfile选择cancelalter database open resetlogs2.恢复数据文件假如app01.dbf数据丢失cp /u01/backup/hot/app01.dbf /u01...
rman备份基础
RMAN> show all;配置controlfile为自动备份RMAN> configure controlfile autobackup on;new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters are successf...
alter system switch logfile和alter system archive log current的区别
alter system switch logfile是强制日志切换,不一定就归档当前的重做日志文件(若自动归档打开,就归档当前重做日志)alter system archive log current 是归档当前的重做日志文件,不管自动归档有没有打开都归档...