Originally posted by yls177
i only did a "recover managed standby database cancel;"
dude you need to read the data guard books, I assume this is 9i as you have so referenced in previous posts

you would do this on the standby
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;