RMAN Script to Return DB to Prior State

  • From: Alan Sterger <asterger@xxxxxxxxxxxxx>
  • To: Oracle-List <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 21 Jun 2015 19:33:02 -0400

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


Other related posts: