Restore the entire process of Oracle10g when the operating system is damaged

Source: Internet
Author: User

Restore the entire process of Oracle10g when the operating system is damaged

Environment: oracle10g, operating system 5.2

The database system is under rootvg/oracle file system,

The data file is under datavg/oradata File System

The control file is under $/ORACLE_HOME/dbs/AND/oradata.

Redo log files in $/ORACLE_HOME/dbs/AND/oradata each have one log file, three groups in total

The latest spfile file backup is available.

1. rootvg is damaged. reinstall the operating system.

2. Install the oracle Database System File

3. Restore the spfile to $/ORACLE_HOME/dbs,

4. startup nomount. The error message is displayed. Create $/ORACLE_BASE/hb052500/cdump and udump.

5. startup nomount, error prompt

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 cocould not

Be used.

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

Specification.

6. Create a pfile

SQL> create pfile from spfile;

File created.

7. view the pfile file and create the background process directory and archive directory according to the paths listed in the pfile file.

*. 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 is successful.

$ Sqlplus/nolog

SQL * Plus: Release 10.1.0.2.0-Production on Sun Oct 16 21:23:17 2005

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

SQL> conn/as sysdba

Connected to an 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, error prompt

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. Create a password file

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>

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.