丢失所以控制文件，数据库文件，redo文件进行数据库恢复

1、数据库备份

[oracle@localhost rmanbak]$ more rman.script 
run{
backup incremental level=0 format '/u01/app/rmanbak/rmandata/full_%U' database plus archivelog delete input;
}
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;
delete expired backupset;
[oracle@localhost rmanbak]$ sh rman.script 

2、删除控制文件，数据库文件，redo文件

[oracle@localhost ~]$ ls
admin  arch  database  oradata  oraInventory  product  rmanbak
[oracle@localhost ~]$ mv oradata 20131030oradata
20131030oradata  admin  arch  database  oraInventory  product  rmanbak
[oracle@localhost ~]$ mkdir -p oradata/dbora

3、进行恢复

RMAN> startup nomount;

Oracle instance started

Total System Global Area     285212672 bytes

Fixed Size                     1218992 bytes
Variable Size                109053520 bytes
Database Buffers             171966464 bytes
Redo Buffers                   2973696 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 30-OCT-13
using channel ORA_DISK_1

channel ORA_DISK_1: looking for autobackup on day: 20131030
channel ORA_DISK_1: looking for autobackup on day: 20131029
channel ORA_DISK_1: looking for autobackup on day: 20131028
channel ORA_DISK_1: looking for autobackup on day: 20131027
channel ORA_DISK_1: looking for autobackup on day: 20131026
channel ORA_DISK_1: looking for autobackup on day: 20131025
channel ORA_DISK_1: looking for autobackup on day: 20131024
channel ORA_DISK_1: no autobackup in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/30/2013 01:27:01
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> restore controlfile from '/u01/app/rmanbak/rmandata/c-3112675579-20131030-00';  指定路径

Starting restore at 30-OCT-13
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/u01/app/oradata/dbora/control01.ctl
output filename=/u01/app/oradata/dbora/control02.ctl
output filename=/u01/app/oradata/dbora/control03.ctl
Finished restore at 30-OCT-13

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 30-OCT-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=155 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=154 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/app/oradata/dbora/undotbs01.dbf
restoring datafile 00005 to /u01/app/oradata/dbora/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/rmanbak/rmandata/full_3lonlnbp_1_1
channel ORA_DISK_3: starting datafile backupset restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oradata/dbora/system01.dbf
channel ORA_DISK_3: reading from backup piece /u01/app/rmanbak/rmandata/full_3jonlnbp_1_1
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u01/app/oradata/dbora/sysaux01.dbf
restoring datafile 00004 to /u01/app/oradata/dbora/users01.dbf
channel ORA_DISK_2: reading from backup piece /u01/app/rmanbak/rmandata/full_3konlnbp_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/rmanbak/rmandata/full_3lonlnbp_1_1 tag=TAG20131030T011432
channel ORA_DISK_1: restore complete, elapsed time: 00:00:57
channel ORA_DISK_2: restored backup piece 1
piece handle=/u01/app/rmanbak/rmandata/full_3konlnbp_1_1 tag=TAG20131030T011432
channel ORA_DISK_2: restore complete, elapsed time: 00:01:04
channel ORA_DISK_3: restored backup piece 1
piece handle=/u01/app/rmanbak/rmandata/full_3jonlnbp_1_1 tag=TAG20131030T011432
channel ORA_DISK_3: restore complete, elapsed time: 00:01:50
Finished restore at 30-OCT-13

RMAN>  recover database;

Starting recover at 30-OCT-13
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=2
channel ORA_DISK_1: reading from backup piece /u01/app/rmanbak/rmandata/full_3monlne0_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/rmanbak/rmandata/full_3monlne0_1_1 tag=TAG20131030T011544
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=/u01/app/arch/1_2_829814016.dbf thread=1 sequence=2
unable to find archive log
archive log thread=1 sequence=3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/30/2013 01:35:17
RMAN-06054: media recovery requesting unknown log: thread 1 seq 3 lowscn 697103

RMAN> recover database until scn 697103;     不完全恢复

Starting recover at 30-OCT-13
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

starting media recovery

unable to find archive log
archive log thread=1 sequence=3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/30/2013 01:35:47
RMAN-06054: media recovery requesting unknown log: thread 1 seq 3 lowscn 697103

RMAN> alter database open resetlogs;

database opened