Friday, June 10, 2011

RMAN Archival backup example


[oracle@vmxdb01 admin]$ rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Fri Jun 10 17:30:49 2011

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

connected to target database: PRORCL (DBID=4079219725)



RMAN> backup database tag archival_backup_example keep forever restore point jun2011;

Starting backup at 10-JUN-11
current log archived

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/10/2011 17:31:53
RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog



RMAN> backup database tag archival_backup_example keep until time 'sysdate+365' restore point jun2011;

Starting backup at 10-JUN-11
current log archived

using channel ORA_DISK_1
backup will be obsolete on date 09-JUN-12
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/prorcl/users01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/prorcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/prorcl/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 10-JUN-11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/10/2011 17:32:36
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes


RMAN> backup database tag archival_backup_example keep until time 'sysdate+365' restore point jun2011
2> format '/u01/backup/prorcl_%U';

Starting backup at 10-JUN-11
current log archived

using channel ORA_DISK_1
backup will be obsolete on date 09-JUN-12
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/prorcl/users01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/prorcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/prorcl/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 10-JUN-11
channel ORA_DISK_1: finished piece 1 at 10-JUN-11
piece handle=/u01/backup/prorcl_2amei3n8_1_1 tag=ARCHIVAL_BACKUP_EXAMPLE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

using channel ORA_DISK_1
backup will be obsolete on date 09-JUN-12
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 10-JUN-11
channel ORA_DISK_1: finished piece 1 at 10-JUN-11
piece handle=/u01/backup/prorcl_2bmei3o1_1_1 tag=ARCHIVAL_BACKUP_EXAMPLE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01


current log archived
using channel ORA_DISK_1
backup will be obsolete on date 09-JUN-12
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=11 RECID=172 STAMP=753471234
channel ORA_DISK_1: starting piece 1 at 10-JUN-11
channel ORA_DISK_1: finished piece 1 at 10-JUN-11
piece handle=/u01/backup/prorcl_2cmei3o2_1_1 tag=ARCHIVAL_BACKUP_EXAMPLE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1
backup will be obsolete on date 09-JUN-12
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 10-JUN-11
channel ORA_DISK_1: finished piece 1 at 10-JUN-11
piece handle=/u01/backup/prorcl_2dmei3o3_1_1 tag=ARCHIVAL_BACKUP_EXAMPLE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-JUN-11




RMAN> list backup;


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


BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19 Full 42.27M DISK 00:00:15 10-JUN-11
BP Key: 69 Status: AVAILABLE Compressed: YES Tag: ARCHIVAL_BACKUP_EXAMPLE
Piece Name: /u01/backup/prorcl_2amei3n8_1_1
Keep: BACKUP_LOGS Until: 09-JUN-12
List of Datafiles in backup set 19
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 487509 10-JUN-11 /u01/app/oracle/oradata/prorcl/system01.dbf
2 Full 487509 10-JUN-11 /u01/app/oracle/oradata/prorcl/sysaux01.dbf
3 Full 487509 10-JUN-11 /u01/app/oracle/oradata/prorcl/undotbs01.dbf
4 Full 487509 10-JUN-11 /u01/app/oracle/oradata/prorcl/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20 Full 80.00K DISK 00:00:00 10-JUN-11
BP Key: 70 Status: AVAILABLE Compressed: YES Tag: ARCHIVAL_BACKUP_EXAMPLE
Piece Name: /u01/backup/prorcl_2bmei3o1_1_1
Keep: BACKUP_LOGS Until: 09-JUN-12
SPFILE Included: Modification time: 10-JUN-11
SPFILE db_unique_name: PRORCL

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
21 16.50K DISK 00:00:00 10-JUN-11
BP Key: 71 Status: AVAILABLE Compressed: YES Tag: ARCHIVAL_BACKUP_EXAMPLE
Piece Name: /u01/backup/prorcl_2cmei3o2_1_1
Keep: BACKUP_LOGS Until: 09-JUN-12

List of Archived Logs in backup set 21
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 11 487505 10-JUN-11 487549 10-JUN-11

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22 Full 1.03M DISK 00:00:01 10-JUN-11
BP Key: 72 Status: AVAILABLE Compressed: YES Tag: ARCHIVAL_BACKUP_EXAMPLE
Piece Name: /u01/backup/prorcl_2dmei3o3_1_1
Keep: BACKUP_LOGS Until: 09-JUN-12
Control File Included: Ckp SCN: 487554 Ckp time: 10-JUN-11


[oracle@vmxdb01 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 10 17:37:54 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$restore_point;

SCN DATABASE_INCARNATION# GUA STORAGE_SIZE
---------- --------------------- --- ------------
TIME
---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE
--------------------------------------------------------------------------- ---
NAME
--------------------------------------------------------------------------------
487539 3 NO 0
10-JUN-11 05.33.54.000000000 PM
NO
JUN2011


SQL> exit