Home » RDBMS Server » Backup & Recovery » norman recovery
norman recovery [message #159211] Thu, 16 February 2006 14:52 Go to next message
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 Go to previous messageGo to next message
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 ??


Re: norman recovery [message #192801 is a reply to message #192799] Wed, 13 September 2006 12:18 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You probably won't hear back from this guy...the post was from the beginning of the year.
Previous Topic: identifying controlfile backup in rman ???
Next Topic: Set NLS_DATE_FORMAT RMAN for Windows XP
Goto Forum:
  


Current Time: Sat Dec 10 11:03:20 CST 2016

Total time taken to generate the page: 0.14063 seconds