Home » RDBMS Server » Backup & Recovery » norman recovery
 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
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sat May 03 07:03:23 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
