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!

how to find when was my database recovered - timestamp ?

614475Sep 16 2008 — edited Sep 16 2008

Hi Gyans,

We recovered a database some months ago not through RMAN but BCV,
how to get the time at which the database got recovered.

I have checked v$thread, archived_log, v$database but didn't find a clue.

I also checked my alert log file but found only this below.

ALTER DATABASE RECOVER database using backup controlfile
Media Recovery Start
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup cont...
Mon Jul 14 20:13:06 2008
ARC1: Cannot archive online log based on backup controlfile
Mon Jul 14 20:13:08 2008
ALTER DATABASE RECOVER LOGFILE '/r04/oradata/DWHDMP/REDO2A'
Mon Jul 14 20:13:08 2008
Media Recovery Log /r04/oradata/DWHDMP/REDO2A
Media Recovery Complete
Completed: ALTER DATABASE RECOVER LOGFILE '/r04/oradata/DW
Mon Jul 14 20:14:06 2008
ARC1: Cannot archive online log based on backup controlfile
Mon Jul 14 20:14:19 2008
ALTER DATABASE OPEN RESETLOGS
Mon Jul 14 20:14:19 2008
RESETLOGS after complete recovery through change 1984714701312
Resetting resetlogs activation ID 3308107627 (0xc52db76b)

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2008

Added on Sep 16 2008

#general-database-discussions

9 comments

8,344 views