Re: RMAN Script to Return DB to Prior State

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sun, 21 Jun 2015 19:10:16 -0500
Message-Id: <6227E392-BF63-4179-9C44-7FF63CD7164D_at_gmail.com>

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_at_earthlink.net> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 22 2015 - 02:10:16 CEST