|
uded: Ckp SCN: 356975 Ckp time: 15-DEC-14
SPFILE Included: Modification time: 15-DEC-14
RMAN> backup as compressed backupset database format '/home/oracle/full_after_keep_%U';------------------>此时我做了一次db的备份
Starting backup at 16-DEC-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u01/app/oracle/oradata/PROD/disk1/example_1.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/PROD/disk1/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/PROD/disk1/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/PROD/disk1/undotbs01.dbf
input datafile fno=00009 name=/u01/app/oracle/oradata/PROD/disk1/r_1.dbf
input datafile fno=00007 name=/u01/app/oracle/oradata/PROD/disk1/users_1.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/PROD/disk1/oltp_1.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/PROD/disk1/indx_1.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/PROD/disk1/tools_1.dbf
channel ORA_DISK_1: starting piece 1 at 16-DEC-14
channel ORA_DISK_1: finished piece 1 at 16-DEC-14
piece handle=/home/oracle/full_after_keep_10pq96j9_1_1 tag=TAG20141216T014409 comment=NONE ---------->备份的开始时间是：20141216T014409
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:56
Finished backup at 16-DEC-14
Starting Control File and SPFILE Autobackup at 16-DEC-14
piece handle=/home/oracle/backup/control/c-275920358-20141216-00 comment=NONE
Finished Control File and SPFILE Autobackup at 16-DEC-14
RMAN> backup as compressed backupset database format '/home/oracle/full_after_keep_%U';
Starting backup at 16-DEC-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u01/app/oracle/oradata/PROD/disk1/example_1.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/PROD/disk1/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/PROD/disk1/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/PROD/disk1/undotbs01.dbf
input datafile fno=00009 name=/u01/app/oracle/oradata/PROD/disk1/r_1.dbf
input datafile fno=00007 name=/u01/app/oracle/oradata/PROD/disk1/users_1.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/PROD/disk1/oltp_1.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/PROD/disk1/indx_1.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/PROD/disk1/tools_1.dbf
channel ORA_DISK_1: starting piece 1 at 16-DEC-14
channel ORA_DISK_1: finished piece 1 at 16-DEC-14
piece handle=/home/oracle/full_after_keep_12pq9736_1_1 tag=TAG20141216T015238 comment=NONE ------------>备份的开始时间是：20141216T015238
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:15
Finished backup at 16-DEC-14
Starting Control File and SPFILE Autobackup at 16-DEC-14
piece handle=/home/oracle/backup/control/c-275920358-20141216-01 comment=NONE
Finished Control File and SPFILE Autobackup at 16-DEC-14
RMAN> exit
RMAN> report obsolete redundancy 1; -------------------------------------------------->请注意：该命令是按照 redundancy 1 来report obsole |