*************************** Backup der GRIDDB-Datenbank *************************** Recovery Manager: Release 10.2.0.3.0 - Production on Tue Jul 1 16:00:04 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: GRIDDB (DBID=2069196047) RMAN> RMAN> 2> using target database control file instead of recovery catalog sql statement: alter session set optimizer_mode=rule RMAN> RMAN> 2> old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters are successfully stored RMAN> RMAN> 2> RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata/backup/griddb/%F'; CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oradata/backup/griddb/%U'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oraapps/griddb/dbs/snapcf_griddb.f'; # default RMAN> RMAN> 2> Starting recover at 01.07.2008 16:00:05 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=111 devtype=DISK channel ORA_DISK_1: starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile copies to recover recovering datafile copy fno=00001 name=/oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-SYSTEM_FNO-1_0njkcuct recovering datafile copy fno=00002 name=/oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-UNDOTBS1_FNO-2_0ojkcudc recovering datafile copy fno=00003 name=/oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-SYSAUX_FNO-3_0pjkcudr recovering datafile copy fno=00004 name=/oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-USERS_FNO-4_0rjkcued recovering datafile copy fno=00005 name=/oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-MGMT_TABLESPACE_FNO-5_0mjkcuai recovering datafile copy fno=00006 name=/oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-MGMT_ECM_DEPOT_TS_FNO-6_0qjkcuea channel ORA_DISK_1: reading from backup piece /oradata/backup/griddb/1ijkdac5_1_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/oradata/backup/griddb/1ijkdac5_1_1 tag=TAG20080701T153221 channel ORA_DISK_1: restore complete, elapsed time: 00:00:04 Finished recover at 01.07.2008 16:00:10 Starting Control File and SPFILE Autobackup at 01.07.2008 16:00:10 piece handle=/oradata/backup/griddb/c-2069196047-20080701-10 comment=NONE Finished Control File and SPFILE Autobackup at 01.07.2008 16:00:12 RMAN> Starting backup at 01.07.2008 16:00:12 using channel ORA_DISK_1 channel ORA_DISK_1: starting incremental level 1 datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00005 name=/oradata/griddb/mgmt01.dbf input datafile fno=00001 name=/oradata/griddb/system01.dbf input datafile fno=00002 name=/oradata/griddb/undotbs01.dbf input datafile fno=00003 name=/oradata/griddb/sysaux01.dbf input datafile fno=00006 name=/oradata/griddb/mgmt_ecm_depot01.dbf input datafile fno=00004 name=/oradata/griddb/users01.dbf channel ORA_DISK_1: starting piece 1 at 01.07.2008 16:00:12 channel ORA_DISK_1: finished piece 1 at 01.07.2008 16:00:19 piece handle=/oradata/backup/griddb/1ljkdc0c_1_1 tag=TAG20080701T160012 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 Finished backup at 01.07.2008 16:00:19 Starting Control File and SPFILE Autobackup at 01.07.2008 16:00:19 piece handle=/oradata/backup/griddb/c-2069196047-20080701-11 comment=NONE Finished Control File and SPFILE Autobackup at 01.07.2008 16:00:21 RMAN> RMAN> 2> RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of obsolete backups and copies Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Archive Log 809 01.07.2008 15:28:21 /oradata/backup/griddb/archive/1_6194_644095887.arc Backup Set 30 01.07.2008 15:32:24 Backup Piece 30 01.07.2008 15:32:24 /oradata/backup/griddb/1ijkdac5_1_1 Backup Set 31 01.07.2008 15:32:24 Backup Piece 31 01.07.2008 15:32:24 /oradata/backup/griddb/c-2069196047-20080701-0f Backup Set 32 01.07.2008 16:00:10 Backup Piece 32 01.07.2008 16:00:10 /oradata/backup/griddb/c-2069196047-20080701-10 RMAN> RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 using channel ORA_DISK_1 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Archive Log 809 01.07.2008 15:28:21 /oradata/backup/griddb/archive/1_6194_644095887.arc Backup Set 30 01.07.2008 15:32:24 Backup Piece 30 01.07.2008 15:32:24 /oradata/backup/griddb/1ijkdac5_1_1 Backup Set 31 01.07.2008 15:32:24 Backup Piece 31 01.07.2008 15:32:24 /oradata/backup/griddb/c-2069196047-20080701-0f Backup Set 32 01.07.2008 16:00:10 Backup Piece 32 01.07.2008 16:00:10 /oradata/backup/griddb/c-2069196047-20080701-10 deleted archive log archive log filename=/oradata/backup/griddb/archive/1_6194_644095887.arc recid=809 stamp=658942101 deleted backup piece backup piece handle=/oradata/backup/griddb/1ijkdac5_1_1 recid=30 stamp=658942343 deleted backup piece backup piece handle=/oradata/backup/griddb/c-2069196047-20080701-0f recid=31 stamp=658942344 deleted backup piece backup piece handle=/oradata/backup/griddb/c-2069196047-20080701-10 recid=32 stamp=658944010 Deleted 4 objects RMAN> RMAN> 2> List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- ------------------- ------- ------- ---------- --- 33 B 1 A DISK 01.07.2008 16:00:17 1 1 NO TAG20080701T160012 34 B F A DISK 01.07.2008 16:00:20 1 1 NO TAG20080701T160019 RMAN> List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 33 Incr 1 40.58M DISK 00:00:05 01.07.2008 16:00:17 BP Key: 33 Status: AVAILABLE Compressed: NO Tag: TAG20080701T160012 Piece Name: /oradata/backup/griddb/1ljkdc0c_1_1 List of Datafiles in backup set 33 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- ------------------- ---- 1 1 Incr 56078622 01.07.2008 16:00:12 /oradata/griddb/system01.dbf 2 1 Incr 56078622 01.07.2008 16:00:12 /oradata/griddb/undotbs01.dbf 3 1 Incr 56078622 01.07.2008 16:00:12 /oradata/griddb/sysaux01.dbf 4 1 Incr 56078622 01.07.2008 16:00:12 /oradata/griddb/users01.dbf 5 1 Incr 56078622 01.07.2008 16:00:12 /oradata/griddb/mgmt01.dbf 6 1 Incr 56078622 01.07.2008 16:00:12 /oradata/griddb/mgmt_ecm_depot01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 34 Full 7.20M DISK 00:00:01 01.07.2008 16:00:20 BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20080701T160019 Piece Name: /oradata/backup/griddb/c-2069196047-20080701-11 Control File Included: Ckp SCN: 56078671 Ckp time: 01.07.2008 16:00:19 SPFILE Included: Modification time: 30.06.2008 22:00:55 RMAN> RMAN> 2> specification does not match any archive log in the recovery catalog List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - ------------------- ---------- ------------------- ---- 58 1 A 01.07.2008 16:00:07 56071049 01.07.2008 15:32:21 /oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-SYSTEM_FNO-1_0njkcuct 61 2 A 01.07.2008 16:00:07 56071049 01.07.2008 15:32:21 /oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-UNDOTBS1_FNO-2_0ojkcudc 60 3 A 01.07.2008 16:00:07 56071049 01.07.2008 15:32:21 /oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-SYSAUX_FNO-3_0pjkcudr 57 4 A 01.07.2008 16:00:07 56071049 01.07.2008 15:32:21 /oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-USERS_FNO-4_0rjkcued 62 5 A 01.07.2008 16:00:09 56071049 01.07.2008 15:32:21 /oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-MGMT_TABLESPACE_FNO-5_0mjkcuai 59 6 A 01.07.2008 16:00:07 56071049 01.07.2008 15:32:21 /oradata/backup/griddb/data_D-GRIDDB_I-2069196047_TS-MGMT_ECM_DEPOT_TS_FNO-6_0qjkcuea RMAN> RMAN> 2> List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 GRIDDB 2069196047 CURRENT 1 15.01.2008 19:31:27 RMAN> RMAN> 2> Recovery Manager complete. ***************************