In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Control file loss resolution:
1 alter database backup controlfile to trace
2 paste out this paragraph in the trace file
Vi / home/oracle/control.sql
CREATE CONTROLFILE REUSE DATABASE "ORA11GR2" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1'/ u01 SIZE SIZE BLOCKSIZE 512
GROUP 2'/ u01 SIZE SIZE BLOCKSIZE 512
GROUP 3'/ u01 SIZE SIZE 50m oradata BLOCKSIZE
-- STANDBY LOGFILE
DATAFILE
'/ u01 apprenticeship oradataPlus ORA11GR2 Universe system01.dbf'
'/ u01 apprenticeship oradataPlus ORA11GR2 Universe sysaux01.dbf'
'/ u01 apprenticeship oradataPlus ORA11GR2 Universe undotbs01.dbf'
'/ u01GR2 / u01ActionUniverse oradataPlus ORA11GR2 max users01.dbf'
'/ u01 apprenticeship oraclecospact ORA11GR2max example01.dbf'
CHARACTER SET WE8MSWIN1252
3 shutdown immediate
four
[oracle@wdd58 ORA11GR2] $mv control01.ctl control01.ctl.bak
[oracle@wdd58 ORA11GR2] $mv control02.ctl control02.ctl.bak
5 startup nomount
@ / home/oracle/control.sql
SQL > select status from v$instance
STATUS
-
MOUNTED
6 alter database open
7 select name from v$tempfile
Found no files corresponding to temporary tablespaces
eight
Alter tablespace temp add tempfile'/ u01 reuse. ORA11GR2 reuse.
nine
Select name from v$tempfile
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.