1 person found this helpful
I have created a physical standby. It has appled archived 1231-1235 ,but when I try to open it asks for archives 1214 to 1230.
How is that possible?
Will newer archives( 1231 -1235) be applied before the application of older archives.
Probably when you created physical standby from primary backup the sequence number was 1214 and later when you start actual MRP those files are might already deleted by manually or the retention you set.
If you still have archives on primary copy to standby and register then apply manually.
If they are no more exist, you have to perform incremental rollforward as mentioned in below link
Will come archives 1231-1234 are applied , before the application of archives 1214-1230.
Is that possible? New archives (1231-1234)applied before old ones(1214-1230).
Can you give output of below query from
SQL> select max(sequence#) from v$archived_log where applied='YES';