Oracle Database Discussions

Good Morning.
I was trying to do a Failover Process in a Standby Database. On the ARCH directory, I do have the last archived file ARCH_126983.arc

I did
sql> alter database mount standby database;
SQL> recover automatic standby database;
cancel
( It did recover until ARCH_126983.arc)

sql>SHUTDOWN IMMEDIATE;
sql>alter database mount standby database;
sql>alter database open read only;
sql>alter database recover managed standby database finish;

alter database recover managed standby database finish
*
ERROR at line 1:ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH SKIP STANDBY LOGFILE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH SKIP STANDBY LOGFILE
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-16171: RECOVER...FINISH not allowed due to gap for thr 1, seq 1-126983

sql> ALTER DATABASE RECOVER MANAGED STANDBY database finish skip;
ALTER DATABASE RECOVER MANAGED STANDBY database finish skip
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-00342: archived log was created before last RESETLOGS
ORA-00334: archived log: '/u01/app/oracle/admin/auth/arch/ARCH_0.arc'

________________________________________________________

So in which instruction Failover adds an end-of-redo marker to the header of the last log file being archived . Why the sequence in Archived Redo file was reset from 126983 to 1 ?

I am not using DataGuard for standby handling. And my Oracle version is:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production



How can I change the role to this Database from Standby to primary, but without Switchover process (i am assuming the primary is not accesible).

Thanks for any help.