重新挂载数据库

近日更换磁盘后，进行把原来的数据库挂载起来……以下是一些操作笔记，为日后参考…… [@more@]

Step by Step up....... 1.built a start parameter file.

There is my paramter file for a display to read.

########################################

# Copyright (c) 1991, 2001, 2002 by Oracle Corporation

#########

# MTS

###########################################

dispatchers="(PROTOCOL=TCP)"

###########################################

# Optimizer

###########################################

hash_join_enabled=TRUE

query_rewrite_enabled=FALSE

star_transformation_enabled=FALSE

###########################################

# Instance Identification

###########################################

instance_name=xxg

####################

# Miscellaneous

###########################################

compatible=9.2.0.0.0

###########################################

# Security and Auditing

###########################################

remote_login_passwordfile=EXCLUSIVE

###########################################

# Sort, Hash Joins, Bitmap Indexes

###########################################

pga_aggregate_target=25165824 sort_area_size=524288

###########################################

# Database Identification

###########################################

db_domain="" db_name=xxg

###########################################

# File Configuration

###########################################

control_files=("C:oracleoradataxxgcontrol01.ctl", "D:oracleoradataxxgcontrol02.ctl",

"E:oracleoradataxxgcontrol03.ctl")

###########################################

# Pools

###########################################

java_pool_size=33554432

large_pool_size=8388608

shared_pool_size=50331648

###########################################

# Cursors and Library Cache

###########################################

open_cursors=300

###########################################

# System Managed Undo and Rollback Segments

###########################################

undo_management=AUTO

undo_retention=10800

undo_tablespace=UNDOTBS1

###########################################

# Diagnostics and Statistics

###########################################

background_dump_dest=C:oracleadminxxgbdump

core_dump_dest=C:oracleadminxxgcdump

timed_statistics=TRUE

user_dump_dest=C:oracleadminxxgudump

###########################################

# Processes and Sessions

###########################################

processes=150

###########################################

# Redo Log and Recovery

###########################################

 fast_start_mttr_target=300

###########################################

#archive mode and archive destition

###########################################

log_archive_start=true

log_archive_dest=e:oracleoradataxxgarchivearc1

log_archive_duplex_dest=e:oracleoradataxxgarchivearc2

###########################################

# Cache and I/O

###########################################

db_block_size=8192

db_cache_size=25165824 d

b_file_multiblock_read_count=16

#############################################

2.built the instance using dirctioney.

oracleadminxxgarch

oracleadminxxgbdump

oracleadminxxgudump

oracleadminxxgpfile

oracleadminxxgcreate

3.set the right loaction for the datafiles and redolog files and controlfiles.

4.Built a services for starting the instance to startup the database.

 c:>oradim -new -sid xxg -intpwd oracle -pfile %oracle_home%databaseinitxxg.ora

      -startmode auto

5.set the current instance c:>set oracle_sid=xxg

6.using the sqlplus to load the pfile.

c:>sqlplus "sys/oracle as sysdba"

7.using the pfile to startup the database for the mount status.

SQl>startup mount pfile=%oracle_home%databaseinitxxg.ora

8.On my opretor there has some error occur.

Ora-00205:error in identifying controlfile,check alter log for more info.

 Look for this error I goto see the alert file,and then see the error is:

============================================

ORA-00202: controlfile: 'C:oracleoradatadbacontrol03.ctl'

ORA-27041: unable to open file

OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。

==========================================

look at this,I remember my paratmeter file has some error,

I using the wrong control files to point the instance,

so I rewrite the parameter using the right settings like as the top list.

9.After rewrite parameter file I shutdown the database and out the

sqlplus to delete the service xxg and rebuilt the service using the rewrite

parameter file,Do all this,connect to sqlplus to load the instance.

10.On this step there has another error occur

ORA-01092: ORACLE 例程终止。强行断开连接

For this I see the trc file,the error report on the file is:

*** 2005-02-23 18:15:28.000 *** SESSION ID:(1.1)

2005-02-23 18:15:28.000 error 30012 detected in background process

ORA-30012: undo tablespace '' does not exist or of wrong type

===================================================

On there is said my parameter file has another error is the undotbs_name

its no the right name,I must to do the return job,rewrite and re startup,

and so on. SO pass that,I thought beginning our do those things we must contain

all the relate fits need us to conrrect its right,on the other side we can do it step

 by step and using the alert and trc file to fit the error,if you has much time and heart. ========================================================

11.Now the all things on this opretor is ok,the database has startup.

===================================================

Notes

===================================================

#The before work,alert,trc file is so important for us do that job.

#Anther we must have enough heart and fits.

============================================

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20546452/viewspace-790890/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20546452/viewspace-790890/