There are a few other important notes regarding starting RMAN such as a target database designation and specifying a recovery catalog. We will explore activating these designations when starting RMAN.
RMAN can be started by launching the RMAN executable. RMAN can be stopped by exiting or quitting from the RMAN prompt.
Let's walk through this in more detail:
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:Documents and Settings>rman Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved.
RMAN> RMAN> exit Recovery Manager complete. C:Documents and Settings>
Once in the RMAN utility, backup configuration changes and restores can be performed. In order to perform these RMAN activities, it is important to know the three database connection types using the RMAN utility. Table 1.2 describes the three database connections available with RMAN. The subsequent examples will walk through the most common database connections: target database and recovery catalog database connections.
Database Connection | Definition |
---|---|
Target database | The target database is the database that is targeted for backup and recovery. SYSDBA privilege is required to perform these tasks. |
Recovery catalog database | The recovery catalog database is the optional database that stores information about the backup, recovery, and restore data. |
Auxiliary database | The auxiliary database is the standby database, duplicate database, or auxiliary instance (standby or TSPITR). |
There are two methods of connecting to the target database: from the command line and using the RMAN utility.
Let's walk through designating a target database with each method. First, connect from the command line:
Set the Oracle system identifier (SID):
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:Documents and Settings>set ORACLE_SID=ora101c
Launch the RMAN executable, specifying the target and default connection on the command line. NOCATALOG is optional, but if left blank, this is the default.
C:Documents and Settings>rman target / nocatalog Recovery Manager: Release 10.1.0.2.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: ORA101C (DBID=1736563848) RMAN>
Next, we will show you how to connect to the target database within the RMAN utility. This is quite similar to the previous example, except that you are at the RMAN command prompt when you specify the target database. Let's walk through this example:
Set the Oracle system identifier (SID):
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:Documents and Settings>set ORACLE_SID=ora101c
Launch the RMAN executable:
C:Documents and Settings>rman Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. RMAN>
Connect to the target database by executing the connect target command:
RMAN> connect target connected to target database: ORA101C (DBID=1736563848) RMAN>
Connecting to a recovery catalog is a fairly straightforward process. Just as when connecting to the target database, there are two methods of performing this activity: on the command line and within the RMAN utility.
First, let's walk through an example of connecting to the recovery catalog at the command line:
Set the Oracle SID:
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:Documents and Settings>set ORACLE_SID=ora101c
Launch the RMAN executable specifying the target, the catalog and catalog owner, and the database containing the catalog.
C:Documents and Settings>rman target / catalog rman_user/rman_user@oral01rc Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: ORA101C (DBID=1736563848) connected to recovery catalog database RMAN>
Next, you will connect to both the target database and the recovery catalog database within the RMAN utility. This is quite similar to the previous example, except that you are at the RMAN command prompt when you specify the target database and recovery catalog database. Let's walk through this example:
Set the Oracle SID:
C:Documents and Settings>set ORACLE_SID=oral01t
Start the RMAN utility and connect to the target database:
C:Documents and Settings>rman Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. RMAN> connect target connected to target database: ORA101T (DBID=2615281366)
Connect to the recovery catalog specifying the username and password of the RMAN catalog owner:
RMAN> connect catalog rman_user/rman_user@oral01rc; connected to recovery catalog database RMAN>