Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00283:,ORA-19909:,ORA-19909:

1021200Nov 24 2013 — edited Nov 24 2013

Hi,

I am doing recovery with hot backup (whiout using RMAN) in my stand by database dupdb but getting below error.

SQL> select name, open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

DUPDB MOUNTED

SQL> set logsource 'D:\app1\Archivelocation';

SQL> recover database using backup controlfile until cancel;

ORA-00283: recovery session canceled due to errors

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: 'D:\APP1\APP\HIMANSHU\ORADATA\DUPDB\SYSTEM01.DBF'

Please let me know What wrong I am doing here.

Thanks,

Michel

This post has been answered by Anar Godjaev on Nov 24 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2013

Added on Nov 24 2013

#general-database-discussions

2 comments

1,552 views