— Switch from Standby to Primary 9i & 10g
1. Apply upto the last log

SQL> startup nomount

SQL> alter database mount standby database;

Database altered.

SQL> select PROTECTION_MODE from v$database;

PROTECTION_MODE
——————–
MAXIMUM PERFORMANCE

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH SKIP STANDBY LOGFILE;
( without stand-by redologs )
or

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
( with stand-by redologs )
Database altered.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

SQL> select * from v$instance;
SQL>
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
Database mounted.
Database opened.
SQL>