Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
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)