Home » RDBMS Server » Backup & Recovery » time-based recovery
time-based recovery [message #162227] Thu, 09 March 2006 04:10 Go to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
i took cold backup. i want to recover databse in a specific time.

SQL> recover database until time '2006-03-09:15:25:20' using backup controlfile

ORA-00279: change 2779806 generated at 03/09/2006 15:30:31 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\ORA92\RDBMS\ARC00002.001
ORA-00280: change 2779806 for thread 1 is in sequence #2


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

ORA-00308: cannot open archived log 'C:\ORACLE\ORA92\RDBMS\ARC00002.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified
.

can anyone help me to solve this problem ????
Re: time-based recovery [message #162234 is a reply to message #162227] Thu, 09 March 2006 05:13 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

For recovery, an archive file i.e. ARC00002.001is needed and its not present at the specified location.

[Updated on: Thu, 09 March 2006 05:13]

Report message to a moderator

Previous Topic: I want to Crash Non - system Datafile for testing purpose
Next Topic: RMAN - recover database fails...
Goto Forum:
  


Current Time: Thu Mar 28 06:56:33 CDT 2024