Databases Reference
In-Depth Information
•
from the RMAN command prompt:
$ rman target=/ catalog=rmancat/rmancat script full_disk_db
... output truncated ...
connected to target database: IDB1 (DBID=420374953)
connected to recovery catalog database
executing script: full_disk_db
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=36 device type=DISK
...
output truncated
...
How It Works
Stored scripts are stored in the catalog database, not on a file system. After executing the
create script
command in
RMAN, the result came back as follows:
created script full_disk_db
This output assures you that the script was created successfully. Had there been some issue while creating the
script, the output would have been an error message. For instance, imagine that while typing you made a mistake in
line 8, as shown here:
RMAN> create script full_disk_db
2> {
3> allocate channel c1 type disk
4> format '+DG1/%U.rmb';
5> backup
6> database
7> include current controlfile;
8> release c1;
Note the syntax error in line 8,
release c1
, instead of
release channel c1
. The moment you press Enter, RMAN
immediately comes back with the following error message:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "channel"
RMAN-01008: the bad identifier was: c1
RMAN-01007: at line 8 column 9 file: standard input
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter,
backup, beginline, blockrecover, catalog, change, connect,
