Solution for oracle redo log file hard disk failure, oracle Log File

Source: Internet
Author: User

Solution for oracle redo log file hard disk failure, oracle Log File

Solution to oracle redo log file hard disk failure

Rman target/list backup; list backup summary; delete logs in the database data folder, for example, sqlplus/as sysdbaalter system switch logfile for all files suffixed with log in/u01/app/oracle/oradata/ORCL; because the log file is not redone, it will remain waiting for loading, if you need to switch logs, the database will report the shutdown immediate error; startup will also report the recover database until cancel error; reset the redo log file of the oracle database (this recovery is not completely restored to the database) alter database open resetlogs; regenerate the redo file archive log list; view logs

Related Article

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.