Oracle 10g RAC RMAN backup Example
来源:互联网 发布:淘宝的劲霸官方旗舰店 编辑:程序博客网 时间:2024/05/11 22:49
Database Version: 10.2.0.5 3nodes
Verify the databases are in archivelog mode and archive destination
racnode1
[oracle@racnode1 arch]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 25 14:31:03 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination /u01/app/oracle/archOldest online log sequence 17Next log sequence to archive 18Current log sequence 18
racnode2
[oracle@racnode2 arch]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 25 14:32:17 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination /u01/app/oracle/archOldest online log sequence 9Next log sequence to archive 10Current log sequence 10
racnode3
[oracle@racnode3 arch]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 25 14:32:43 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination /u01/app/oracle/archOldest online log sequence 2Next log sequence to archive 3Current log sequence 3
Verify connectivity to the target nodes and catalog if used
[oracle@racnode3 arch]$ sqlplus /nologSQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 25 14:34:59 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.SQL> conn sys/oracle@racdb1 as sysdbaConnected.SQL> conn sys/oracle@racdb2 as sysdbaConnected.SQL> conn sys/oracle@racdb3 as sysdbaConnected.SQL> conn sys/oracle@racdb as sysdbaConnected.SQL>
Connect using RMAN to verify and set the controlfile persistent configuration
[oracle@racnode1 backup]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Tue Dec 25 14:40:45 2012Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: RACDB (DBID=800157471)RMAN> show all;using target database control file instead of recovery catalogRMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_racdb1.f'; # defaultRMAN>
RMAN> configure retention policy to redundancy 3;new RMAN configuration parameters:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;new RMAN configuration parameters are successfully storedRMAN> configure controlfile autobackup on;new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters are successfully storedRMAN> configure controlfile autobackup format for device type disk to '/u01/app/oracle/backup/%F';new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';new RMAN configuration parameters are successfully storedRMAN> configure device type disk parallelism 3;new RMAN configuration parameters:CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;new RMAN configuration parameters are successfully storedRMAN> configure channel 1 device type disk connect sys/oracle@racdb1;new RMAN configuration parameters:CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedRMAN> configure channel 2 device type disk connect sys/oracle@racdb2;new RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedRMAN> configure channel 3 device type disk connect 'sys/oracle@racdb3';new RMAN configuration parameters:CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedRMAN>
RMAN> show all;RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;CONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';CONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_racdb1.f'; # defaultRMAN>
backup incremental level 0
[oracle@racnode1 backup]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Tue Dec 25 15:09:42 2012Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: RACDB (DBID=800157471)RMAN> run{2> configure retention policy to redundancy 3;3> configure controlfile autobackup on;4> configure controlfile autobackup format for device type disk to '/u01/app/oracle/backup/%F';5> configure device type disk parallelism 3;6> configure channel 1 device type disk connect sys/oracle@racdb1;7> configure channel 2 device type disk connect sys/oracle@racdb2;8> configure channel 3 device type disk connect sys/oracle@racdb3;9> configure maxsetsize to unlimited;10> backup incremental level 011> format '/u01/app/oracle/backup/%d_LVL0_%T_%u_s%s_p%p' tag 'DB_INC0'12> database;13> backup archivelog all format '/u01/app/oracle/backup/%d_ARCH_%T_%u_s%s_p%p' tag 'ARCH_INC0'14> delete input;15> }using target database control file instead of recovery catalogold RMAN configuration parameters:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;new RMAN configuration parameters:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;new RMAN configuration parameters:CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE MAXSETSIZE TO UNLIMITED;new RMAN configuration parameters:CONFIGURE MAXSETSIZE TO UNLIMITED;new RMAN configuration parameters are successfully storedStarting backup at 25-DEC-2012 15:12:32allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=845 instance=racdb1 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=855 instance=racdb2 devtype=DISKallocated channel: ORA_DISK_3channel ORA_DISK_3: sid=848 instance=racdb3 devtype=DISKchannel ORA_DISK_1: starting incremental level 0 datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=+DATADG/racdb/datafile/system.256.802540615channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:12:35channel ORA_DISK_2: starting incremental level 0 datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=00003 name=+DATADG/racdb/datafile/sysaux.257.802540615input datafile fno=00006 name=+DATADG/racdb/datafile/undotbs2.265.802540981input datafile fno=00004 name=+DATADG/racdb/datafile/users.259.802540615channel ORA_DISK_2: starting piece 1 at 25-DEC-2012 15:12:35channel ORA_DISK_3: starting incremental level 0 datafile backupsetchannel ORA_DISK_3: specifying datafile(s) in backupsetinput datafile fno=00005 name=+DATADG/racdb/datafile/example.264.802540751input datafile fno=00002 name=+DATADG/racdb/datafile/undotbs1.258.802540615input datafile fno=00007 name=+DATADG/racdb/datafile/undotbs3.269.802888323channel ORA_DISK_3: starting piece 1 at 25-DEC-2012 15:12:36channel ORA_DISK_3: finished piece 1 at 25-DEC-2012 15:13:01piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_03ntomb3_s3_p1 tag=DB_INC0 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:26channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:13:46piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_01ntomb3_s1_p1 tag=DB_INC0 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:11channel ORA_DISK_2: finished piece 1 at 25-DEC-2012 15:13:47piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_02ntomb3_s2_p1 tag=DB_INC0 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:01:12Finished backup at 25-DEC-2012 15:13:46Starting backup at 25-DEC-2012 15:13:50current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=3 sequence=3 recid=29 stamp=802970034channel ORA_DISK_3: starting piece 1 at 25-DEC-2012 15:13:56channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=15 recid=22 stamp=802967112channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:13:56channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=2 sequence=10 recid=28 stamp=802970033channel ORA_DISK_2: starting piece 1 at 25-DEC-2012 15:13:57channel ORA_DISK_3: finished piece 1 at 25-DEC-2012 15:13:57piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_06ntomdk_s6_p1 tag=ARCH_INC0 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:01channel ORA_DISK_3: deleting archive log(s)archive log filename=/u01/app/oracle/arch/3_3_802540708.dbf recid=29 stamp=802970034channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:13:58piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_04ntomdk_s4_p1 tag=ARCH_INC0 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/u01/app/oracle/arch/1_15_802540708.dbf recid=22 stamp=802967112channel ORA_DISK_2: finished piece 1 at 25-DEC-2012 15:13:59piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_05ntomdk_s5_p1 tag=ARCH_INC0 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:03channel ORA_DISK_2: deleting archive log(s)archive log filename=/u01/app/oracle/arch/2_10_802540708.dbf recid=28 stamp=802970033channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=18 recid=27 stamp=802970031channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:13:58channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:13:59piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_07ntomdm_s7_p1 tag=ARCH_INC0 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01channel ORA_DISK_1: deleting archive log(s)archive log filename=/u01/app/oracle/arch/1_18_802540708.dbf recid=27 stamp=802970031channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=16 recid=24 stamp=802967124input archive log thread=1 sequence=17 recid=25 stamp=802967126channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:14:01channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:14:02piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_08ntomdo_s8_p1 tag=ARCH_INC0 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/u01/app/oracle/arch/1_16_802540708.dbf recid=24 stamp=802967124archive log filename=/u01/app/oracle/arch/1_17_802540708.dbf recid=25 stamp=802967126Finished backup at 25-DEC-2012 15:14:02Starting Control File and SPFILE Autobackup at 25-DEC-2012 15:14:02piece handle=/u01/app/oracle/backup/c-800157471-20121225-00 comment=NONEFinished Control File and SPFILE Autobackup at 25-DEC-2012 15:14:09RMAN>
backup incremental level 1
RMAN> run{2> configure retention policy to redundancy 3;3> configure controlfile autobackup on;4> configure controlfile autobackup format for device type disk to '/u01/app/oracle/backup/%F';5> configure device type disk parallelism 3;6> configure channel 1 device type disk connect sys/oracle@racdb1;7> configure channel 2 device type disk connect sys/oracle@racdb2;8> configure channel 3 device type disk connect sys/oracle@racdb3;9> configure maxsetsize to unlimited;10> backup incremental level 111> format '/u01/app/oracle/backup/%d_LVL1_%T_%u_s%s_p%p' tag 'DB_INC1'12> database;13> backup archivelog all format '/u01/app/oracle/backup/%d_ARCH_%T_%u_s%s_p%p' tag 'ARCH_INC1'14> delete input;15> crosscheck backupset;16> delete noprompt expired backup;17> delete noprompt obsolete;18> }old RMAN configuration parameters:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;new RMAN configuration parameters:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;new RMAN configuration parameters:CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;new RMAN configuration parameters are successfully storedreleased channel: ORA_DISK_1released channel: ORA_DISK_2released channel: ORA_DISK_3old RMAN configuration parameters:CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE MAXSETSIZE TO UNLIMITED;new RMAN configuration parameters:CONFIGURE MAXSETSIZE TO UNLIMITED;new RMAN configuration parameters are successfully storedStarting backup at 25-DEC-2012 15:24:50allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=845 instance=racdb1 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=855 instance=racdb2 devtype=DISKallocated channel: ORA_DISK_3channel ORA_DISK_3: sid=848 instance=racdb3 devtype=DISKchannel ORA_DISK_1: starting incremental level 1 datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=+DATADG/racdb/datafile/system.256.802540615channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:24:53channel ORA_DISK_2: starting incremental level 1 datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=00003 name=+DATADG/racdb/datafile/sysaux.257.802540615input datafile fno=00006 name=+DATADG/racdb/datafile/undotbs2.265.802540981input datafile fno=00004 name=+DATADG/racdb/datafile/users.259.802540615channel ORA_DISK_2: starting piece 1 at 25-DEC-2012 15:24:53channel ORA_DISK_3: starting incremental level 1 datafile backupsetchannel ORA_DISK_3: specifying datafile(s) in backupsetinput datafile fno=00005 name=+DATADG/racdb/datafile/example.264.802540751input datafile fno=00002 name=+DATADG/racdb/datafile/undotbs1.258.802540615input datafile fno=00007 name=+DATADG/racdb/datafile/undotbs3.269.802888323channel ORA_DISK_3: starting piece 1 at 25-DEC-2012 15:25:02channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:25:05piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0anton25_s10_p1 tag=DB_INC1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:12channel ORA_DISK_2: finished piece 1 at 25-DEC-2012 15:25:20piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0bnton25_s11_p1 tag=DB_INC1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:27channel ORA_DISK_3: finished piece 1 at 25-DEC-2012 15:25:20piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0cnton25_s12_p1 tag=DB_INC1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:27Finished backup at 25-DEC-2012 15:25:20Starting backup at 25-DEC-2012 15:25:24current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=19 recid=30 stamp=802970726channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:25:33channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=2 sequence=11 recid=31 stamp=802970726channel ORA_DISK_2: starting piece 1 at 25-DEC-2012 15:25:33channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=3 sequence=4 recid=32 stamp=802970727channel ORA_DISK_3: starting piece 1 at 25-DEC-2012 15:25:34channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:25:34piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0dnton3c_s13_p1 tag=ARCH_INC1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/u01/app/oracle/arch/1_19_802540708.dbf recid=30 stamp=802970726channel ORA_DISK_2: finished piece 1 at 25-DEC-2012 15:25:34piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0enton3c_s14_p1 tag=ARCH_INC1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: deleting archive log(s)archive log filename=/u01/app/oracle/arch/2_11_802540708.dbf recid=31 stamp=802970726channel ORA_DISK_3: finished piece 1 at 25-DEC-2012 15:25:34piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0fnton3c_s15_p1 tag=ARCH_INC1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:02channel ORA_DISK_3: deleting archive log(s)archive log filename=/u01/app/oracle/arch/3_4_802540708.dbf recid=32 stamp=802970727Finished backup at 25-DEC-2012 15:25:34Starting Control File and SPFILE Autobackup at 25-DEC-2012 15:25:34piece handle=/u01/app/oracle/backup/c-800157471-20121225-01 comment=NONEFinished Control File and SPFILE Autobackup at 25-DEC-2012 15:25:41using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_01ntomb3_s1_p1 recid=3 stamp=802969955crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_04ntomdk_s4_p1 recid=5 stamp=802970036crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_07ntomdm_s7_p1 recid=7 stamp=802970038crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_08ntomdo_s8_p1 recid=8 stamp=802970041crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/c-800157471-20121225-00 recid=9 stamp=802970045crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0anton25_s10_p1 recid=10 stamp=802970693crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0dnton3c_s13_p1 recid=13 stamp=802970733crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/c-800157471-20121225-01 recid=16 stamp=802970736Crosschecked 8 objectscrosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_02ntomb3_s2_p1 recid=2 stamp=802969956crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_05ntomdk_s5_p1 recid=6 stamp=802970037crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0bnton25_s11_p1 recid=12 stamp=802970702crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0enton3c_s14_p1 recid=14 stamp=802970733Crosschecked 4 objectscrosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_03ntomb3_s3_p1 recid=1 stamp=802969965crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_06ntomdk_s6_p1 recid=4 stamp=802970036crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0cnton25_s12_p1 recid=11 stamp=802970706crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0fnton3c_s15_p1 recid=15 stamp=802970734Crosschecked 4 objectsusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 3using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3no obsolete backups foundRMAN>
summary
RMAN> list backupset;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------1 Incr 0 66.25M DISK 00:00:24 25-DEC-2012 15:12:59 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: DB_INC0 Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_03ntomb3_s3_p1 List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 2 0 Incr 930970 25-DEC-2012 15:12:42 +DATADG/racdb/datafile/undotbs1.258.802540615 5 0 Incr 930970 25-DEC-2012 15:12:42 +DATADG/racdb/datafile/example.264.802540751 7 0 Incr 930970 25-DEC-2012 15:12:42 +DATADG/racdb/datafile/undotbs3.269.802888323BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------2 Incr 0 263.96M DISK 00:01:05 25-DEC-2012 15:13:40 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: DB_INC0 Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_02ntomb3_s2_p1 List of Datafiles in backup set 2 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 3 0 Incr 930964 25-DEC-2012 15:12:35 +DATADG/racdb/datafile/sysaux.257.802540615 4 0 Incr 930964 25-DEC-2012 15:12:35 +DATADG/racdb/datafile/users.259.802540615 6 0 Incr 930964 25-DEC-2012 15:12:35 +DATADG/racdb/datafile/undotbs2.265.802540981BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------3 Incr 0 370.38M DISK 00:01:07 25-DEC-2012 15:13:42 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: DB_INC0 Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_01ntomb3_s1_p1 List of Datafiles in backup set 3 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 1 0 Incr 930959 25-DEC-2012 15:12:35 +DATADG/racdb/datafile/system.256.802540615BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------4 693.00K DISK 00:00:01 25-DEC-2012 15:13:57 BP Key: 4 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_06ntomdk_s6_p1 List of Archived Logs in backup set 4 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 3 3 926740 25-DEC-2012 14:25:27 931028 25-DEC-2012 15:13:53BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------5 3.30M DISK 00:00:01 25-DEC-2012 15:13:57 BP Key: 5 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_04ntomdk_s4_p1 List of Archived Logs in backup set 5 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 15 892350 25-DEC-2012 11:24:17 926723 25-DEC-2012 14:25:11BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------6 791.50K DISK 00:00:02 25-DEC-2012 15:13:58 BP Key: 6 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_05ntomdk_s5_p1 List of Archived Logs in backup set 6 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 2 10 926728 25-DEC-2012 14:25:14 931026 25-DEC-2012 15:13:52BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------7 1.43M DISK 00:00:01 25-DEC-2012 15:13:59 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_07ntomdm_s7_p1 List of Archived Logs in backup set 7 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 18 926737 25-DEC-2012 14:25:26 931023 25-DEC-2012 15:13:51BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------8 3.50K DISK 00:00:01 25-DEC-2012 15:14:01 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_08ntomdo_s8_p1 List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 16 926723 25-DEC-2012 14:25:11 926734 25-DEC-2012 14:25:23 1 17 926734 25-DEC-2012 14:25:23 926737 25-DEC-2012 14:25:26BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------9 Full 14.67M DISK 00:00:04 25-DEC-2012 15:14:06 BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20121225T151402 Piece Name: /u01/app/oracle/backup/c-800157471-20121225-00 Control File Included: Ckp SCN: 931040 Ckp time: 25-DEC-2012 15:14:02 SPFILE Included: Modification time: 25-DEC-2012 14:23:24BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------10 Incr 1 128.00K DISK 00:00:09 25-DEC-2012 15:25:02 BP Key: 10 Status: AVAILABLE Compressed: NO Tag: DB_INC1 Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0anton25_s10_p1 List of Datafiles in backup set 10 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 1 1 Incr 931568 25-DEC-2012 15:24:53 +DATADG/racdb/datafile/system.256.802540615BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------11 Incr 1 232.00K DISK 00:00:21 25-DEC-2012 15:25:14 BP Key: 11 Status: AVAILABLE Compressed: NO Tag: DB_INC1 Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0cnton25_s12_p1 List of Datafiles in backup set 11 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 2 1 Incr 931576 25-DEC-2012 15:25:03 +DATADG/racdb/datafile/undotbs1.258.802540615 5 1 Incr 931576 25-DEC-2012 15:25:03 +DATADG/racdb/datafile/example.264.802540751 7 1 Incr 931576 25-DEC-2012 15:25:03 +DATADG/racdb/datafile/undotbs3.269.802888323BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------12 Incr 1 208.00K DISK 00:00:21 25-DEC-2012 15:25:14 BP Key: 12 Status: AVAILABLE Compressed: NO Tag: DB_INC1 Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0bnton25_s11_p1 List of Datafiles in backup set 12 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 3 1 Incr 931570 25-DEC-2012 15:24:53 +DATADG/racdb/datafile/sysaux.257.802540615 4 1 Incr 931570 25-DEC-2012 15:24:53 +DATADG/racdb/datafile/users.259.802540615 6 1 Incr 931570 25-DEC-2012 15:24:53 +DATADG/racdb/datafile/undotbs2.265.802540981BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------13 38.00K DISK 00:00:02 25-DEC-2012 15:25:34 BP Key: 13 Status: AVAILABLE Compressed: NO Tag: ARCH_INC1 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0dnton3c_s13_p1 List of Archived Logs in backup set 13 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 19 931023 25-DEC-2012 15:13:51 931599 25-DEC-2012 15:25:25BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------14 58.00K DISK 00:00:02 25-DEC-2012 15:25:34 BP Key: 14 Status: AVAILABLE Compressed: NO Tag: ARCH_INC1 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0enton3c_s14_p1 List of Archived Logs in backup set 14 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 2 11 931026 25-DEC-2012 15:13:52 931601 25-DEC-2012 15:25:26BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------15 5.00K DISK 00:00:02 25-DEC-2012 15:25:34 BP Key: 15 Status: AVAILABLE Compressed: NO Tag: ARCH_INC1 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0fnton3c_s15_p1 List of Archived Logs in backup set 15 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 3 4 931028 25-DEC-2012 15:13:53 931604 25-DEC-2012 15:25:26BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------16 Full 14.67M DISK 00:00:04 25-DEC-2012 15:25:38 BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20121225T152534 Piece Name: /u01/app/oracle/backup/c-800157471-20121225-01 Control File Included: Ckp SCN: 931613 Ckp time: 25-DEC-2012 15:25:34 SPFILE Included: Modification time: 25-DEC-2012 14:23:24RMAN>
RMAN> list backupset summary;List of Backups===============Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag------- -- -- - ----------- -------------------- ------- ------- ---------- ---1 B 0 A DISK 25-DEC-2012 15:12:59 1 1 NO DB_INC02 B 0 A DISK 25-DEC-2012 15:13:40 1 1 NO DB_INC03 B 0 A DISK 25-DEC-2012 15:13:42 1 1 NO DB_INC04 B A A DISK 25-DEC-2012 15:13:57 1 1 NO ARCH_INC05 B A A DISK 25-DEC-2012 15:13:57 1 1 NO ARCH_INC06 B A A DISK 25-DEC-2012 15:13:58 1 1 NO ARCH_INC07 B A A DISK 25-DEC-2012 15:13:59 1 1 NO ARCH_INC08 B A A DISK 25-DEC-2012 15:14:01 1 1 NO ARCH_INC09 B F A DISK 25-DEC-2012 15:14:06 1 1 NO TAG20121225T15140210 B 1 A DISK 25-DEC-2012 15:25:02 1 1 NO DB_INC111 B 1 A DISK 25-DEC-2012 15:25:14 1 1 NO DB_INC112 B 1 A DISK 25-DEC-2012 15:25:14 1 1 NO DB_INC113 B A A DISK 25-DEC-2012 15:25:34 1 1 NO ARCH_INC114 B A A DISK 25-DEC-2012 15:25:34 1 1 NO ARCH_INC115 B A A DISK 25-DEC-2012 15:25:34 1 1 NO ARCH_INC116 B F A DISK 25-DEC-2012 15:25:38 1 1 NO TAG20121225T152534RMAN>
RMAN> list backup by file;List of Datafile Backups========================File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag---- ------- - -- - ---------- -------------------- ------- ------- ---------- ---1 10 B 1 A 931568 25-DEC-2012 15:24:53 1 1 NO DB_INC1 3 B 0 A 930959 25-DEC-2012 15:12:35 1 1 NO DB_INC02 11 B 1 A 931576 25-DEC-2012 15:25:03 1 1 NO DB_INC1 1 B 0 A 930970 25-DEC-2012 15:12:42 1 1 NO DB_INC03 12 B 1 A 931570 25-DEC-2012 15:24:53 1 1 NO DB_INC1 2 B 0 A 930964 25-DEC-2012 15:12:35 1 1 NO DB_INC04 12 B 1 A 931570 25-DEC-2012 15:24:53 1 1 NO DB_INC1 2 B 0 A 930964 25-DEC-2012 15:12:35 1 1 NO DB_INC05 11 B 1 A 931576 25-DEC-2012 15:25:03 1 1 NO DB_INC1 1 B 0 A 930970 25-DEC-2012 15:12:42 1 1 NO DB_INC06 12 B 1 A 931570 25-DEC-2012 15:24:53 1 1 NO DB_INC1 2 B 0 A 930964 25-DEC-2012 15:12:35 1 1 NO DB_INC07 11 B 1 A 931576 25-DEC-2012 15:25:03 1 1 NO DB_INC1 1 B 0 A 930970 25-DEC-2012 15:12:42 1 1 NO DB_INC0List of Archived Log Backups============================Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag---- ------- ---------- -------------------- ------- - ------- ------- ---------- ---1 15 892350 25-DEC-2012 11:24:17 5 A 1 1 NO ARCH_INC01 16 926723 25-DEC-2012 14:25:11 8 A 1 1 NO ARCH_INC01 17 926734 25-DEC-2012 14:25:23 8 A 1 1 NO ARCH_INC01 18 926737 25-DEC-2012 14:25:26 7 A 1 1 NO ARCH_INC01 19 931023 25-DEC-2012 15:13:51 13 A 1 1 NO ARCH_INC12 10 926728 25-DEC-2012 14:25:14 6 A 1 1 NO ARCH_INC02 11 931026 25-DEC-2012 15:13:52 14 A 1 1 NO ARCH_INC13 3 926740 25-DEC-2012 14:25:27 4 A 1 1 NO ARCH_INC03 4 931028 25-DEC-2012 15:13:53 15 A 1 1 NO ARCH_INC1List of Control File Backups============================CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag---------- -------------------- ------- - ------- ------- ---------- ---931613 25-DEC-2012 15:25:34 16 A 1 1 NO TAG20121225T152534931040 25-DEC-2012 15:14:02 9 A 1 1 NO TAG20121225T151402List of SPFILE Backups======================Modification Time BS Key S #Pieces #Copies Compressed Tag-------------------- ------- - ------- ------- ---------- ---25-DEC-2012 14:23:24 16 A 1 1 NO TAG20121225T15253425-DEC-2012 14:23:24 9 A 1 1 NO TAG20121225T151402RMAN>
RMAN> list backup of database;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------1 Incr 0 66.25M DISK 00:00:24 25-DEC-2012 15:12:59 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: DB_INC0 Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_03ntomb3_s3_p1 List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 2 0 Incr 930970 25-DEC-2012 15:12:42 +DATADG/racdb/datafile/undotbs1.258.802540615 5 0 Incr 930970 25-DEC-2012 15:12:42 +DATADG/racdb/datafile/example.264.802540751 7 0 Incr 930970 25-DEC-2012 15:12:42 +DATADG/racdb/datafile/undotbs3.269.802888323BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------2 Incr 0 263.96M DISK 00:01:05 25-DEC-2012 15:13:40 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: DB_INC0 Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_02ntomb3_s2_p1 List of Datafiles in backup set 2 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 3 0 Incr 930964 25-DEC-2012 15:12:35 +DATADG/racdb/datafile/sysaux.257.802540615 4 0 Incr 930964 25-DEC-2012 15:12:35 +DATADG/racdb/datafile/users.259.802540615 6 0 Incr 930964 25-DEC-2012 15:12:35 +DATADG/racdb/datafile/undotbs2.265.802540981BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------3 Incr 0 370.38M DISK 00:01:07 25-DEC-2012 15:13:42 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: DB_INC0 Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_01ntomb3_s1_p1 List of Datafiles in backup set 3 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 1 0 Incr 930959 25-DEC-2012 15:12:35 +DATADG/racdb/datafile/system.256.802540615BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------10 Incr 1 128.00K DISK 00:00:09 25-DEC-2012 15:25:02 BP Key: 10 Status: AVAILABLE Compressed: NO Tag: DB_INC1 Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0anton25_s10_p1 List of Datafiles in backup set 10 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 1 1 Incr 931568 25-DEC-2012 15:24:53 +DATADG/racdb/datafile/system.256.802540615BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------11 Incr 1 232.00K DISK 00:00:21 25-DEC-2012 15:25:14 BP Key: 11 Status: AVAILABLE Compressed: NO Tag: DB_INC1 Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0cnton25_s12_p1 List of Datafiles in backup set 11 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 2 1 Incr 931576 25-DEC-2012 15:25:03 +DATADG/racdb/datafile/undotbs1.258.802540615 5 1 Incr 931576 25-DEC-2012 15:25:03 +DATADG/racdb/datafile/example.264.802540751 7 1 Incr 931576 25-DEC-2012 15:25:03 +DATADG/racdb/datafile/undotbs3.269.802888323BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------12 Incr 1 208.00K DISK 00:00:21 25-DEC-2012 15:25:14 BP Key: 12 Status: AVAILABLE Compressed: NO Tag: DB_INC1 Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0bnton25_s11_p1 List of Datafiles in backup set 12 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 3 1 Incr 931570 25-DEC-2012 15:24:53 +DATADG/racdb/datafile/sysaux.257.802540615 4 1 Incr 931570 25-DEC-2012 15:24:53 +DATADG/racdb/datafile/users.259.802540615 6 1 Incr 931570 25-DEC-2012 15:24:53 +DATADG/racdb/datafile/undotbs2.265.802540981RMAN>
RMAN> list backup of archivelog all;List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------4 693.00K DISK 00:00:01 25-DEC-2012 15:13:57 BP Key: 4 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_06ntomdk_s6_p1 List of Archived Logs in backup set 4 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 3 3 926740 25-DEC-2012 14:25:27 931028 25-DEC-2012 15:13:53BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------5 3.30M DISK 00:00:01 25-DEC-2012 15:13:57 BP Key: 5 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_04ntomdk_s4_p1 List of Archived Logs in backup set 5 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 15 892350 25-DEC-2012 11:24:17 926723 25-DEC-2012 14:25:11BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------6 791.50K DISK 00:00:02 25-DEC-2012 15:13:58 BP Key: 6 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_05ntomdk_s5_p1 List of Archived Logs in backup set 6 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 2 10 926728 25-DEC-2012 14:25:14 931026 25-DEC-2012 15:13:52BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------7 1.43M DISK 00:00:01 25-DEC-2012 15:13:59 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_07ntomdm_s7_p1 List of Archived Logs in backup set 7 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 18 926737 25-DEC-2012 14:25:26 931023 25-DEC-2012 15:13:51BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------8 3.50K DISK 00:00:01 25-DEC-2012 15:14:01 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: ARCH_INC0 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_08ntomdo_s8_p1 List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 16 926723 25-DEC-2012 14:25:11 926734 25-DEC-2012 14:25:23 1 17 926734 25-DEC-2012 14:25:23 926737 25-DEC-2012 14:25:26BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------13 38.00K DISK 00:00:02 25-DEC-2012 15:25:34 BP Key: 13 Status: AVAILABLE Compressed: NO Tag: ARCH_INC1 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0dnton3c_s13_p1 List of Archived Logs in backup set 13 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 19 931023 25-DEC-2012 15:13:51 931599 25-DEC-2012 15:25:25BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------14 58.00K DISK 00:00:02 25-DEC-2012 15:25:34 BP Key: 14 Status: AVAILABLE Compressed: NO Tag: ARCH_INC1 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0enton3c_s14_p1 List of Archived Logs in backup set 14 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 2 11 931026 25-DEC-2012 15:13:52 931601 25-DEC-2012 15:25:26BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------15 5.00K DISK 00:00:02 25-DEC-2012 15:25:34 BP Key: 15 Status: AVAILABLE Compressed: NO Tag: ARCH_INC1 Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0fnton3c_s15_p1 List of Archived Logs in backup set 15 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 3 4 931028 25-DEC-2012 15:13:53 931604 25-DEC-2012 15:25:26RMAN>
RMAN> list backup of controlfile;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------9 Full 14.67M DISK 00:00:04 25-DEC-2012 15:14:06 BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20121225T151402 Piece Name: /u01/app/oracle/backup/c-800157471-20121225-00 Control File Included: Ckp SCN: 931040 Ckp time: 25-DEC-2012 15:14:02BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------16 Full 14.67M DISK 00:00:04 25-DEC-2012 15:25:38 BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20121225T152534 Piece Name: /u01/app/oracle/backup/c-800157471-20121225-01 Control File Included: Ckp SCN: 931613 Ckp time: 25-DEC-2012 15:25:34RMAN>
- Oracle 10g RAC RMAN backup Example
- Oracle 10g RAC RMAN recovery Example
- RMAN Backup For RAC
- Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明
- Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明
- 使用RMAN恢复Oracle 10g RAC库至异机
- 10g rac 备份 RMAN
- oracle rac rman backup,recover(archive log-share storage)
- Oracle 10g backup policy
- Oracle 11g R2 使用RMAN复制RAC数据库
- Oracle 11g R2 RAC RMAN备份脚本示例
- Oracle 10g rman总结
- RMAN备份恢复系列1: Oracle 10g rac asm数据库恢复到10g单实例数据库
- Oracle 10g RAC 简介
- Oracle 10g RAC架构
- Upgrade Oracle 9i RAC to Oracle 10g RAC
- Oracle 10g 新特性之 RMAN
- ORACLE 10G rman 备份脚本
- GestureDetector.OnGestureListener 详解
- HTTP POST GET 本质区别详解
- Android数据的四种存储方式SharedPreferences、SQLite、Content Provider和File (一) —— 总览
- 统计自然语言处理基础学习笔记(6)——马尔可夫模型
- sequence
- Oracle 10g RAC RMAN backup Example
- 经典的最大流 POJ 1273
- 导致人生失败的31种原因
- Android数据的四种存储方式SharedPreferences、SQLite、Content Provider和File (二) —— SQLite
- 多任务处理:多接收者(广播和多播)
- json数据解析
- mongoDB一些开发级特性
- 高通安卓调试LCD几方面总结(一)
- Android中Canvas方法总结