Monday 29 December 2014

Oracle Rman İle Backup Alma

Merhaba,

Bu yazıda Rman ile nasıl backup alabileceğinize değineceğim. Alttaki adımları izleyerek rman ile backup alabilirsiniz.

dummys oracle@tst2:/home/oracle>rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Dec 29 15:43:01 2014

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

connected to target database: DUMMY (DBID=1621295373, not open)

RMAN> backup database;  Bu komut ile alabilirsiniz.

Starting backup at 29/12/2014 15:43:11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4 device type=DISK
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=+DATADG/dummys/datafile/system.257.45325324
input datafile file number=00002 name=+DATADG/dummys/datafile/sysaux.258..45325324
input datafile file number=00003 name=+DATADG/dummys/datafile/undotbs1.259..45325324
input datafile file number=00004 name=+DATADG/dummys/datafile/users.261..45325324
input datafile file number=00005 name=+DATADG/dummys/datafile/example.260..45325324
channel ORA_DISK_1: starting piece 1 at 29/12/2014 15:43:12
channel ORA_DISK_1: finished piece 1 at 29/12/2014 15:43:27
piece handle=+DATADG/dummys/backupset/2014_12_29/nnndf0_tag20141229t154312_0.304.867598993 tag=TAG20141229T154312 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
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 29/12/2014 15:43:29
channel ORA_DISK_1: finished piece 1 at 29/12/2014 15:43:30
piece handle=+DATADG/dummys/backupset/2014_12_29/ncsnf0_tag20141229t154312_0.303.867599009 tag=TAG20141229T154312 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 29/12/2014 15:43:30

Aldığınıx backupı görmek isterseniz'de alttaki komut işinize yarayacaktır.

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time  
------- ---- -- ---------- ----------- ------------ -------------------
1       Full    1.62G      DISK        00:00:11     29/12/2014 15:43:23
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20141229T154312
        Piece Name: +DATADG/dummys/backupset/2014_12_29/nnndf0_tag20141229t154312_0.304.867598993
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/system.257.45325324
  2       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/sysaux.258.45325324
  3       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/undotbs1.259.45325324
  4       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/users.261.45325324
  5       Full 16192445   29/12/2014 10:00:03 +DATADG/dummys/datafile/example.260.45325324

BS Key  Type LV Size       Device Type Elapsed Time Completion Time  
------- ---- -- ---------- ----------- ------------ -------------------
2       Full    8.14M      DISK        00:00:02     29/12/2014 15:43:29
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20141229T154312
        Piece Name: +DATADG/dummys/backupset/2014_12_29/ncsnf0_tag20141229t154312_0.303.867599009
  SPFILE Included: Modification time: 26/07/2014 20:27:11
  SPFILE db_unique_name: DUMMYS
  Standby Control File Included: Ckp SCN: 16192445     Ckp time: 29/12/2014 10:00:03

Hepsi bu kadar.

Sevgiyle kalın...