recover standby database

I have backed up archive logs to the standby database and followed the steps below to recover it, but am running into the error shown. What am doing wrong?

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 286858140 bytes
Fixed Size 453532 bytes
Variable Size 184549376 bytes
Database Buffers 100663296 bytes
Redo Buffers 1191936 bytes
SQL> alter database mount standby database;

Database altered.

SQL> recover standby database until cancel;
ORA-00279: change 739533 generated at 01/23/2006 12:36:36 needed for thread 1
ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_64.ARC
ORA-00280: change 739533 for thread 1 is in sequence #64


Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00279: change 739895 generated at 01/23/2006 12:54:36 needed for thread 1
ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_65.ARC
ORA-00280: change 739895 for thread 1 is in sequence #65
ORA-00278: log file 'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_64.ARC' no
longer needed for this recovery


Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00279: change 741914 generated at 01/23/2006 14:36:17 needed for thread 1
ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_66.ARC
ORA-00280: change 741914 for thread 1 is in sequence #66
ORA-00278: log file 'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_65.ARC' no
longer needed for this recovery


Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_66.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01666: controlfile is for a standby database

what are you trying to do, perform a switchover or sync with your prod db?

and what version

am trying to sync with production database

version 9.2

so why did you create a standby, is it a one time thing, or consistently up to date?

I just built one for practice. I imagine if i built one it will be consistently be up to date. Can tell me how to do both? Thanks

it is a physical or a logical standby?

It is a physical

alter database recover managed standby database disconnect from session;

this needs to be done AFTER you have done alter database mount standby database;

That will keep it in sync forever, make sure you have set log_archive_dest on the primary, fal client and server as well

What if it's not managed? My other question is. After i do RECOVER STANDBY DATABASE; i have tried to do an rman backup of the standby db and i get this error

piece handle=C:\U01\ORABKUP\OKCDBST2\DF_T580499068_S107_P1 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:55
Finished backup at 23-JAN-06

Starting backup at 23-JAN-06
specification does not match any archive log in the recovery catalog
Finished backup at 23-JAN-06

RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped

released channel: d1
What is causing the two errors?

alter database recover managed standby database disconnect from session;

fire this after mounting the database in standby and check for the applied log status in v$archived_log

my standby database is not managed. I manually backup the archive logs. I can see all the archive logs from the primary in the directory where i put them in standby. Mounted the standby and tried to RECOVER STANDBY DATABASE. It seems to work but when i fired the V$archived log to see applied log status. There were no rows fetched.

why not just set log_archive_dest_2 and have the database ship over the archive logs?

I am using oracle9i 9.2 standard edition.