RMAN restore for a bad datafile in ASM
876523Jan 20 2012 — edited Jan 20 2012Hello All: This is just a question in my head, if this scenario comes up.
In test, I have successfullly done a full RMAN backup, and restore. I basically, removed a file, and then restored it using the command below. My question is, what if a disk is bad in ASM disk group.... how to go about recovering it..
Do I need to first drop the disk from the asm disk group, and then remount another good disk on to the diskgroup? and then do a resore?
RMAN> startup no mount
RMAN> SET DBID=1287045515; # for windows DB clone
RMAN > restore controlfile from autobackup;
RMAN > startup mount;
RMAN>
run {
#set until time 'Nov 15 2000 09:00:00';
# set until scn 1000; # alternatively, you can specify SCN
set until sequence 30; # alternatively, you can specify log sequence number
restore database;
recover database;
alter database open resetlogs;
}