sql>alter system set log_archive_dest_2='';

sql>alter system switch logfile;

sql>shutdown immediate;

sql>startup nomount

sql>alter database mount standby database;

sql>alter database backup controlfile to trace;

sql>shutdown immediate; -- 目的是为了打开trace文件

sql>exit

sql>startup nomount pfile=init.ora;

sql>alter database mount standby database;

sql>@cre_ctl.sql

sql>recover database using backup controlfile until cancel;

sql>alter database open resetlogs;