Hi Experts,
We took backup of physical standby database + archive logs and restoring for testing activity.
Backup is restored by Backup team by using 3rd party sw.
SQL> startup nomount;
ORACLE instance started.
..
...
SQL> alter database mount standby database;
Database altered.
>> Do we need following commands really to proceed further ?
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using BACKUP CONTROLFILE;
ORA-00283: recovery session canceled due to errors
ORA-01666: control file is for a standby database
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
>> some errors were found
Managed Standby Recovery not using Real Time Apply
2019-10-07T20:00:00.497760-04:00
Recovery Slave PR00 previously exited with exception 19909
2019-10-07T20:00:00.497997-04:00
Errors in file /u01/app/oracle/diag/rdbms/XXXXX/XXXXX1/trace/XXXXX1_mrp0_44127.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '+PODSDATA/XXXXX/DATAFILE/system.260.1021025179'
2019-10-07T20:00:01.211290-04:00
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
2019-10-07T20:00:20.503336-04:00
MRP0: Background Media Recovery process shutdown (XXXXX1)