| time-based recovery [message #162227] |
Thu, 09 March 2006 04:10  |
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 ????
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
