Shulou(Shulou.com)05/31 Report--

This article mainly introduces oracle non-archiving mode, there is no backup, direct power outage leads to Undo damage how to do, the article is very detailed, has a certain reference value, interested friends must finish!

Non-archived mode, no backup, Undo damage caused by direct power outage

Start the database and check the fault information

SQL > conn / as sysdba

SQL > startup pfile=''

Error report, ORA-03113:end-of-file on communucation channel

Check the alert log and find that an error occurred in file 2, resulting in a 600th error.

Check the name of file 2 first.

SQL > conn / as sysdba

SQL > startup mount pfile=''

SQL > select file#,status,name from v$datafile

Check that file 2 is a undo data file, check the information, when undotbs is damaged, you can use implicit parameters to temporarily start the database, and then repair it.

Modify the init file to add

. _ allow_resetlogs_corruption=true (allows you to start the database if the data file SCN is inconsistent)

. _ corrupted_rollback_segments= (_ SYSSMU1 $, _ SYSSMU2 $, _ SYSSMU3 $, _ SYSSMU4 $, _ SYSSMU5 $, _ SYSSMU6 $

_ SYSSMU7 $, _ SYSSMU8 $, _ SYSSMU9 $, _ SYSSMU10 $, _ SYSSMU11 $) allows you to start the database if rollback segments is corrupted

SQL > shutdown abort

SQL > startup pfile=''

Start successfully to view the current rollback segments

SQL > select segment_name,status from dba_rollback_segs

Create a new redo tablespace undo

SQL > create undo tablespace undo datafile''size 50m reuse autoextend on

SQL > select segment_name,status from dba_rollback_segs

Modify the default Undo segment of the system

SQL > alter system set undo_tablespace=undo

Delete corrupted undotbs1 tablespace

SQL > alter tablespace undotbs1 offline normal

SQL > drop tablespace undotbs1 including contents and datafiles

SQL > select from v$recover_file

Innumerable data

SQL > shutdown immediate

Modify the parameter file and comment out the parameters you just added

#. _ allow_resetlogs_corruption=true (allows you to start the database if the data file SCN is inconsistent)

# *. _ corrupted_rollback_segments= (_ SYSSMU1 $, _ SYSSMU2 $, _ SYSSMU3 $, _ SYSSMU4 $, _ SYSSMU5 $, _ SYSSMU6 $

_ SYSSMU7 $, _ SYSSMU8 $, _ SYSSMU9 $, _ SYSSMU10 $, _ SYSSMU11 $) allowed in rollback

Start the database:

SQL > startup pfile=''

The above is "oracle non-archived mode, no backup, direct power outage caused by Undo damage how to do" all the contents of this article, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.