How to open the database after the online hot backup failed?
System environment:
1, operating system: Windows 2000
2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, installation path: c: / oracle
Error phenomenon:
When there is a online hot backup, the server fails, such as power-down, restart the server,
When you start the database, you cannot open the database, and the Oracle requires media recovery.
Because the tablespace is still in the thermal backup state.
Simulation phenomenon and solution:
first
Set the database to archive mode
C: /> SVRMGRL
SVRMGRL> Connect Internal
SVRMGRL> ALTER TABLESPACE Table Space Name Begin Backup;
- Table space hot standby mode is not over to close the database, causing errors
SVRMGRL> Shutdown Abort
SVRMGRL> Startup Mount
- Remove the data file of this table space in End Backup mode when the database is opened
SVRMGRL> ALTER DATABASE DATAFILE 'Table Space Data File Name' End Backup;
-
Or perform the tablespace media recovery
SVRMGRL> Recover TableSpace table space name;
SVRMGRL> ALTER DATABASE OPEN;
