1）全备份脚本
run{
    allocate channel c1 type disk;
    backup full tag 'dbfull' format '/path' database
    include current controlfile;
    sql 'alter system archive log current';
    backup fileaperset 3 format '/path'
    archive;og all delete input;
    release chanel c1;
}

2)
优化后的全备份脚本
run{
    backup full tag 'eygle' database
    include current controlfile format 'path'
    plus archivelog format 'path' delete all input;
}

3)
list backup;查看备份

4）
show snapshot controlfile name;查看控制文件快照位置
5）
更改控制文件的快照路径
configure snapshot controlfile name to '....f';

6)
基于SCN的不完全恢复
run
{
    set until scn 18996211390;
    restore database;
    recover database;
}
7）
col escn for 9999999999
alter session se nls_date_format='yyyy-mm-dd hh24:mi:ss';

8)
基于是简单的恢复
run{
    set until time '2007-03-28 11:00:30';
    restore database;
    recover database;
}

9)
确认归档日志
select * from v$archived_log;

10)查看日志文件组
select * from v$log;
11)
无备份控制文件不一致
alter sys set "_allow_resetlogs_corruption"=true scope=spfile;
recover database using backup controlfile until cancel;

12)ORA-600 2662错误
解决
增进SCN
1-通过 immediate trace name (open状态下)
alter session set events 'immediate trace name adjust_scn level x';;
2-通过10015事件 (无法open，mount状态下)
alter session set events '10015 trace name adjust_scn level x';
3-通过_minimum_giga_scn参数设置

13）
undo表空间破坏

._corrupted_rollback_segments='_SYSSMU11S','_SYSSMU12S','_SYSSMU13S'

create undo tablespace undotbsl
datafile '...dbf' size 10M;
alter system set undo_tablespace=undotbsl;

14）backup validate datafile 2;发现坏快

blockrecover datafile 2 block 14 from backupset;恢复坏块
查看坏快信息
select * from v$database_block_corruption where file#=2;

15)
压缩备份
backup as compressed backupset database plus archivelog;
backup as compressed backupset datafile 1,5;

16）
RMAN直接配置压缩备份
configure device type disk backup type to compressed backupset;
configure device type disk backup type to backupset;
backup full filesperset 11 database
17)
通过 spfile 生成pfile
create pfile='path\...ora' from spfile;