4 Starting and Interacting with the RMAN Client
This chapter explains how to start the RMAN command-line interface and make database connections. This chapter contains the following topics:
4.1 Starting and Exiting RMAN
The RMAN executable is automatically installed with the database and is typically located in the same directory as the other database executables. For example, the RMAN client on Linux is located in $ORACLE_HOME/bin
.
You have the following basic options for starting RMAN:
-
Start the RMAN executable at the operating system command line without specifying any connection options, as in the following example:
% rman
-
Start the RMAN executable at the operating system command line, as in the following examples:
% rman TARGET / % rman TARGET sbu@prod NOCATALOG
See "Making RMAN Database Connections from the Operating System Command Line".
To quit RMAN and terminate the program, enter EXIT
or QUIT
at the RMAN prompt:
RMAN> EXIT
See Also:
Oracle Database Backup and Recovery Reference for RMAN command-line syntax
4.2 Making Database Connections with RMAN
You can create database connections from the RMAN client or the operating system command line. These database connection can be authenticated using a password file or with operating system authentication.
This section contains the following topics:
4.2.1 About RMAN Database Connection Types
To perform useful work, the RMAN client must connect to a database.
Table 4-1 describes the types of database connections that you can make with RMAN.
Table 4-1 Overview of RMAN Database Connections
Type of Database Connection | Keyword | Description |
---|---|---|
|
A database to be backed up or recovered by RMAN |
|
|
A database that provides an optional backup store for the RMAN repository in addition to the control file. |
|
|
A physical standby database, or a database instance created for performing a specific task such as creating a duplicate database, transporting tablespaces, or performing tablespace point-in-time recovery (TSPITR). For many tasks that use an auxiliary database, RMAN creates an automatic auxiliary instance for use during the task, connects to it, performs the task, and then destroys it when the task is completed. You do not give any explicit command to connect to automatic auxiliary instances. |
4.2.2 About Authentication for RMAN Database Connections
Users connecting with RMAN to a target or auxiliary database require either the SYSDBA
or SYSBACKUP
system privilege.
These privileges are not required when connecting to the recovery catalog. You must grant the RECOVERY_CATALOG_OWNER
role to the catalog schema owner. Users can also connect to the recovery catalog using the VPC credentials that have been created by the recovery catalog owner.
The same authentication options that are available with SQL*Plus are available with RMAN. The most common ways to authenticate with the target and auxiliary databases are:
-
Operating system authentication
The prerequisites for connecting using operating system authentication are described in "Authentication Using the Operating System".
-
Password file authentication
The prerequisites for connecting using password file authentication are described in "Authentication Using a Password File".
Neither of these methods requires the database to be open. Operating system authentication is used only to connect locally. Password file authentication can be used to connect locally or remotely.
See Also:
-
Oracle Database Administrator’s Guide to learn about database connection options when using SQL*Plus
-
Oracle Database Security Guide for details about the
SYSDBA
andSYSBACKUP
system privileges
4.2.2.1 Authentication Using the Operating System
RMAN connections to a target or auxiliary database can be made using operating system authentication.
The following are the prerequisites for connecting to a database using operating system authentication (OS authentication):
-
You must set the
ORACLE_SID
environment variable, specifying the system identifier (SID) for the database.For example, to set the SID to
prod
in some UNIX shells, you enter:% ORACLE_SID=prod; export ORACLE_SID
-
You must be a member of the OSDBA operating system group to connect with the
SYSDBA
privilege or the OSBACKUPDBA operating system group to connect with theSYSBACKUP
privilege.On UNIX and Linux, the OSDBA group is typically named
dba
, and the OSBACKUPDBA group is typically namedbackupdba
. These names are assigned during database installation.
The following examples illustrate how to connect to a target database with operating system authentication.
See Also:
Oracle Database Administrator's Guide for a discussion of operating system groups
Example 4-1 OS Authentication with the SYSDBA Privilege - Explicit
% rman target '"/ as sysdba"'
Example 4-2 OS Authentication with the SYSBACKUP Privilege - Explicit
% rman target '"/ as sysbackup"'
Example 4-3 OS Authentication with the SYSDBA Privilege - Implicit
rman target /
If neither AS SYSBACKUP
nor AS SYSDBA
is specified in the connection string, then the default used is AS SYSDBA
.
4.2.2.2 Authentication Using a Password File
Use a password file for either local or remote access. If a database uses a password file to authenticate administrative users, then RMAN can connect using a password.
The database must use a password file for you to connect remotely using a net service name.
Caution:
Good security practice requires that passwords not be entered in plain text on the command line. Enter passwords in RMAN only when requested by an RMAN prompt. See Oracle Database Security Guide to learn about password protection.
The database creates an entry in the password file when you grant the SYSDBA
or SYSBACKUP
privilege to a user. You can then connect to the target or auxiliary database as this user even if the database is not open.
To support connecting through the password file with the SYSBACKUP
privilege, the password file must be created in or upgraded to the format for Oracle Database 12c Release 1 (12.1) or later.
If neither AS SYSBACKUP
nor AS SYSDBA
is specified in the connection string, then the default used is AS SYSDBA
. In this case, no enclosing quotes are required.
See Also:
Oracle Database Administrator's Guide to learn about password files
Example 4-4 Password File Authentication as SYSDBA - Explicit
In this example, the sdba
user has been granted the SYSDBA
privilege:
% rman target '"sdba@prod1 as sysdba"'
target database Password: password
connected to target database: PROD1 (DBID=39525561)
Example 4-5 Password File Authentication as SYSBACKUP - Explicit
In this example, the sbu
user is granted the SYSBACKUP
privilege in the target database:
% rman target '"sbu@prod1 as sysbackup"'
target database Password: password
connected to target database: PROD1 (DBID=39525561)
Example 4-6 Password File Authentication as SYSDBA - Implicit
% rman target sbu@prod1
target database Password: password
connected to target database: PROD1 (DBID=39525561)
4.2.3 Making Database Connections from the RMAN Prompt
If you start RMAN without a connect string on the operating system command line, then you must issue a CONNECT TARGET
command at the RMAN prompt to connect to a target database.
To make a database connection from the RMAN prompt:
Example 4-7 Connecting With OS Authentication - Implicit
RMAN> connect target /
Because no system privilege is specified, AS
SYSDBA
is assumed.
Example 4-8 Connecting with OS Authentication - Explicit
RMAN> connect target "/ as sysdba"
When including a system privilege, the enclosing quotation marks (single or double) are required.
Example 4-9 Connecting with Password File Authentication
RMAN> connect target "sbu@prod AS SYSBACKUP" target database Password: password connected to target database: PROD (DBID=39525561)
Example 4-10 Connecting to Target and a Recovery Catalog
In this example, the target connection uses operating system authentication, and the recovery catalog database connection uses a net service name and password file authentication. The recovery catalog owner is user rco
. RMAN prompts for the password of the recovery catalog user.
RMAN> connect target / RMAN> connect catalog rco@catdb recovery catalog database Password: password connected to recovery catalog database
See Also:
Oracle Database Backup and Recovery Reference to learn about the CONNECT
command
4.2.4 Making RMAN Connections to non-CDBs from the Operating System Command Line
To connect to a target database from the operating system command line, enter the rman
command followed by the connection information. You can begin executing commands after the RMAN prompt is displayed.
Use the CATALOG
keyword to connect to a recovery catalog. You can also start RMAN without specifying NOCATALOG
or CATALOG
. If you do not specify NOCATALOG
on the command line, and if you do not specify CONNECT CATALOG
after RMAN has started, then RMAN defaults to NOCATALOG
mode the first time that you run a command that requires the use of the RMAN repository.
Note:
After you have executed a command that uses the RMAN repository in NOCATALOG
mode, you must exit and restart RMAN to be able to connect to a recovery catalog.
If you connect to the target database on the operating system command line, then you can begin executing commands after the RMAN prompt is displayed.
Example 4-11 Connecting to a Target Database from the System Prompt
This example illustrates a connection to a target database that uses operating system authentication. The NOCATALOG
option indicates that a recovery catalog is not used in the session.
% rman TARGET / NOCATALOG connected to target database: PROD (DBID=39525561) using target database control file instead of recovery catalog
Example 4-12 Connecting to a Target Database from the System Prompt by Using Net Service Names
This example illustrates a connection to a target database that uses a net service name and password file authentication. RMAN prompts for the password.
% rman TARGET sbu@prod NOCATALOG
target database Password: password
connected to target database: PROD (DBID=39525561)
Example 4-13 Connecting to a Target Database from System Prompt When Password Contains a Semi-colon
This example illustrates a connection to a target database that uses a net service name and password file authentication. The password contains a special character, the semi-colon.
rman TARGET "'sbu/rman;pwd@prod AS SYSBACKUP'"
Recovery Manager: Release 20.0.0.0.0 - Development on Mon Feb 11 22:18:07 2019
Version 20.1.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=2004181664)
Note:
For security reasons, Oracle recommends that you do not specify the password at the command line. You should supply the password only when prompted to do so.Example 4-14 Connecting to Target and a Recovery Catalog from the System Prompt
This example illustrates a connection that uses Oracle Net authentication for the target and recovery catalog databases. In both cases RMAN prompts for a password.
% rman TARGET sbu@prod CATALOG rco@catdb target database Password: password connected to target database: PROD (DBID=39525561) recovery catalog database Password: password connected to recovery catalog database
Example 4-15 OS Authentication with the SYSDBA Privilege - Explicit
% rman target '"/ as sysdba"'
Example 4-16 OS Authentication with the SYSBACKUP Privilege - Explicit
% rman target '"/ as sysbackup"'
Example 4-17 OS Authentication with the SYSDBA Privilege - Implicit
rman target /
If neither AS SYSBACKUP
nor AS SYSDBA
is specified in the connection string, then the default used is AS SYSDBA
.
4.2.5 Making RMAN Connections to a CDB
You can connect the RMAN client to multitenant container databases (CDBs) and pluggable databases (PDBs).
This section contains the following topics:
4.2.5.1 About Performing Operations on CDBs and PDBs
You can perform RMAN operations on a whole CDB, the root only, or one or more PDBs.
Make RMAN connections to CDBs according to the following rules:
-
To perform operations on the whole CDB (for example, to back up the whole CDB) you connect as target to the root.
-
To perform operations on the root only (for example, to back up the root) you connect as target to the root.
-
To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.
-
If you connect to the root, you must use the
PLUGGABLE
DATABASE
syntax in your RMAN commands. For example, to back up a PDB, you use theBACKUP
PLUGGABLE
DATABASE
command. -
If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the
BACKUP
DATABASE
command.
-
-
To perform operations on two or more PDBs with a single command, you connect as target to the root.
For example, to back up both the
sales
andhr
PDBs, you connect to the root and submit the following command:BACKUP PLUGGABLE DATABASE sales, hr;
Note:
If you connect as target to a CDB with operating system authentication, you are connected to the root.
4.2.5.2 Restrictions When Connected to a PDB
Certain restrictions apply when you connect directly to a pluggable database (PDB):
The following operations are not available when you connect as target directly to a PDB:
-
Back up archived logs
-
Delete archived logs
-
Delete archived log backups
-
Restore archived logs (RMAN does restore archived logs when required during media recovery.)
-
Point-in-time recovery (PITR) when using shared undo mode
-
TSPITR
-
Table recovery
-
Duplicate database
-
Flashback operations when using shared undo mode
-
Running Data Recovery Advisor
-
Report/delete obsolete
-
Register database
-
Import catalog
-
Reset database
-
Configuring the RMAN environment (using the
CONFIGURE
command)
Note:
When you connect as TARGET
to a PDB, you cannot connect to a recovery catalog.
4.2.5.3 Connecting as Target to the Root
There are several ways to connect as target to the root.
The three most common ways are as follows:
-
Connecting locally as a common user, as shown in Example 4-18
-
Connecting with operating system authentication, as shown in Example 4-19
-
Connecting as a common user through Oracle Net Services, using a net service name, as shown in Example 4-20
In all cases, you must connect as a user with the SYSDBA
or SYSBACKUP
privilege.
Example 4-18 Connecting Locally to the Root
This example connects locally to the root using the SYS
user, which is a common user. The connection is established using the SYSDBA
privilege.
rman target sys
target database Password: password
connected to target database: CDB (DBID=659628168)
Example 4-19 Connecting to the Root with Operating System Authentication
This example connects locally to the root using operating system authentication. The connection is established as the SYS
user with SYSDBA
privilege.
rman target / connected to target database: CDB (DBID=659628168)
Example 4-20 Connecting to the Root with a Net Service Name
This example assumes that there is a sales
net service name that resolves to a database service for the root, and that there is a common user named c##bkuser
that has the SYSBACKUP
privilege.
rman target c##bkuser@sales
target database Password: password
connected to target database: CDB (DBID=659628168)
4.2.5.4 Connecting as Target to a PDB
You can connect to a PDB either from the RMAN prompt or the operating system command line.
To connect as target to a PDB, you must:
-
Connect with a net service name that resolves to a database service for that PDB.
-
Connect as a local user or common user with the
SYSDBA
privilege.
Example 4-21 Connecting As Target to a PDB
This example illustrates a connection to a PDB. It assumes the following
-
You want to perform RMAN operations on a PDB named
hrpdb
. -
The net service name
hrpdb
resolves to a database service for thehrpdb
PDB. -
The local user
hrbkup
was created in thehrpdb
PDB and granted theSYSDBA
privilege.
rman target hrbkup@hrpdb
target database Password: password
connected to target database: CDB (DBID=659628168)
4.2.6 Making RMAN Database Connections Within Command Files
You can make a database connection by creating an RMAN command file containing a CONNECT
command..
If you create an RMAN command file that uses a CONNECT
command with database level credentials (user name and password), then anyone with read access to this file can learn the password. There is no secure way to incorporate a CONNECT
string with a password into a command file.
If you create an RMAN command file that uses a CONNECT
command, then RMAN does not echo the connect string when you run the command file with the @
command. This behavior prevents connect strings from appearing in any log files that contain RMAN output. For example, suppose that you create a command file listbkup.rman
as follows:
cat > listbkup.rman << EOF CONNECT TARGET / LIST BACKUP; EOF
You execute this script by running RMAN with the @
command line option as follows:
% rman @listbkup.rman
When the command file executes, RMAN replaces the connection string with an asterisk, as shown in the following output:
RMAN> CONNECT TARGET * 2> LIST BACKUP; 3> connected to target database: RDBMS (DBID=771530996) using target database control file instead of recovery catalog List of Backup Sets =================== . . .
4.2.7 Connecting RMAN to an Auxiliary Database
To use the DUPLICATE
command, you must connect to an auxiliary instance. Performing tablespace point-in-time recovery (TSPITR) may also require a connection to an auxiliary instance.
The form of an auxiliary connection is identical to a target database connection, except that you use the AUXILIARY
keyword instead of the TARGET
keyword.
Note:
When you use the DUPLICATE ... FROM ACTIVE DATABASE
command, a net service name is required. See "Creating an Initialization Parameter File for the Auxiliary Instance" for more details.
See Also:
-
Duplicating a Database for more details on using the
DUPLICATE
command -
Performing RMAN Tablespace Point-in-Time Recovery (TSPITR) for more details on performing TSPITR
Example 4-22 Connecting to Target and Auxiliary Databases from the RMAN Prompt
This example illustrates a connection to a target database using operating system authentication, and the auxiliary database connection uses a net service name and password file authentication.
% rman
RMAN> CONNECT TARGET /
RMAN> CONNECT AUXILIARY sbu@aux
auxiliary database Password: password
connected to auxiliary database: AUX (DBID=30472568)
Example 4-23 Connecting to Target and Auxiliary Databases from the System Prompt
This example illustrates a connection to a target database and an auxiliary database from the system prompt. The target connection uses operating system authentication and the auxiliary connection uses a net service name and password file authentication.
% rman target / auxiliary sbu@aux
auxiliary database Password: password
connected to auxiliary database: AUX (DBID=30472568)
4.2.8 Diagnosing RMAN Connection Problems
When you are diagnosing errors that RMAN encounters in connecting to the target, catalog and auxiliary databases, consider using SQL*Plus to connect to the databases directly. This action can reveal underlying problems with the connection information or the databases.
This section contains the following topics:
4.2.8.1 Diagnosing Target and Auxiliary Database Connection Problems
RMAN connects to target and auxiliary databases using the SYSDBA
or SYSBACKUP
privilege. Thus, when you use SQL*Plus to diagnose connection problems to the target or auxiliary databases, request a SYSDBA
or SYSBACKUP
connection to reproduce RMAN behavior.
For example, suppose that the following RMAN command encountered connection errors:
RMAN> CONNECT TARGET /
You reproduce the preceding connection attempt with the SQL*Plus command as follows:
SQL> CONNECT / AS SYSBACKUP
4.2.8.2 Diagnosing Recovery Catalog Connection Problems
Use SQL*Plus to diagnose recovery catalog connection problems.
When RMAN connects to the recovery catalog database, it does not use the SYSDBA
or SYSBACKUP
privilege. When you use SQL*Plus to diagnose connection problems to the recovery catalog database, you must enter the database connect string exactly as it was entered into RMAN. Do not specify AS SYSBACKUP
or AS SYSDBA
.
4.3 Specifying the Location of RMAN Output
By default, RMAN writes command output to standard output. To redirect output to a log file, enter the LOG
parameter on the command line when you start RMAN.
The following example writes RMAN command output to the file rman.log:
% rman LOG /tmp/rman.log
In this case, RMAN displays command input but does not display the RMAN output. The easiest way to send RMAN output both to a log file and to standard output is to use the Linux tee
command or its equivalent. For example, the following technique enables both input and output to be visible in the RMAN command-line interface:
% rman | tee rman.log RMAN>
See Also:
Oracle Database Backup and Recovery Reference to learn about RMAN command-line options
4.4 Setting Globalization Support Environment Variables for RMAN
Before invoking RMAN, it may be useful to set the NLS_DATE_FORMAT
and NLS_LANG
environment variables. These variables determine the format used for the time parameters in RMAN commands such as RESTORE
, RECOVER
, and REPORT
.
The following example shows typical language and date format settings:
NLS_LANG=american NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'
If you are going to use RMAN to connect to an unmounted database and mount the database later while RMAN is still connected, then set the NLS_LANG
environment variable so that it also specifies the character set used by the database.
A database that is not mounted assumes the default character set, which is US7ASCII
. If your character set is different from the default, then RMAN returns errors after the database is mounted. For example, if the character set is WE8DEC
, then to avoid errors, you can set the NLS_LANG
variable as follows:
NLS_LANG=american_america.we8dec
For the environment variable NLS_DATE_FORMAT
to be applied and override the defaults set for the server in the server initialization file, the environment variable NLS_LANG
must also be set.
See Also:
-
Oracle Database Reference for more information about the
NLS_LANG
andNLS_DATE_FORMAT
parameters
4.5 Entering RMAN Commands
You can enter RMAN commands either directly from the RMAN prompt or read them in from a text file.
This section contains the following topics:
4.5.1 Entering RMAN Commands at the RMAN Prompt
When the RMAN client is ready for your commands, it displays the command prompt
The following is an example of the RMAN command prompt:
RMAN>
Enter commands for RMAN to execute. For example:
RMAN> CONNECT TARGET RMAN> BACKUP DATABASE;
Most RMAN commands take several parameters and must end with a semicolon. Some commands, such as STARTUP
, SHUTDOWN
, and CONNECT
, can be used with or without a semicolon.
When you enter a line of text that is not a complete command, RMAN prompts for continuation input with a line number. For example:
RMAN> BACKUP DATABASE 2> INCLUDE CURRENT 3> CONTROLFILE 4> ;
4.5.2 Using Command Files with RMAN
For repetitive tasks, you can create a text file containing RMAN commands, and start the RMAN client with the @
argument, followed by a file name.
For example, create a text file cmdfile1
in the current directory containing one line of text as shown here:
BACKUP DATABASE PLUS ARCHIVELOG;
You can run this command file from the command line as shown in this example, and the command contained in it is executed:
% rman TARGET / @cmdfile1
After the command completes, RMAN exits.
You can also use the @
command at the RMAN command prompt to execute the contents of a command file during an RMAN session. RMAN reads the file and executes the commands in it. For example:
RMAN> @cmdfile1
After the command file contents have been executed, RMAN displays the following message:
RMAN> **end-of-file**
Unlike the case where a command file is executed from the operating system command line, RMAN does not exit.
See Also:
Oracle Database Backup and Recovery Reference for RMAN command-line syntax
4.5.3 Entering Comments in RMAN Command Files
The comment character in RMAN is a pound sign (#
). All text from the pound sign to the end of the line is ignored.
For example, the contents of the following command file back up the database and archived redo log files and include comments:
# Command file name: mybackup.rman # The following command backs up the database BACKUP DATABASE; # The following command backs up the archived redo logs BACKUP ARCHIVELOG ALL;
The following example shows how you can break a single RMAN command across multiple lines:
RMAN> BACKUP # this is a comment 2> SPFILE;
4.5.4 Using Substitution Variables in Command Files
When running a command file, you can specify one or more values in a USING
clause for use in substitution variables in a command file. In this way, you can make your command files dynamic.
As in SQL*Plus, &1
indicates where to place the first value, &2
where to place the second value, and so on. The substitution variable syntax is &
integer
followed by an optional period, for example, &1.3
. The optional period is part of the variable and replaced with the value, thus enabling the substitution text to be immediately followed by another integer. For example, if you pass the value mybackup
to a command file containing the variable &1.3
, then the result of the substitution is mybackup3
.
The following procedure explains how to create and use a dynamic shell script that calls a command file containing substitution variables.
To create and use a dynamic shell script:
See Also:
Oracle Database Backup and Recovery Reference for @
syntax
4.5.5 Checking RMAN Syntax
You can test RMAN commands for syntactic correctness without executing them. Use the command-line argument CHECKSYNTAX
to start the RMAN client in a mode in which it only parses the commands that you enter and returns an RMAN-00558
error for commands that are not legal RMAN syntax.
You can check the syntax of RMAN commands either at the command line or in command files.
See Also:
Oracle Database Backup and Recovery Reference to learn about the CHECKSYNTAX
command-line option
4.5.5.1 Checking RMAN Syntax at the Command Line
You can check the syntax of RMAN commands interactively without actually executing the commands.
To check RMAN syntax at the command line:
The following example shows a sample interactive session, with user-entered text in bold.
RMAN> run [ backup database; ] RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01006: error signaled during parse RMAN-02001: unrecognized punctuation symbol "[" RMAN> run { backup database; } The command has no syntax errors RMAN>
4.5.5.2 Checking RMAN Syntax in Command Files
To test commands in a command file, start RMAN with the CHECKSYNTAX
parameter and use the @
command to name the command file to be passed.
To test commands in a command file:
Example 4-24 Checking the Syntax of a Command File with Correct Syntax
This example shows the output when you run /tmp/goodcmdfile
with CHECKSYNTAX
:
RMAN> # command file with legal syntax 2> restore database; 3> recover database; 4> The cmdfile has no syntax errors Recovery Manager complete.
Example 4-25 Checking the Syntax of a Command File with Bad Syntax
This example shows the output when you run /tmp/badcmdfile
with CHECKSYNTAX
:
RMAN> #command file with syntax error 2> restore database 3> recover RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS=============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found "recover": expecting one of: "archivelog, channel, check, controlfile, clone, database, datafile, device, from, force, high, (, preview, ;, skip, spfile, standby, tablespace, until, validate" RMAN-01007: at line 3 column 1 file: /tmp/badcmdfile
Example 4-26 Checking the Syntax of a Command File that Contains Substitution Variables
You make your command files dynamic by including substitution variables. When you check the syntax of a command file that contains substitution variables, RMAN prompts you to enter values. This example illustrates what happens if you enter invalid values when checking the syntax of a dynamic command file. The text in bold indicates text entered at the prompt.
RMAN> CONNECT TARGET * 2> BACKUP TAG Enter value for 1: mybackup abc COPIES Enter value for 2: mybackup abc 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: "integer" RMAN-01008: the bad identifier was: mybackup RMAN-01007: at line 2 column 25 file: /tmp/whole_db.cmd
RMAN indicates a syntax error because the string mybackup
is not a valid argument for COPIES
.
4.6 Using the RMAN Pipe Interface
The RMAN pipe interface is an alternative method for issuing commands to RMAN and receiving the output from those commands. Using this interface, it is possible to write a portable programmatic interface to RMAN.
With the pipe interface, RMAN obtains commands and sends output by using the DBMS_PIPE
PL/SQL package instead of the operating system shell. The pipe interface is invoked by using the PIPE
command-line parameter for the RMAN client. RMAN uses two private pipes: one for receiving commands and the other for sending output. The names of the pipes are derived from the value of the PIPE
parameter. For example, you can invoke RMAN with the following command:
% rman PIPE abc TARGET /
RMAN opens the two pipes in the target database: ORA$RMAN_ABC_IN
, which RMAN uses to receive user commands, and ORA$RMAN_ABC_OUT
, which RMAN uses to send all output back to RMAN. All messages on both the input and output pipes are of type VARCHAR2
.
RMAN does not permit the pipe interface to be used with public pipes, because they are a potential security problem. With a public pipe, any user who knows the name of the pipe can send commands to RMAN and intercept its output.
If the pipes are not initialized, then RMAN creates them as private pipes. If you want to put commands on the input pipe before starting RMAN, you must first create the pipe by calling DBMS_PIPE.CREATE_PIPE
. Whenever a pipe is not explicitly created as a private pipe, the first access to the pipe automatically creates it as a public pipe, and RMAN returns an error if it is told to use a public pipe.
Note:
If multiple RMAN sessions can run against the target database, then you must use unique pipe names for each RMAN session. The DBMS_PIPE.UNIQUE_SESSION_NAME
function is one method that you can use to generate unique pipe names.
This section contains the following topics:
4.6.1 Executing Multiple RMAN Commands in Succession Through a Pipe: Example
This example assumes that the application controlling RMAN wants to run multiple commands in succession. After each command is sent down the pipe and executed and the output returned, RMAN pauses and waits for the next command.
To execute RMAN commands through a pipe: