How to see contents of stored RMAN scripts

[ezhilarasan_1]

Hi,

I know these
Create script
Replace script
delete script
run script

But I do not know how to see contents
of stored RMAN scripts, and to see
list of stored script names.

Please advise with commands or steps.

Thanks
Ezhil

[Steve Steel · Accepted solution]

Hi

try

http://www.orsweb.com/downloads/source/517.html


Steve steel

[Fred Ruffet]

Ezhil,

Command you're looking for is "print script".

Let me suggest this doc :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96564/toc.htm

Regards,

Fred

[Yogeeraj_1]

hi,

below the two that steps you must undergo:

Step1: obtain a listing of all stored scripts
==============================================

a. Start sqlplus and connect to the recovery catalog database.
/home/yd> sqlplus rman/rman@recocat

b. Issue a SELECT statement on the RC_STORED_SCRIPT view:

yd@MYDB.MU> SELECT script_name FROM rc_stored_script;
SCRIPT_NAME
--------------------------------------------------------------------------------
backupdb
binc
binc1
3 rows selected.

Step2: View script
==============================================
a. Start RMAN and connect to the recovery catalog database and target database, specifying the log argument if you want to print to a message log. For example, enter the following to specify rman_log:

/home/yd> rman target / catalog rman/rman@rcat log rman_log

b. Issue a print script command to write the script to the log:

print script b_whole;

c. Host out to the operating system and use a text editor to view the script. For example, enter:

RMAN> host;
/home/yd> vi rman_log

hope this helps!

regards
Yogeeraj

[Yogeeraj_1]

hi,

below the two that steps you must undergo:

Step1: obtain a listing of all stored scripts
==============================================

a. Start sqlplus and connect to the recovery catalog database.
/home/yd> sqlplus rman/rman@recocat

b. Issue a SELECT statement on the RC_STORED_SCRIPT view:

yd@MYDB.MU> SELECT script_name FROM rc_stored_script;
SCRIPT_NAME
--------------------------------------------------------------------------------
backupdb
binc
binc1
3 rows selected.

Step2: View script
==============================================
a. Start RMAN and connect to the recovery catalog database and target database, specifying the log argument if you want to print to a message log. For example, enter the following to specify rman_log:

/home/yd> rman target / catalog rman/rman@recocat log rman_log

b. Issue a print script command to write the script to the log:

print script backupdb;

c. Host out to the operating system and use a text editor to view the script. For example, enter:

RMAN> host;
/home/yd> vi rman_log

hope this helps!

regards
Yogeeraj