Oracle data file corruption, how to open a database
Source: Internet
Author: User
oracle| Data | database
A data file corruption, how to open the database?
System environment:
1, operating system: Windows Server, machine memory 128M
2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, Installation path: C:\ORACLE
Error behavior:
By mistake, a data file in the database has been mistakenly deleted,
Oracle related services for Control Panel display started, but cannot connect with Sql*plus.
Display the following error
Ora-01033:oracle initialization or shutdown in progress
Simulation phenomenon:
Create Tablespace Test datafile
' C:\test.ora ' size 5M
Autoextend on NEXT 1M MAXSIZE Unlimited
Default storage (initial 128K next 1M pctincrease 0)
/
Turn off all services Stop.bat
net stop "OracleWebAssistant0"
net stop "Oracleorahome81tnslistener"
net stop "ORACLESERVICEORADB"
Shutdown
Remove Test.ora files from the operating system
Restart Service Start.bat
net start "OracleWebAssistant0"
net start "Oracleorahome81tnslistener"
net start "oracleserviceoradb"
Service ORACLESERVICEORADB display is started but cannot be connected with Sql*plus.
Displays ora-01033:oracle initialization or shutdown in progress
Workaround:
Let the data file go offline, you can open the database
C:\>svrmgrl
Svrmgrl>connect Internal
Svrmgrl>shutdown
Svrmgrl>startup Mount
--archivelog mode command, file name to uppercase
Svrmgrl>alter database DataFile ' C:\TEST. ORA ' offline;
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.