Database Reference
In-Depth Information
TABle 3.1
RMAN Command-Line Parameters
Parameter Name
Description
TARGET
Connection string for the target database
CATALOG
Connection string for the recovery catalog database
NOCATALOG
Indicates no recovery catalog is to be used; default
CMDFILE
Name of command file to run
LOG
Name of log file to log RMAN output
TRACE
Name of file for debugging messages
APPEND
Append to log file rather than overwrite
AUXILIARY
The connection string for the auxiliary database
The RMAN Command Prompt
Once you have logged into RMAN, you will be presented the RMAN command prompt
that looks like this:
RMAN>
It is from this command line that we will execute almost all of our RMAN-related
operations. Throughout the next several chapters of this topic, we will introduce you to
many of the RMAN commands that you will call from this prompt.
Calling SQL from the RMAN Command Prompt
One of the handy things that you can do from the RMAN command prompt is to call SQL
commands. In Oracle database versions before Oracle Database 12
c
, you would have to issue
an RMAN command called SQL, and then include the SQL command you wanted executed
in single quotes. The major drawback to this method of running SQL commands is that you
could not see the actual output of the SQL command you were running. Thus, if the com-
mand failed, you might not actually know it failed or why, as shown in this example:
RMAN> sql 'select * from v$database';
using target database control file instead of recovery catalog
sql statement: select * from v$database
Search WWH ::
Custom Search