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

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>