Name

CREATE SCRIPT

Synopsis

CREATE 
SCRIPT [']script_name['] 
{
   { backupCommands
    | restoreCommands
    | maintenanceCommands
    | miscellaneousCommands
                           }
   [ backupCommands
   | restoreCommands
   | maintenanceCommands
   | miscellaneousCommands
   ...
   ]
}

backupCommands :=
{ BACKUP
| COPY 
}

restoreCommands :=
{ REPLICATE
| RESTORE
| RECOVER
| BLOCKRECOVER
| DUPLICATE
| SWITCH
}

maintenanceCommands :=
{ CATALOG
| CHANGE
| CONFIGURE
| CROSSCHECK
| DELETE
| VALIDATE
| REPORT
| DELETE
| SHOW
}

miscellaneousCommands :=
{ ALLOCATE
| ALTERDATABASE
| BEGINLINE
| DEBUG
| EXECUTESCRIPT
| HOST
| RELEASE
| RESYNC
| SEND
| SET
| SHUTDOWN
| SQL
| STARTUP
}

Creates a script, which is then stored in the recovery catalog.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.