DB version : 11.2.0.2
OS : AIX 6.1
I have done Restore and recoveries using plain commands
run {
restore database ;
recover database ;
alter database open resetlogs ;
}
For these restores and recoveries, I never had to use
SWITCH DATABASE TO COPY
or
switch datafile <file_id> to copy;
But, I see these commands being used a lot in various restores, recoveries in the internet.
Googling and oracle Doc
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta049.htm
gave me conflicting ideas on this.
What does this command do in layman's terms?
During restore, recovery if I don't do SWITCH , what is the impact?