Oracle Database Discussions

Hi All,

I have a complex issue which was not resolved with many of the options that I tried using online material.

Phase 1:

I took a hot backup of dbf,redo and controlfiles. ( using Alter tablespace begin|end backup).

Copied the files to another system and tried to open.

1) startup nomount
ORACLE instance started.

@control.sql
Control file created.

Issue is that:

recover database until cancel using backup controlfile;
this works, applied logs and continues till date....no problem when issued command "recover database until cancel using backup controlfile;"

but the below sql fails.

SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Phase 2:

The same copied files in another system having the same error was successfully opened (the database) without any errors.

Any idea why this error occurs.

Purpose:

I need to maintain it as standby DR database, so I should resolve the recover database error.

Things I tried:

1) alter database backup controlfile to trace noresetlogs;
used it to create controlfile --- same error continued.

2) alter database backup controlfile to trace;
with resetlogs --- used it to create controlfile --- same error continued.


Any help on this will be greatly appreciated.

Thanks,
Junr. DBA