In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Step 1: complete datafile,controlfile,spfile/pfile
Step 2: restore the log. The original cold journal is useless, please don't use it! )
SQL > select member from vault log file; / ora/app/oracle/oradata/orcl/redo03.log/ora/app/oracle/oradata/orcl/redo02.log/ora/app/oracle/oradata/orcl/redo01.logSQL > archive log list Database log mode No Archive ModeAutomatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 10 Current log sequence 12 SQL > ho rm $ORACLE_BASE/oradata/orcl/redo*.log-the simulation log file is missing. SQL > ho ls $ORACLE_BASE/oradata/orcl/redo*.logls: cannot access / ora/app/oracle/oradata/orcl/redo*.log: No such file or directorySQL > startup forceORACLE instance started.Total System Global Area 1536602112 bytesFixed Size 2213616 bytesVariable Size 956303632 bytesDatabase Buffers 570425344 bytesRedo Buffers 7659520 bytesDatabase mounted. ORA-00313: open failed for members of log group 3 of thread 1ORA-00312: online log 3 thread 1:'/ ora/app/oracle/oradata/orcl/redo03.log'ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 SQL > alter database open resetlogs -- step 1: alter database open resetlogs * ERROR at line 1: ORA-01139: RESETLOGS option only valid after an incomplete database recoverySQL > recover database using backup controlfile -- step 2 ORA-00279: change 1384991 generated at 05 suggested 22 Specify log 20:05:08 needed for thread 1ORA-00289: suggestion: / ora/app/oracle/flash_recovery_area/ORCL/archivelog/2016_05_22/o1_mf_1_12_%u_.arcORA-00280: change 1384991 for thread 1 is in sequence # 12 Specify log: {= suggested | filename | AUTO | CANCEL} -- Note: non-archiving Do nothing and go straight back to the car. ORA-00308: cannot open archived log'/ ora/app/oracle/flash_recovery_area/ORCL/archivelog/2016_05_22/o1_mf_1_12_%u_.arc'ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 SQL > alter database open resetlogs -- step 3 alter database open resetlogs * ERROR at line 1: ORA-01113: file 1 needs media recoveryORA-01110: data file 1:'/ ora/app/oracle/oradata/orcl/system01.dbf'SQL > alter system set "_ allow_resetlogs_corruption" = true scope=spfile;System altered. The fourth step is to start the database with hidden parameters without consistency checking. SQL > startup force mount;-step 5, restart to MOUNT. ORACLE instance started. Total System Global Area 1536602112 bytesFixed Size 2213616 bytesVariable Size 956303632 bytesDatabase Buffers 570425344 bytesRedo Buffers 7659520 bytesDatabase mounted. SQL > alter database open;-- step 6: alter database open * ERROR at line 1: ORA-01589: must use RESETLOGS or NORESETLOGS option for database openSQL > alter database open resetlogs;-- step 7: normally, it will recover normally. ERROR: ORA-03114: not connected to ORACLE alter database open resetlogs* ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00600: internal error code, arguments: [2662], [0], [1384999], [0], [1385016], [4194432], [] [] Process ID: 28621 Session ID: 125 Serial number: 5 -- 600 error due to hidden parameters. SQL > exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@test] $sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sun May 22 22:56:21 2016Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL > select status from vault instance;-- check the status, the database is closed. Select status from v$instance*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0SQL > startup mount;-- launch ORACLE instance started.Total System Global Area 1536602112 bytesFixed Size 2213616 bytesVariable Size 956303632 bytesDatabase Buffers 570425344 bytesRedo Buffers 7659520 bytesDatabase mounted.SQL > alter database open;Database altered again. -- started successfully. SQL > ho ls $ORACLE_BASE/oradata/orcl/red*-automatic log file generation / ora/app/oracle/oradata/orcl/redo01.log / ora/app/oracle/oradata/orcl/redo02.log / ora/app/oracle/oradata/orcl/redo03.logSQL > alter system reset "_ allow_resetlogs_corruption" scope=spfile sid='*';System altered. Step 8, restore the hidden parameter values. SQL > startup force-step 9, restart the database so that the parameters take effect.
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.