备份：
rman nocatalog target / 登录RMAN
show all; 看所有配置文件
CONFIGURE CONTROLFILE AUTOBACKUP ON; 开启RMAN
exit
rman target /
run{
2> allocate channel d1 type disk;
3> allocate channel d2 type disk;
4> backup full database format ‘/u02/rman/shiyueb0201104232334_%u.bak‘ tag=shiyuefull01;
5> release channel d1;
6> release channel d2;
7> }
恢复
sqlplus / as sysdba
startup 说明下面查DBID号步骤是在open状态下的
select dbid from v$database;
desc v$database
删除控制文件、数据文件
rman target /
startup nomount
set dbid=*****
restore controlfile from autobackup;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
alter database open;
