Next: Basic Recovery
Up: Using RMAN
Previous: Enabling ARCHIVELOG Mode
Contents
Lets do a real simple backup using RMAN that writes it's output to
a local file instead of the tape subsystem just to see how it works.
In this case, we've got our database (SID: cuddle) up and running.
[oracle@vixen oracle]$ echo $ORACLE_SID
cuddle
[oracle@vixen oracle]$ rman nocatalog target /
Recovery Manager: Release 10.1.0.2.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: CUDDLE (DBID=251015092)
using target database controlfile instead of recovery catalog
RMAN> backup database;
Starting backup at 02-NOV-04
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=162 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/oradata/cuddle/system01.dbf
input datafile fno=00003 name=/u02/oradata/cuddle/sysaux01.dbf
input datafile fno=00002 name=/u02/oradata/cuddle/undotbs01.dbf
input datafile fno=00004 name=/u02/oradata/cuddle/users01.dbf
channel ORA_DISK_1: starting piece 1 at 02-NOV-04
channel ORA_DISK_1: finished piece 1 at 02-NOV-04
piece handle=/u01/app/oracle/product/10.1.0/db_1/dbs/05g438u6_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current controlfile in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 02-NOV-04
channel ORA_DISK_1: finished piece 1 at 02-NOV-04
piece handle=/u01/app/oracle/product/10.1.0/db_1/dbs/06g4391f_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 02-NOV-04
RMAN> quit
Recovery Manager complete.
[oracle@vixen oracle]$
This is the most basic backup you can do with RMAN. We didn't tell RMAN
how or where to backup the database, just simply to do it.
The rman command is passed 2 arguments: the first "nocatalog" tells
RMAN that we aren't using a recovery catalog database and the second "target /"
is similar to a SQL*Plus connect statement, with information that RMAN requires
to connect to the target database. The target is the database we
wish to backup.
Notice that RMAN returns some interesting information prior to giving us
a prompt. It confirms that RMAN is connected to the target and lists that target.
The DBID seen after the target database SID can be very important for
later recoveries and it is recommend that you write it down somewhere for future
use. RMAN then confirms that because we aren't using a recovery catalog to store
backup metadata that it will instead store the data in the target databases control
files.
The RMAN command backup database; sends RMAN on its merry way backing up the
database. Notice that we didn't tell it where or how to backup the data.
By default the backup peices will be placed in the $ORACLE_HOME/dbs directory.
This can get very messy since your system PFILES are in there too, and therefore we
recommend that you don't use this location for your normal backups.
Two backup peices were created. The first contains the datafiles holding
the tablespaces including the undo tablespace. The second backup peice contains
the current SPFILE and curent controlfile.
Lets stop and think carefully for just a moment. Now, we've opted to use ARCHIVELOG
mode which means we can do hot backups. However, we didn't want the hassle and
administrative overhead of maintaining a recovery catalog. So here is the rub:
recall that you need a PFILE/SPFILE to start an instance and you need the controlfile
to point to all the files to be mounted. If the database were completely destroyed we
would certainly need both the SPFILE and the Controlfile to access the backup peices
made by RMAN.... but they are inside the backup we just made! Nice little
loop of confusion huh? We'll talk about this later, but for now just keep it
in mind.
Next: Basic Recovery
Up: Using RMAN
Previous: Enabling ARCHIVELOG Mode
Contents
2005-02-10