Tuesday, 31 December 2013

BACKUP DATABASE


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
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: 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=00002 name=H:\ORACLE\ORADATA\IACM\UNDOTBS01.DBF
input datafile fno=00005 name=H:\ORACLE\ORADATA\IACM\EXAMPLE01.DBF
input datafile fno=00011 name=H:\ORACLE\ORADATA\IACM\RMAN01.DBF
input datafile fno=00010 name=H:\ORACLE\ORADATA\IACM\XDB01.DBF
input datafile fno=00012 name=H:\ORACLE\ORADATA\IACM\RMAN401.DBF
input datafile fno=00006 name=H:\ORACLE\ORADATA\IACM\INDX01.DBF
input datafile fno=00009 name=H:\ORACLE\ORADATA\IACM\USERS01.DBF
input datafile fno=00003 name=H:\ORACLE\ORADATA\IACM\CWMLITE01.DBF
input datafile fno=00004 name=H:\ORACLE\ORADATA\IACM\DRSYS01.DBF
input datafile fno=00007 name=H:\ORACLE\ORADATA\IACM\ODM01.DBF
input datafile fno=00008 name=H:\ORACLE\ORADATA\IACM\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 08-JAN-10
channel ORA_DISK_1: finished piece 1 at 08-JAN-10
piece handle=H:\ORACLE\ORA92\DATABASE\07L2UP4D_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:17
Finished backup at 08-JAN-10

RMAN>ALTER DATABASE OPEN;

DATABASE OPEN


RMAN>

No comments:

Post a Comment