強制起動Resetlogs資料庫
1. Shutdown the database and take a full backup of the current database
2. Add the following parameter in the init.ora file:
_allow_resetlogs_corruption=TRUE
3. Startup mount;
4. Recover database using backup controlfile until cancel;
5. If prompted for a logfile, type CANCEL.
6. alter database open resetlogs;
7. Rebuild the database by taking a full database export, and then import.
2. Add the following parameter in the init.ora file:
_allow_resetlogs_corruption=TRUE
3. Startup mount;
4. Recover database using backup controlfile until cancel;
5. If prompted for a logfile, type CANCEL.
6. alter database open resetlogs;
7. Rebuild the database by taking a full database export, and then import.