| norman recovery [message #159211] |
Thu, 16 February 2006 14:52  |
Jack_zhai
Messages: 12
Registered: February 2006
|
Junior Member |
|
|
The database is 8.1.7.
I copied all files in terms of init.ora, controlfile, redologs file, data files and to an identical environment. After mounted, I used command
"recover database until cancel using backup controlfile;" to recover the database. I used "AUTO" to continue work. Before the archive log applying process will stop afterwards, it just doesn't stop. It told me this error:
ORA-00308: cannot open archived log '/app/oracle/oradata/arch_log_1/arch_1_392257.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 114 needs more recovery to be consistent
ORA-01110: data file 114: '/app/oracle/oradata/prodindex/asfx01.dbf'
When I use "alter database open resetlogs." to open the database, I failed.
If somebody know how to fix this problem ?
Thanks
Jack
|
|
|
|
| Re: norman recovery [message #192799 is a reply to message #159211] |
Wed, 13 September 2006 12:04  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
| Jack_zhai wrote on Fri, 17 February 2006 02:22 |
When I use "alter database open resetlogs." to open the database, I failed.
If somebody know how to fix this problem ?
Thanks
Jack
|
what means FAILED ??
whats the error ??
any screen dump ??
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
