Monday 11 May 2015

RMAN STEP BY STEP BACKUP :

RMAN :

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

sqlplus / as sysdba

SQL> startup mount
ORACLE instance started.

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             260048296 bytes
Database Buffers          511705088 bytes
Redo Buffers                5259264 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

C:\Documents and Settings\USERPROFILE>rman target 'sys/sys@orcl_new as sysdba'

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jan 30 17:52:07 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL_NEW (DBID=2985633894)

RMAN> backup database plus archivelog;

Starting backup at 30-JAN-15
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=16 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=1 STAMP=870371596
channel ORA_DISK_1: starting piece 1 at 30-JAN-15
channel ORA_DISK_1: finished piece 1 at 30-JAN-15
piece handle=D:\APP\USERPROFILE\FLASH_RECOVERY_AREA\ORCL_NEW\BACKUPSET\2015_01_30\O1_MF_ANNNN_TAG20150130T175339_BDPXYN9R_.BKP tag=TAG20150130T175339 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 30-JAN-15

Starting backup at 30-JAN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\APP\USERPROFILE\ORADATA\ORCL_NEW\SYSTEM01.DBF
input datafile file number=00002 name=D:\APP\USERPROFILE\ORADATA\ORCL_NEW\SYSAUX01.DBF
input datafile file number=00003 name=D:\APP\USERPROFILE\ORADATA\ORCL_NEW\UNDOTBS01.DBF
input datafile file number=00004 name=D:\APP\USERPROFILE\ORADATA\ORCL_NEW\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 30-JAN-15
channel ORA_DISK_1: finished piece 1 at 30-JAN-15
piece handle=D:\APP\USERPROFILE\FLASH_RECOVERY_AREA\ORCL_NEW\BACKUPSET\2015_01_30\O1_MF_NNNDF_TAG20150130T175351_BDPXYRG5_.BKP tag=TAG20150130T175351 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 30-JAN-15
channel ORA_DISK_1: finished piece 1 at 30-JAN-15
piece handle=D:\APP\USERPROFILE\FLASH_RECOVERY_AREA\ORCL_NEW\BACKUPSET\2015_01_30\O1_MF_NCSNF_TAG20150130T175351_BDPY0TQX_.BKP tag=TAG20150130T175351 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-JAN-15

Starting backup at 30-JAN-15
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=2 STAMP=870371700
channel ORA_DISK_1: starting piece 1 at 30-JAN-15
channel ORA_DISK_1: finished piece 1 at 30-JAN-15
piece handle=D:\APP\USERPROFILE\FLASH_RECOVERY_AREA\ORCL_NEW\BACKUPSET\2015_01_30\O1_MF_ANNNN_TAG20150130T175500_BDPY0WXS_.BKP tag=TAG20150130T175500 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-JAN-15

No comments:

Post a Comment