TECH: Summary For Forcing The Database Open With `_ALLOW_RESETLOGS_CORRUPTION` with Automatic Undo Management [ID 283945.1]
|
|
|
Modified18-MAY-2010TypeBULLETINStatusPUBLISHED
|
|
***
This article is being delivered in Draft form and may contain errors.Please
use the MetaLink "Feedback" button to advise Oracle of any issues related to
this article.
***
Warning
~~~~~~~
The following instructions should only be used under the explicit direction
of Oracle Support. These steps should only be used when all other conventional
means of recovering the database have failed. Please note that there is no
guarantee that this method will succeed.
IF THE STEPS BELOW DO ALLOW YOU TO OPEN YOUR DATABASE THEN IT IS ESSENTIAL THAT
THE DATABASE BE REBUILT AS IT IS NO LONGER SUPPORTED. FAILURE TO DO SO MAY LEAD
TO DATA DICTIONARY INCONSISTENCIES, INTERNAL ERRORS AND CORRUPTIONS.
** Note: The steps here apply to Oracle 9i or higher and only and when Automatic
Undo Management is being used. **
Steps to attempt to force the database open:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1) Backup the database while the database is closed.
THE INSTRUCTIONS HERE ARE DESTRUCTIVE. YOU ARE STRONGLY ADVISED TO BACKUP THE
DATABASE BEFORE PROCEEDING. IF YOU DO NOT DO THIS YOU MAY LOSE THE CHANCE TO
TRY OTHER OPTIONS.
2) If your datafiles are from different points in time, it is best to try to
use system tablespace datafiles at a similar timestamp to the OLDEST files
you have online in the database. This reduces the chance that you will get
problems during the bootstrap phase of opening the database.
3) Edit your *init<sid>.ora file to change undo_management and add two parameters.
*Change UNDO_MANAGEMENT=AUTO to
UNDO_MANAGEMENT=MANUAL
*Remove or comment out UNDO_TABLESPACE and UNDO_RETENTION.
*Add
_ALLOW_RESETLOGS_CORRUPTION = TRUE
_CORRUPTED_ROLLBACK_SEGMENTS =(comma separated list of Automatic Undo segments)
Example:
_CORRUPTED_ROLLBACK_SEGMENTS = (_SYSSMU1$, _SYSSMU2$, _SYSSMU3$, _SYSSMU4$,
_SYSSMU5$, _SYSSMU6$, _SYSSMU7$, _SYSSMU8$, _SYSSMU9$, _SYSSMU10$)
Note, sometimes the alert log will tell you what Automatic Undo segments are in
use.Search the alert log for SYSS.If the alert log does not contain that
information then use _SYSSMU1$ through _SYSSMU10$ as shown in the example above.
In UNIX you can issue this command to get the undo segment names:
$ strings system01.dbf | grep _SYSSMU | cut -d $ -f 1 | sort -u
From the output of the strings command above, add a $ to end of each _SYSSMU
undo segment name.
*If you only have a spfile available, you can from the closed, nomount or the
mount stage create an init<sid>.ora file as follows:
SQL>CREATE PFILE FROM SPFILE;
Do NOT edit the SPFILE.
4) Invoke SQL*Plus, startup mount, check that correct init<sid>.ora was used and
all datafiles are in the status of online or system.
$ sqlplus "/as sysdba"
SQL>startup mount pfile = (full path / file name to init<sid>.ora)
Confirm that the hidden parameters from step 3 were used:
SQL>show parameters corrupt
You should see both hidden parameters listed. If not, the wrong init<sid>.ora
may have been modified.Do not continue until "show parameters corrupt" shows
both hidden parameters.
SQL>show parameters undo
You should see undo management set to manual. If not, the wrong init<sid>.ora
may have been modified.Do not continue until "show parameters undo" shows
undo management as manual.
Check that all files you want to open with are listed as ONLINE or as SYSTEM.
SQL>select name, file#, status from v$datafile where status not in
('SYSTEM', 'ONLINE');
If any rows are returned from the query above, bring the file(s) online with:
SQL>ALTER DATABASE DATAFILE file# ONLINE;
and repeat until there are no files in an OFFLINE status. If any file remains or
changes into "recover" status after you try to online the file proceed to step 5.
5)Perform a fake incomplete recovery then open the database with resetlogs.
SQL>recover database until cancel;
or
SQL>recover database using backup controlfile until cancel;
WHEN PROMPTED FOR AN ARCHIVELOG FILE TYPE cancel THEN PRESS ENTER.
SQL>ALTER DATABASE OPEN RESETLOGS;
6) If the database opens try selecting from a table. For example:
SQL>SELECT SYSDATE FROM DUAL;
If you get a row back the database is open and "functional".If you wish, you
may try to select from a other tables to make sure the database is functional
enough for the required export.
With the database open and functional you should attempt to export the database
IMMEDIATELY. Once you have an export the database MUST be recreated from scratch.
This means dropping and deleting ALL datafiles and creating a new database from
scratch.
A database which has been opened in this way but not rebuilt will not be
supported by Oracle. Any delay in exporting the contents or any attempt to
use the system may cause irreparable damage.
NOTE: BE SURE TO REVERSE / REMOVE THE INIT.ORA PARAMETERS ADDED IN STEP 3
OTHERWISE YOU MAY ACCIDENTALLY CORRUPT ANY NEW DATABASE CREATED USING THE SAME
INIT<sid>.ORA FILE.
7)If the instance crashed in the open phase of step 5, check for trace files
in the background dump destination.If you find a trace file, check to see if
the trace file has an ORA-00600 [2662] or ORA-00600 [4000] error in it.
Either of these errors may also be seen in the alert.log file.
If you see the ORA-00600 [2662] or ORA-00600 [4000] error, provide Oracle Support
Services the full error message. Oracle Support Services will provide steps to advance
the SCN using a hidden parameter.
NOTE: BE SURE TO REVERSE / REMOVE THE INIT.ORA PARAMETERS ADDED IN STEP 3
OTHERWISE YOU MAY ACCIDENTALLY CORRUPT ANY NEW DATABASE CREATED USING THE SAME
INIT<sid>.ORA FILE.
*************************************************************************
**
* CAUTION: Once the database is open, it is imperative that you export, *
*rebuild the database, and import.*
**
* By forcing open the database in this fashion, there is a strong*
* likelihood of logical corruption, possibly affecting the data*
* dictionary.Oracle does not guarantee that all of the data will be*
* accessible nor will it support a database that has been opened by*
* this method and that the database users will be allowed to continue*
* work.All this does is provide a way to get at the contents of the*
* database for extraction, usually by export.It is up to you to*
* determine the amount of lost data and to correct any logical*
* corruption issues.*
**
*************************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Related Documents:
Note 41399.1(Limited) TECH: Summary For Forcing The Database Open With
`_ALLOW_RESETLOGS_CORRUPTION`
(Use note 41399.1 for versions previous to 9i or with an Oracle version not
using Automatic Undo Management but that is instead using rollback segments)
Related
Products
·Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
·Enterprise Management > Enterprise Manager Consoles, Packs, and Plugins > Managing Databases using Enterprise Manager > Enterprise Manager for RDBMS
·Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Personal Edition
·Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Standard Edition
Errors
ORA-600[2662]; ORA-600[4000]
|
|
------------------------------------------------------------------------------
分享到:
相关推荐
获取hycom数据,用于FVCOM程序输入文件制作
qy_Qualitative A... Forcing Term_郑志明.caj
This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2017-11-15 19:23:46 1404 [Note] InnoDB: Using atomics to...
4.2.1 Extended Kalman filter for the scalar case . . . . . . . . . . . . 32 4.2.2 Extended Kalman filter in matrix form. . . . . . . . . . . . . . . 33 4.2.3 Example using the extended Kalman filter ....
This publication is designed to provide accurate and authoritative information in regard to the competent professional should be sought.
zero forcing equalizer3tap
Script for computing the BER for BPSK modulation in a Rayleigh fading channel with 2 Tx, 2Rx MIMO channel Zero Forcing equalization
A 2by3 MIMO model using Simulink. The decoder uses zero forcing algorithm. Set in the workspace the modulation ... Included in the file a BER session with multiple runs and a figure for several runs.
1. Introduction to Zend Framework 1.1. 概述 1.2. 安装 2. Zend_Acl 2.1. 简介 2.1.1. 关于资源(Resource) 2.1.2. 关于角色(Role) 2.1.3. 创建访问控制列表(ACL) 2.1.4. 注册角色(Role) 2.1.5. 定义访问...
迫零均衡标准算法 matlab仿真 用以消除多径引起的ISI
zero-forcing beamforming with semi-orthogonal user selection
Codes for ofdm implementation using zero forcing equalization.
这是一个zero forcing 平衡器。可以在此基础上更改调整
1. 随机生成唯一解题目 2. 生成题目难度可指定 3. 候选数显示辅助解题 4. 实现以下逻辑解法 * 显式唯一数法,隐式唯一数法 * 区块排除法(intersection removal) * 显示数对法(Naked Pair),隐式数对法(Hidden...
with minimum mean square (MMSE) and zero forcing (ZF) algorithm,time domain decision feedback equalizer (DF_TDE) and linear frequency domain equalizer (FDE) with MMSE and ZF algorithms are used.For ...
If there is no clustered index, there is a sysindexes row for the table with an indid value of 0, and that row will keep track of the address of the first IAM for the table. The IAM is a giant bitmap...
Script for computing the BER for BPSK modulation in 3 tap ISI channel. Zero Forcing equalization with 3/5/7/9 tap is performed and the BER computed
Zero Forcing Equalization for Complex Channel
TCP/IP Illustrated, Volume 1: The Protocols W. Richard Stevens Publisher: Addison Wesley First Edition December 15, 1993 ISBN: 0201633469, 600 pages TCP/IP Illustrated, Volume 1 is a complete and...
zero forcing algorithm for energy detection