-
needs to force open a corrupted db and at generate the archive log
hi all,
One my db got corrupted; this db is in external storage and at being copied to the internal disks for backup and recovery using script. Unfortunately my new colleague here decided to copy it manually last night. And the executed command copy the dbf files to the same location because it was just a symbolic link. The timestamp was no longer valid.
cd /CIS01/c1t05; tar cf - .| (cd /c1t5; tar xfBp -)
i.e. /c1t5 is a symbolic link to /CIS01/c1t05.
So all the dbf files in that folder got corrupted, and unfortunately it will also copy the same corrupted files to the internal disk after the executed command has been corrected.
Now, I got to open(force) one of this db at least generate “ARCHIVE LOG ALL” so that I can apply it after I recover the corrupted dbf files from my backup. Any quick info, before I start reading my manuals?
This is my error right now when I open the db.
SVRMGR> connect internal
Connected.
SVRMGR> startup nomount;
ORACLE instance started.
Total System Global Area 1562812096 bytes
Fixed Size 69312 bytes
Variable Size 555044864 bytes
Database Buffers 1006632960 bytes
Redo Buffers 1064960 bytes
SVRMGR> alter database mount;
Statement processed.
SVRMGR> alter database open;
alter database open
*
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/c1t05/oradata/CIS1/users01.dbf'
SVRMGR> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> disconnect
Your help will be very much appreciated.
---------------
-
I got it all done. Thanks for those who spare time to read.
---------------
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
|