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>