list failure, advise failure by rman (Example)

This is really nice one.


RMAN> shutdown immediate

database closed
database dismounted
Oracle instance shut down

I moved to system datafile to system01.dbf.bak.


RMAN> startup

connected to target database (not started)
Oracle instance started
database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/04/2010 21:28:47
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF'

RMAN> list failure
2> ;

List of Database Failures
=========================

Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
1882 CRITICAL OPEN 04-APR-10 System datafile 1: 'D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF' is missing


RMAN> advise failure;

List of Database Failures
=========================

Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
1882 CRITICAL OPEN 04-APR-10 System datafile 1: 'D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF' is missing

analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=151 device type=DISK
analyzing automatic repair options complete

Mandatory Manual Actions
========================
no manual actions available

Optional Manual Actions
=======================
1. If file D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF was unintentionally renamed or moved, restore it
2. If a standby database is available, then consider a Data Guard switchover or failover

Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Restore and recover datafile 1
Strategy: The repair includes complete media recovery with no data loss
Repair script: d:\11gsoftware\diag\rdbms\sandeep\sandeep\hm\reco_3050213094.hm


Contents of file:

d:\11gsoftware\diag\rdbms\sandeep\sandeep\hm\reco_3050213094.hm


# restore and recover datafile
restore datafile 1;
recover datafile 1;



RMAN> restore datafile 1;

Starting restore at 04-APR-10
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
channel ORA_DISK_1: restoring section 1 of 4
channel ORA_DISK_1: reading from backup piece D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO45BZ_.BKP
channel ORA_DISK_1: piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO45BZ_.BKP tag=TAG20100404T190348
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
channel ORA_DISK_1: restoring section 2 of 4
channel ORA_DISK_1: reading from backup piece D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO4FDF_.BKP
channel ORA_DISK_1: piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO4FDF_.BKP tag=TAG20100404T190348
channel ORA_DISK_1: restored backup piece 2
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
channel ORA_DISK_1: restoring section 3 of 4
channel ORA_DISK_1: reading from backup piece D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO5015_.BKP
channel ORA_DISK_1: piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO5015_.BKP tag=TAG20100404T190348
channel ORA_DISK_1: restored backup piece 3
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
channel ORA_DISK_1: restoring section 4 of 4
channel ORA_DISK_1: reading from backup piece D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO6M5K_.BKP
channel ORA_DISK_1: piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO6M5K_.BKP tag=TAG20100404T190348
channel ORA_DISK_1: restored backup piece 4
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 04-APR-10

RMAN> recover datafile 1;

Starting recover at 04-APR-10
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 04-APR-10

RMAN> alter database open;

database opened