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>