备份与恢复
-
编辑 删除
表——基于SCN的不完全恢复
备份前：sal=8001 rman 备份数据库 [oracle@dba bk]$ vim a.sh #!/bin/bash rman target / log=/bk/1.txt append <<EOF backup as compressed backupset database ...
-
编辑 删除
参数文件、数据文件、归档备份命令
备份spfile：backup spfile;恢复spfile：restore spfile from '/备份集';备份数据文件：backup datafile FILE#;还原数据文件：restore datafile FILE#;恢复数据文件：recover datafile file#备份归档：backup archivelog all delete input;备份归档并将已备份好的归档删除backup archivelog all delete all input...
-
编辑 删除
控制文件的备份与恢复
备份控制文件：backup current controlfile;还原控制文件：restore controfile from '备份集';恢复控制文件：recover database;================实验=====================================================================利用rman备份控制文件：RMAN> backup current controlfile;Starting backup at 25-FEB-11...
