Recover database

Posted by Roshan on Jun 03, 2017; 7:35pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Recover-database-tp2763.html

Hi Erman,
Oracle Database 12c
Red Hat Linux 7

I have restored a backup from tape. During recovery process, Oracle requires for archive sequence #170249812269

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 170249812269 generated at 06/03/2017 00:10:37 needed for
thread 2
ORA-00289: suggestion : /archicom/ora12c/oradata/2_6943_938705669.dbf
ORA-00280: change 170249812269 for thread 2 is in sequence #6943


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

When I do list archivelog all on test, the range of sequnce is
178881238 to 170214901740
hence, I am unable restore log sequence 6943(change 170249812269)

on production, list archivelog all includes sequnce 6943

6943    1    8815    A 02-JUN-17
        Name: +DATA1/CBS/ARCHIVELOG/2017_06_02/thread_1_seq_8815.4470.945567961



Can you please advise how to proceed?

Regards,
Roshan