jueves, 22 de agosto de 2013

EXAMPLE BACKUP AS COPY



[oracle@localhost labs2]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Aug 22 17:37:16 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ACME (DBID=2003395651)
RMAN> backup incremental level 1 for recover of copy with tag 'backup_incr' database;
Starting backup at 2013-08-22:17:38:04
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=37 device type=DISK
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 5 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 4 found
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/acme/system01.dbf
output file name=/u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_system_91f4phck_.dbf tag=BACKUP_INCR RECID=2 STAMP=824146789
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/acme/sysaux01.dbf
output file name=/u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_sysaux_91f4svo0_.dbf tag=BACKUP_INCR RECID=3 STAMP=824146910
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/acme/example01.dbf
output file name=/u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_example_91f4xrrq_.dbf tag=BACKUP_INCR RECID=4 STAMP=824146928
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/acme/undotbs01.dbf
output file name=/u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_undotbs1_91f4y845_.dbf tag=BACKUP_INCR RECID=5 STAMP=824146942
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/acme/users01.dbf
output file name=/u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_users_91f4yjjo_.dbf tag=BACKUP_INCR RECID=6 STAMP=824146945
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2013-08-22:17:42:25
Starting Control File and SPFILE Autobackup at 2013-08-22:17:42:26
piece handle=/u01/app/oracle/flash_recovery_area/ACME/autobackup/2013_08_22/o1_mf_s_824146946_91f4yny0_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-08-22:17:42:33
RMAN> list copy of tablespace example;
List of Datafile Copies
=======================
Key     File S Completion Time     Ckp SCN    Ckp Time          
------- ---- - ------------------- ---------- -------------------
4       5    A 2013-08-22:17:42:08 2084754    2013-08-22:17:42:00
        Name: /u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_example_91f4xrrq_.dbf
        Tag: BACKUP_INCR

RMAN> backup incremental level 1 for recover of copy with tag 'backup_incr' database;
Starting backup at 2013-08-22:18:04:22
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/acme/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/acme/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/acme/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/acme/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/acme/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2013-08-22:18:04:23
channel ORA_DISK_1: finished piece 1 at 2013-08-22:18:05:48
piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2013_08_22/o1_mf_nnnd1_BACKUP_INCR_91f67v6c_.bkp tag=BACKUP_INCR comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
Finished backup at 2013-08-22:18:05:48
Starting Control File and SPFILE Autobackup at 2013-08-22:18:05:48
piece handle=/u01/app/oracle/flash_recovery_area/ACME/autobackup/2013_08_22/o1_mf_s_824148348_91f6bfxw_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-08-22:18:05:51
RMAN> list copy of tablespace example;
List of Datafile Copies
=======================
Key     File S Completion Time     Ckp SCN    Ckp Time          
------- ---- - ------------------- ---------- -------------------
4       5    A 2013-08-22:17:42:08 2084754    2013-08-22:17:42:00
        Name: /u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_example_91f4xrrq_.dbf
        Tag: BACKUP_INCR

RMAN> backup incremental level 1 for recover of copy with tag 'backup_incr' database;
Starting backup at 2013-08-22:18:19:54
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/acme/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/acme/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/acme/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/acme/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/acme/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2013-08-22:18:19:55
channel ORA_DISK_1: finished piece 1 at 2013-08-22:18:21:00
piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2013_08_22/o1_mf_nnnd1_BACKUP_INCR_91f74vxw_.bkp tag=BACKUP_INCR comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 2013-08-22:18:21:01
Starting Control File and SPFILE Autobackup at 2013-08-22:18:21:01
piece handle=/u01/app/oracle/flash_recovery_area/ACME/autobackup/2013_08_22/o1_mf_s_824149261_91f76z85_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-08-22:18:21:04
RMAN> list copy of tablespace example;
List of Datafile Copies
=======================
Key     File S Completion Time     Ckp SCN    Ckp Time          
------- ---- - ------------------- ---------- -------------------
4       5    A 2013-08-22:17:42:08 2084754    2013-08-22:17:42:00
        Name: /u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_example_91f4xrrq_.dbf
        Tag: BACKUP_INCR

RMAN> recover copy of tablespace example with tag 'backup_incr';        
Starting recover at 2013-08-22:18:31:13
using channel ORA_DISK_1
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=43 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: WARNING: Oracle Test Disk API
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile copies to recover
recovering datafile copy file number=00005 name=/u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_example_91f4xrrq_.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ACME/backupset/2013_08_22/o1_mf_nnnd1_BACKUP_INCR_91f67v6c_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2013_08_22/o1_mf_nnnd1_BACKUP_INCR_91f67v6c_.bkp tag=BACKUP_INCR
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile copies to recover
recovering datafile copy file number=00005 name=/u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_example_91f4xrrq_.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ACME/backupset/2013_08_22/o1_mf_nnnd1_BACKUP_INCR_91f74vxw_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2013_08_22/o1_mf_nnnd1_BACKUP_INCR_91f74vxw_.bkp tag=BACKUP_INCR
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished recover at 2013-08-22:18:31:19
Starting Control File and SPFILE Autobackup at 2013-08-22:18:31:19
piece handle=/u01/app/oracle/flash_recovery_area/ACME/autobackup/2013_08_22/o1_mf_s_824149879_91f7t7yj_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2013-08-22:18:31:22
RMAN> list copy of tablespace example;
List of Datafile Copies
=======================
Key     File S Completion Time     Ckp SCN    Ckp Time          
------- ---- - ------------------- ---------- -------------------
8       5    A 2013-08-22:18:31:18 2087900    2013-08-22:18:19:55
        Name: /u01/app/oracle/flash_recovery_area/ACME/datafile/o1_mf_example_91f4xrrq_.dbf
        Tag: BACKUP_INCR

RMAN>