Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to see contents of stored RMAN scripts

SOLVED
Go to solution
ezhilarasan_1
Occasional Advisor

How to see contents of stored RMAN scripts

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
4 REPLIES
Steve Steel
Honored Contributor
Solution

Re: How to see contents of stored RMAN scripts

Hi

try

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


Steve steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Fred Ruffet
Honored Contributor

Re: How to see contents of stored RMAN scripts

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
--

"Reality is just a point of view." (P. K. D.)
Yogeeraj_1
Honored Contributor

Re: How to see contents of stored RMAN scripts

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: How to see contents of stored RMAN scripts

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)