RMAN Script to Return DB to Prior State
Date: Sun, 21 Jun 2015 19:33:02 -0400
message-id: <558749AE.5090301_at_earthlink.net>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 22 2015 - 01:33:02 CEST