Recover oracle10g Full process when operating system is corrupted

Source: Internet
Author: User
Tags file system mkdir oracle database

Environment: ORACLE10G, operating system 5.2

The database system under the ROOTVG/oracle file system,

The data file is 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 stated parameter could not

be used.

Action:make sure the directory have specified is a valid directory/file

Specification.

6, the establishment of pfile documents

Sql> create Pfile from SPFile;

File created.

7, view the Pfile file, according to the path listed in the Pfile file, establish the corresponding path background process directory and archive directory

*.log_archive_dest_1= ' location=/oracle/app/oracle/orahome/dbs/archive '

*.background_dump_dest= '/oracle/app/oracle/admin/hb052500/bdump '

$ CD $/oracle_base/hb052500/

$ ls

Cdump Udump

$ mkdir Bdump

$ cd $ORACLE _home/dbs/

$ ls

hb052500 Init.ora Inithb052500.ora

Hc_hb052500.dat Initdw.ora Spfilehb052500.ora

$ mkdir Archive

8, startup Nomount success.

$ sqlplus/nolog

Sql*plus:release 10.1.0.2.0-production on Sun Oct 16 21:23:17 2005

Copyright (c) 1982, Oracle. All rights reserved.

Sql> Conn/as SYSDBA

Connected to a idle instance.

sql> startup Nomount;

ORACLE instance started.

Total System Global area 289406976 bytes

Fixed Size 1328912 bytes

Variable Size 262387952 bytes

Database buffers 25165824 bytes

Redo buffers 524288 bytes

Sql>

9, ALTER DATABASE mount, there are error prompts

Sql> ALTER DATABASE Mount;

ALTER DATABASE Mount

*

ERROR at line 1:

Ora-01990:error opening password file '/ORACLE/APP/ORACLE/ORAHOME/DBS/ORAPW '

Ora-27037:unable to obtain file status

IBM AIX RISC system/6000 error:2: No such file or directory

Additional Information:3

10, the establishment of password files

Orapwd file= $ORACLE _home/dbs/orapwd.ora password=oracle

11,

Sql> ALTER DATABASE Mount;

ALTER DATABASE Mount

*

ERROR at line 1:

Ora-01100:database already mounted

sql> ALTER DATABASE open;

ALTER DATABASE Open

*

ERROR at line 1:

Ora-38760:this database instance failed to turn on flashback database

Sql> ALTER DATABASE flashback off;

Database altered.

sql> ALTER DATABASE open;

Database altered.

sql> archive log list;

Database Log Mode Archive mode

Automatic Archival Enabled

Archive destination/oracle/app/oracle/orahome/dbs/archive

Oldest online log sequence 614

Next log sequence to archive 616

Current log sequence 616

Sql>

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.