|
-
Hi Pnrdba,
I have try before you teach me, could you tell me where I make a mistake.
SQL> startup
ORACLE instance started.
Total System Global Area 56012784 bytes
Fixed Size 69616 bytes
Variable Size 38993920 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
copy backup control file
SQL> startup mount
ORACLE instance started.
Total System Global Area 56012784 bytes
Fixed Size 69616 bytes
Variable Size 38993920 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
SQL> recover database using backup controlfile;
ORA-00279: change 704948 generated at 07/03/2002 12:40:11 needed for thread 1
ORA-00289: suggestion : /app/oracle/admin/oracle8/arch/arch_1_62.arc
ORA-00280: change 704948 for thread 1 is in sequence #62
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00279: change 725005 generated at 07/04/2002 13:04:06 needed for thread 1
ORA-00289: suggestion : /app/oracle/admin/oracle8/arch/arch_1_63.arc
ORA-00280: change 725005 for thread 1 is in sequence #63
ORA-00278: log file '/app/oracle/admin/oracle8/arch/arch_1_62.arc' no longer
needed for this recovery
.
.
.
.
.
ORA-00279: change 725067 generated at 07/04/2002 13:04:47 needed for thread 1
ORA-00289: suggestion : /app/oracle/admin/oracle8/arch/arch_1_67.arc
ORA-00280: change 725067 for thread 1 is in sequence #67
ORA-00278: log file '/app/oracle/admin/oracle8/arch/arch_1_66.arc' no longer
needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00279: change 725068 generated at 07/04/2002 13:04:47 needed for thread 1
ORA-00289: suggestion : /app/oracle/admin/oracle8/arch/arch_1_68.arc
ORA-00280: change 725068 for thread 1 is in sequence #68
ORA-00278: log file '/app/oracle/admin/oracle8/arch/arch_1_67.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_68.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data/oradata/oracle8/system01.dbf'
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /app/oracle/admin/oracle8/arch
Oldest online log sequence 60
Next log sequence to archive 60
Current log sequence 62
[oracle@oradb arch]$ ls
arch_1_60.arc arch_1_62.arc arch_1_64.arc arch_1_66.arc
arch_1_61.arc arch_1_63.arc arch_1_65.arc arch_1_67.arc
I don't know how to do next, I will grateful you if you can help me.
Regards,
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
|