查看执行过的RMAN命令

 

 

select * from gv$rman_output t where t.INST_ID=1
and t.OUTPUT like '%COMPRE%'
order by t.SESSION_STAMP desc;

Select * from gv$rman_output t where t.INST_ID=1
and t.SESSION_STAMP=841855901
order by t.SESSION_STAMP asc;

 

使用EBS RMAN备份脚本会修改原来的rman配置！，需要注意

 

connected to target database: PROD (DBID=250061959)
using target database control file instead of recovery catalog
 
configure device type disk parallelism 5 backup type to backupse
 
configure maxsetsize to 32968m;
 
backup as backupset tag 'RapidClone_RAC' database format '/u02/i
 
backup as backupset tag 'RapidClone_RAC' archivelog all format '
 
backup tag 'RapidClone_RAC' as copy current controlfile format '
 
exit
 
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 3;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
 
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO 32968 M;
new RMAN configuration parameters are successfully stored
 
Starting backup at 10-MAR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6967 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=7040 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=7120 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=7273 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=7350 instance=PROD1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set