rman中如何制定刪除某段時間的歸檔日誌

來源:互聯網
上載者:User

rman中如何制定刪除某段時間的歸檔日誌

eg:
 RMAN>  sql 'alter session set nls_date_format="YYYY-MM-DD"';

sql statement: alter session set nls_date_format="YYYY-MM-DD"

RMAN> delete archivelog from  time "2012-12-01" until  time "2013-02-28";

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
specification does not match any archive log in the recovery catalog



小結:
 sql 'alter session set nls_date_format="YYYY-MM-DD"';
delete archivelog from  time "2012-12-01" until  time "2013-02-28";

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.