1.4. Starting and Connecting to RMAN

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.

Table 1.2. RMAN Database Connection Methods
Database ConnectionDefinition
Target databaseThe target database is the database that is targeted for backup and recovery. SYSDBA privilege is required to perform these tasks.
Recovery catalog databaseThe recovery catalog database is the optional database that stores information about the backup, recovery, and restore data.
Auxiliary databaseThe 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:

  1. 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

  2. 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:

  1. 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

  2. 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>

  3. 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:

  1. 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

  2. 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:

  1. Set the Oracle SID:

    C:Documents and Settings>set ORACLE_SID=oral01t

  2. 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)

  3. 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>

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset