Sunday, June 9, 2013

RMAN Scripting

You can use the cmdfile command-line option to call a command file while calling RMAN
from the Unix shell prompt

$ rman target=/ catalog=u/p@catalog cmdfile=cmd.rman


1:-----------------
You can call a stored script using the script parameter on the command line, as shown
here:
$ rman target=/ catalog=u/p@catalog script stored_script


2:-----------------
You can store scripts in a catalog and call them from the RMAN command prompt, as shown
here:
RMAN> run { execute script stored_script; }


3:-----------------
To execute the global script, you call that script with the clause global before it, as shown in
the following RMAN command:
RMAN> run { execute global script delete_arc_logs; }


No comments:

Post a Comment

Oracle row type vs PostgreSQL record

The Oracle row type concept can be accomplished with the record type in PostgreSQL. Example: Oracle: CURSOR travel_cur IS  SELECT  c.travel_...