Redo File Loss Recovery

Source: Internet
Author: User

Redo file Best Use multiplexing: To prevent a single point of failure, if not multiplexing, in the redo file loss, the database will be an error, how to recover it, as follows:

Sql> startup;
ORACLE instance started.

Total System Global area 218103808 bytes
Fixed Size 2019672 bytes
Variable Size 113249960 bytes
Database buffers 96468992 bytes
Redo buffers 6365184 bytes
Database mounted.
Ora-00313:open failed for members of log Group 1 of thread 1
Ora-00312:online Log 1 Thread 1: '/u01/oradata/hzkj/redo01.log '


sql> recover database until cancel using Backup controlfile;
Ora-00279:change 882256 generated at 10/19/2010 15:36:50 for thread 1
Ora-00289:suggestion:/u01/arch/1_5_732812782.dbf
Ora-00280:change 882256 for thread 1 was in sequence #5


Specify log: {<ret>=suggested | AUTO | CANCEL}
Cancel
Media recovery cancelled.


sql> ALTER DATABASE open resetlogs;

Database altered.

Sql>

The database is open successfully. Oh, it turns out so simple

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.