Backup Recovery-----system table Space corruption

Source: Internet
Author: User

Unable to close the library, error is as follows

sql> shutdown Immediate
Ora-01122:database file 1 failed verification check
Ora-01110:data file 1: '/U01/APP/ORACLE/ORADATA/CUUG/SYSTEM01.DBF '
Ora-01210:data file header is media corrupt
Sql>

Only boot to Mount state

Sql> Startup
ORACLE instance started.

Total System Global area 425897984 bytes
Fixed Size 2226656 bytes
Variable Size 322962976 bytes
Database buffers 96468992 bytes
Redo buffers 4239360 bytes
Database mounted.
Ora-01157:cannot identify/lock data file 1-see DBWR trace file
Ora-01110:data file 1: '/U01/APP/ORACLE/ORADATA/CUUG/SYSTEM01.DBF '

Sql>

To manually delete a data file for the system table space

[Email protected]:/u01/app/oracle/oradata/cuug]# ls
Control01.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
Control02.ctl redo02.log sysaux01.dbf temp01.dbf users01.dbf
[Email protected]:/u01/app/oracle/oradata/cuug]# rm-rf system01.dbf
[Email protected]:/u01/app/oracle/oradata/cuug]# ls
Control01.ctl redo01.log redo03.log temp01.dbf users01.dbf
Control02.ctl Redo02.log sysaux01.dbf undotbs01.dbf
[[Email protected]:/u01/app/oracle/oradata/cuug]#

Boot to mount under Rman

Rman> Startup Mount

Connected to target database (not started)
Oracle instance started
Database mounted

Total System Global area 425897984 bytes

Fixed Size 2226656 bytes
Variable Size 322962976 bytes
Database buffers 96468992 bytes
Redo buffers 4239360 bytes

Rman>

Dump DataFile 1

rman> restore datafile 1;

Starting restore at 29-sep-15
Allocated Channel:ora_disk_1
Channel ORA_DISK_1:SID=18 Device Type=disk

Channel ora_disk_1:starting datafile backup set restore
Channel ora_disk_1:specifying DataFile (s) to the restore from backup set
Channel ora_disk_1:restoring datafile 00001 to/u01/app/oracle/oradata/cuug/system01.dbf
Channel ora_disk_1:reading from backup Piece/backup/02qidfdl_1_1.bak
Channel Ora_disk_1:piece Handle=/backup/02qidfdl_1_1.bak tag=tag20150929t230940
Channel ora_disk_1:restored backup Piece 1
Channel Ora_disk_1:restore complete, elapsed time:00:01:55
Finished restore at 29-sep-15

Recovery DataFile 1

Rman>recover datafile 1;

Starting recover at 29-sep-15
Using channel Ora_disk_1

Starting Media recovery
Media recovery complete, elapsed time:00:00:01

Finished recover at 29-sep-15

Open Library

rman> ALTER DATABASE open;

Database opened

Rman>

Backup Recovery-----system table Space corruption

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.