希望你能看懂下面的话
I.B. THE DATABASE WAS NOT CLEANLY SHUT DOWN
-------------------------------------------
This is the situation where the database was last shut down abort or crashed.
In this case, it is almost certain that the rollback segments that had
extents in the lost datafile still contain active transactions.Therefore,
the file cannot be offlined or dropped.You must restore the lost datafile
from a backup and apply media recovery to it.If the database is in
NOARCHIVELOG mode, you will only succeed in recovering the datafile if the
redo to be applied is within the range of your online logs.If a
backup of the datafile is not available, please contact Oracle Customer
Support.
These are the steps:
1. Restore the lost file from a backup.
2. Mount the database.
3. Issue the following query:
SELECT FILE#, NAME, STATUS FROM V$DATAFILE;
If the status of the file you just restored is "OFFLINE," you must
online it before proceeding:
ALTER DATABASE DATAFILE '' ONLINE;
4. Issue the following query:
SELECT V1.GROUP#, MEMBER, SEQUENCE#, FIRST_CHANGE#
FROM V$LOG V1, V$LOGFILE V2
WHERE V1.GROUP# = V2.GROUP# ;
This will list all your online redolog files and their respective
sequence and first change numbers.
5. If the database is in NOARCHIVELOG mode, issue the query:
SELECT FILE#, CHANGE# FROM V$RECOVER_FILE;
If the CHANGE# is GREATER than the minimum FIRST_CHANGE# of your
logs, the datafile can be recovered.Just keep in mind that all the
logs to be applied will be online logs, and move on to step 6.
If the CHANGE# is LESSER than the minimum FIRST_CHANGE# of your logs,
the file cannot be recovered.Your options at this point include
restoring a full backup if one is available or forcing the database
to open in an inconsistent state to get a full export out of it.
For further details and to assist you in your decision, please
contact Oracle Customer Support.
6. Recover the datafile:
RECOVER DATAFILE ''
7. Confirm each of thelogs that you are prompted for until you
receive the message "Media recovery complete".If you are prompted for a
non-existing archived log, Oracle probably needs one or more of the
online logs to proceed with the recovery.Compare the sequence number
referenced in the ORA-280 message with the sequence numbers of your online
logs.Then enter the full path name of one of the members of the redo group
whose sequence number matches the one you are being asked for.Keep entering
online logs as requested until you receive the message "Media recovery
complete".
8. Open the database.
|