recover standby database but got this ora message

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent

hi, my standy database is in sync with production, however, i got the above message after the sync is complete. please advise

my archive log list for both instances gives the same log number

details of what i did as belows

1. being backup mode of tablespaces of the production database
2. rcp the datafiles to the standby database
3. create a standby controlfile of the production and copy over to standby
4. start standby database with nomount option

then i got the error which i posted in the first thread.

anything amiss?

also, in my alert file

ARC0: Begin FAL archive (thread 1 sequence 114491 destination standby) ARC0: FAL archive, source redo log file not found: /oracle/SID/saparch/SIDarch1_114491.dbf
Errors in file /oracle/SID/saptrace/background/SID_arc0_1101978.trc: ORA-19505: failed to identify file
"/oracle/SID/saparch/SIDarch1_114491.dbf" ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3
ARC0: FAL archive failed, see trace file. ARCH: FAL archive failed. Archiver continuing ORACLE Instance SID - Archival Error. Archiver continuing. ARCH: Connecting to console port...
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
Errors in file /oracle/SID/saptrace/background/SID_arc0_1101978.trc: ORA-16055: FAL request rejected

in SID_arc0_1101978.trc, i have found that basically, it is asking me for log files that are past the archive log list given.

finally,
actually, the cause of the errros above is because i do the below

1. being backup mode for tablespaces
2. rcp
3. end backup mode
4. create standby controlfile
5. startup
6. got these errors

so i changed to the below

1) create standby controlfile
2) being bacup mode for tablespaces
3)rcp
4) end backup mode for tablespaces
5) startup 
6) result: beautiful

comments? Received on Sat May 15 2004 - 10:26:54 CDT