用RMAN执行数据库备份

利用RMAN执行数据库完全备份。

backup as copy db_file_name_convert=('C:\oracle\product\10.2.0\oradata\charge','D:\database\backup') database;

上面的完全备份不能备份归档日志，下面用一个批命令： 

run{
crosscheck archivelog all;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
configure controlfile autobackup format for device type disk to 'D:\database\backup2\control_%F';
backup full database format 'D:\database\backup2\data_%d_%U'
plus
archivelog format 'D:\database\backup2\arch_%d_%U' delete all input;
}

备份完后查看备份集：

list backupset;

查看备份镜像： 

list copy;