Recover oracle10g Full process when operating system is corrupted

Source: Internet
Author: User
Tags file system oracle database

Environment: ORACLE10G, operating system 5.2

The database system under the ROOTVG/oracle file system, the data file under the Datavg/oradata file system

Control files in $/oracle_home/dbs/and/oradata under two

Redo log files in $/oracle_home/dbs/and/oradata each group of log files, a total of three groups

Has the latest SPFile file backup.

1, ROOTVG damage, reinstall the operating system.

2. Install Oracle database system files

3, restore SPFile files to $/oracle_home/dbs/,

4, startup Nomount, there are error prompts, the establishment of $/oracle_base/hb052500/cdump and Udump

5, startup Nomount, there are error prompts

SQL> startup nomount
ORA-00444: background process "MMAN" failed while starting
ORA-07446: sdnfy: bad value '' for parameter . ORA-07446 sdnfy: bad value 'string' for parameter string.
Cause: The directory specified as the value for the stated parameter could not
be used.
Action: Make sure the directory you have specified is a valid directory/file
specification.

6, the establishment of pfile documents

Sql> create Pfile from SPFile;

File created.

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.