数据库归档放在ASM里时,想把他CP出来是比较蛋疼的一件事。现在推荐了几个方法。
10g:
1.用rman copy方式
RMAN> backup as copy archivelog from sequence 5 until sequence 5 thread 1 format '/u01/app/%h_%e_archivelog.dbf'; RMAN> backup as copy archivelog sequence between 5 and 6 thread 1 format '/u01/app/%h_%e_archivelog.dbf';
2.调用dbms_file_transfer.copy_file包
SQL> create directory asm_dir&nbs[......]