startup nomount
alter database mount standby database
select name,database_role from v$database;
alter database recover managed standby database disconnect from session;
alter system archive log current;
alter database recover managed standby database cancel;
alter database open read only;
select sequence#,first_time,next_time from v$archived_log order by sequence#;
select sequence#,applied from v$archived_log order by sequence#