Oracle9i Recovery Manager Reference
Release 1 (9.0.1)

Part Number A90136-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

RMAN Commands , 20 of 60


CREATE SCRIPT

Syntax


Text description of createsc.gif follows
Text description of the illustration createsc.gif

backupCommands::=


Text description of backupco.gif follows
Text description of the illustration backupco.gif

restoreCommands::=


Text description of restorec.gif follows
Text description of the illustration restorec.gif

maintenanceCommands::=


Text description of maintena.gif follows
Text description of the illustration maintena.gif

miscellaneousCommands::=


Text description of miscella.gif follows
Text description of the illustration miscella.gif

Purpose

To create a script and store it in the recovery catalog for future reference. Stored scripts provide a common repository for frequently executed collections of RMAN commands. Any command that is legal within a RUN command is permitted in the stored script. The script is not executed immediately; run the script with @.

See Also:

Oracle9i Recovery Manager User's Guide to learn how to store scripts in the recovery catalog 

Restrictions and Usage Notes

Note the following restrictions:

Keywords and Parameters

For descriptions of the individual commands that you can use in a stored script, refer to the appropriate entry, for example, "BACKUP".

'script_name' 

Creates a stored script with the specified name. The statements allowable within the brackets of the CREATE SCRIPT 'script_name' { ... } command are the same allowable within the RUN command. The statements within the braces constitute the job_command_list.

Note: To run the stored script, specify EXECUTE SCRIPT within the braces of the RUN command. 

Example

Creating a Script: Example

This example creates a script called b_whole_10 that backs up the database and archived redo logs, then executes it:

CREATE script b_whole_l0 
{
    ALLOCATE CHANNEL d1 DEVICE TYPE sbt;
    BACKUP INCREMENTAL LEVEL 0 TAG b_whole_l0 DATABASE PLUS ARCHIVELOG;
}

RUN { EXECUTE script b_whole_10; }

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback