You could write a shell script that would check the state of the instance prior
to backup, then call the appropriate rman script based on the initial state.
Sent from my iPhone
On Jun 21, 2015, at 6:33 PM, Alan Sterger <asterger@xxxxxxxxxxxxx> wrote:--
Hello List,
Using RMAN to backup multiple noarchive 12c Standard Edition databases. Some
of the noarchive databases are for daily development, some are for special
projects. Special project databases are shutdown until needed.
Want to backup the noarchive databases daily, then return them to their prior
state: Open for the daily dev databases, shutdown for special project
databases.
Using RMAN 'startup force mount' in a run script takes care of the
appropriate startup method.
run {
startup force mount dba;
startup mount;
backup database;
}
However, following 'backup database;' want to automatically return the
database to it's prior state using a single script. For daily dev databases
'alter database open', for special project databases 'shutdown immediate'.
Is someone doing this programmatically?
Thanks,
Asterger
--
//www.freelists.org/webpage/oracle-l
