数据库归档放在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[......]

查看全文