RMAN BACKUP AND RECOVER A DATABASE

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: IACM (DBID=1202858792)

RMAN> shutdown;

using target database controlfile instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

RMAN> backup database;

Starting backup at 08-JAN-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=14 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=15 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=H:\ORACLE\ORADATA\IACM\EXAMPLE01.DBF
input datafile fno=00010 name=H:\ORACLE\ORADATA\IACM\XDB01.DBF
input datafile fno=00006 name=H:\ORACLE\ORADATA\IACM\INDX01.DBF
input datafile fno=00003 name=H:\ORACLE\ORADATA\IACM\CWMLITE01.DBF
channel ORA_DISK_1: starting piece 1 at 08-JAN-10
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00002 name=H:\ORACLE\ORADATA\IACM\UNDOTBS01.DBF
input datafile fno=00009 name=H:\ORACLE\ORADATA\IACM\USERS01.DBF
input datafile fno=00004 name=H:\ORACLE\ORADATA\IACM\DRSYS01.DBF
input datafile fno=00007 name=H:\ORACLE\ORADATA\IACM\ODM01.DBF
channel ORA_DISK_2: starting piece 1 at 08-JAN-10
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=H:\ORACLE\ORADATA\IACM\SYSTEM01.DBF
input datafile fno=00008 name=H:\ORACLE\ORADATA\IACM\TOOLS01.DBF
channel ORA_DISK_3: starting piece 1 at 08-JAN-10
channel ORA_DISK_2: finished piece 1 at 08-JAN-10 with 2 copies
piece handle=H:\ORACLE\ORA92\DATABASE\02L2TCTR_1_1 comment=NONE
piece handle=H:\ORACLE\ORA92\DATABASE\02L2TCTR_1_2 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:22
channel ORA_DISK_1: finished piece 1 at 08-JAN-10 with 2 copies
piece handle=H:\ORACLE\ORA92\DATABASE\01L2TCTR_1_1 comment=NONE
piece handle=H:\ORACLE\ORA92\DATABASE\01L2TCTR_1_2 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:57
channel ORA_DISK_3: finished piece 1 at 08-JAN-10 with 2 copies
piece handle=H:\ORACLE\ORA92\DATABASE\03L2TCTR_1_1 comment=NONE
piece handle=H:\ORACLE\ORA92\DATABASE\03L2TCTR_1_2 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:01:32
Finished backup at 08-JAN-10

RMAN> restore database;

Starting restore at 08-JAN-10

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
skipping datafile 1; already restored to file H:\ORACLE\ORADATA\IACM\SYSTEM01.DB
F
skipping datafile 8; already restored to file H:\ORACLE\ORADATA\IACM\TOOLS01.DBF

skipping datafile 2; already restored to file H:\ORACLE\ORADATA\IACM\UNDOTBS01.D
BF
skipping datafile 4; already restored to file H:\ORACLE\ORADATA\IACM\DRSYS01.DBF

skipping datafile 7; already restored to file H:\ORACLE\ORADATA\IACM\ODM01.DBF
skipping datafile 9; already restored to file H:\ORACLE\ORADATA\IACM\USERS01.DBF

skipping datafile 3; already restored to file H:\ORACLE\ORADATA\IACM\CWMLITE01.D
BF
skipping datafile 5; already restored to file H:\ORACLE\ORADATA\IACM\EXAMPLE01.D
BF
skipping datafile 6; already restored to file H:\ORACLE\ORADATA\IACM\INDX01.DBF
skipping datafile 10; already restored to file H:\ORACLE\ORADATA\IACM\XDB01.DBF
restore not done; all files readonly, offline, or already restored
Finished restore at 08-JAN-10

RMAN> recover database;

Starting recover at 08-JAN-10
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

starting media recovery
media recovery complete

Finished recover at 08-JAN-10

RMAN> alter database open;

database opened

RMAN>

RMAN>

RMAN>