I was looking at this RMAN script. I see these commands:

STARTUP FORCE MOUNT
ALTER DATABASE MOUNT

STARTUP FORCE shuts it down and then restarts it and mounts it. So,
why the ALTER DATABASE MOUNT?

STARTUP FORCE MOUNT;
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;

On Aug 13, 1:47*pm, The Magnet <a... (AT) unsu (DOT) com> wrote:
The script looks like it was taken from the Oracle® Database Backup
and Recovery Advanced User's Guide 10g Release 2 (10.2) available at
http://download.oracle.com/docs/cd/B...v.htm#BRADV008

STARTUP FORCE MOUNT;
RESTORE CONTROLFILE; # restore control file from consistent backup
ALTER DATABASE MOUNT;
RESTORE DATABASE; # restore datafiles from consistent backup
RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs
are lost
ALTER DATABASE OPEN RESETLOGS;

You have just restored the control file from backup and I hazard a
guess that the alter database mount is needed to read the control file
you just restored, i.e., reposition to the start of the restored
control file.

HTH -- Mark D Powell --

On Aug 13, 12:33*pm, Mark D Powell <Mark.Powe... (AT) hp (DOT) com> wrote:
That strikes me as correct, and yet something bothers me. I look at
your link, and see that it is an example with a catalog. I look at
http://download.oracle.com/docs/cd/B...1.htm#g1040497
and http://download.oracle.com/docs/cd/E...htm#sthref1524
and see that is an error. And of course, there is a "don't do
that" [mount when already mounted] somewhere, I think in the concepts
manual. I guess this goes to show you have to try it for specific
circumstances (or if I'm going bonkers, to read the manual more
carefully).

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...ng-nazis-took/

On Aug 13, 4:34*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
There are many statements in the complete manual set which seem to be
in conflict with each other, but often are not when considered in the
context in which the statements are presented. There are also several
out and out errors of fact in the manuals. However, for the script in
question it appears to be fit for the purpose and conditions discussed
in the section of the manual where it appears though the way to be
sure would be to run a test. Unfortunately I do not have a system
available for testing the script with.

HTH -- Mark D Powell --