-
Hi,
I have lost my control file,so I need recover system.
After I input command archive log list,system gave me the following message:
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /app/oracle/admin/oracle8/arch
Oldest online log sequence 67
Next log sequence to archive 69
Current log sequence 69
when I recover database,system can't find file /app/oracle/admin/oracle8/arch/arch_1_69.arc
and give me the following error messsage,I can only find the last file is arch_1_68.arc.
ORA-00279: change 765190 generated at 07/04/2002 10:25:53 needed for thread 1
ORA-00289: suggestion : /app/oracle/admin/oracle8/arch/arch_1_69.arc
ORA-00280: change 765190 for thread 1 is in sequence #69
ORA-00278: log file '/app/oracle/admin/oracle8/arch/arch_1_68.arc' no longer
needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/app/oracle/admin/oracle8/arch/arch_1_69.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
How can I recover my database,please help me .
Thanks,
Michael Ni
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|