sql statement: alter system archive log current

    contents of Memory Script:

    {

    backup as copy reuse

    archivelog like  “/u01/app/oracle/flash_recovery_area/ORCL/log_109_1_682541003.arc” auxiliary format

    “/u01/app/oracle/flash_recovery_area/STDBY/log_109_1_682541003.arc”   ;

    catalog clone archivelog  “/u01/app/oracle/flash_recovery_area/STDBY/log_109_1_682541003.arc”;

    switch clone datafile all;

    }

    executing Memory Script

    Starting backup at 18-APR-09

    channel d1: starting archived log copy

    input archived log thread=1 sequence=109 RECID=110 STAMP=684484146

    output file name=/u01/app/oracle/flash_recovery_area/STDBY/log_109_1_682541003.arc RECID=0 STAMP=0

    channel d1: archived log copy complete, elapsed time: 00:00:01

    Finished backup at 18-APR-09

    cataloged archived log

    archived log file name=/u01/app/oracle/flash_recovery_area/STDBY/log_109_1_682541003.arc RECID=1 STAMP=684484135

    datafile 1 switched to datafile copy

    input datafile copy RECID=36 STAMP=684484136 file name=/u01/app/oracle/oradata/orcl/system01.dbf

    datafile 2 switched to datafile copy

    input datafile copy RECID=37 STAMP=684484136 file name=/u01/app/oracle/oradata/orcl/sysaux01.dbf

    datafile 3 switched to datafile copy

    input datafile copy RECID=38 STAMP=684484136 file name=/u01/app/oracle/oradata/orcl/undotbs01.dbf

    datafile 4 switched to datafile copy

    input datafile copy RECID=39 STAMP=684484136 file name=/u01/app/oracle/oradata/orcl/users01.dbf

    datafile 5 switched to datafile copy

    input datafile copy RECID=40 STAMP=684484136 file name=/u01/app/oracle/oradata/orcl/example01.dbf

    contents of Memory Script:

    {

    set until scn  4021704;

    recover

    standby

    clone database

    delete archivelog

    ;

    }

    executing Memory Script

    executing command: SET until clause

    Starting recover at 18-APR-09

    starting media recovery

    archived log for thread 1 with sequence 109 is already on disk as file /u01/app/oracle/flash_recovery_area/STDBY/log_109_1_682541003.arc

    archived log file name=/u01/app/oracle/flash_recovery_area/STDBY/log_109_1_682541003.arc thread=1 sequence=109

    media recovery complete, elapsed time: 00:00:01

    Finished recover at 18-APR-09

    Finished Duplicate Db at 18-APR-09

    released channel: d1

    released channel: d2

    编辑特别推荐:

    数据库表空间的计算方法

    通过TABLEFUNCTION获得ORACLE权限

    查看oracle存储大小