RAC+ASM在单机上恢复的过程

核心提示： -- 修改后的参数ibm1 ->cat initccdb1.ora*.audit_file_dest='/oracle/admin/ccdb/adump'*.background_dump_dest='/oracle/admin/ccdb/bdump'

-- 修改后的参数

ibm1 ->cat initccdb1.ora
*.audit_file_dest='/oracle/admin/ccdb/adump'
*.background_dump_dest='/oracle/admin/ccdb/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/oradata/ccdb/control01.dbf'
*.core_dump_dest='/oracle/admin/ccdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ccdb'
*.db_recovery_file_dest_size=10737418240
*.dispatchers=''
*.job_queue_processes=10
*.log_archive_dest_2='LOCATION=/oralog/ccdb/'
*.log_archive_format='%t_%s_%r.dbf'
*.log_archive_local_first=TRUE
*.open_cursors=300
*.pga_aggregate_target=1029701632
*.processes=1000
*.recyclebin='OFF'
*.remote_login_passwordfile='exclusive'
*.sessions=1105
*.sga_max_size=3221225472
*.sga_target=1610612736
*.undo_management='AUTO'
*.user_dump_dest='/oracle/admin/ccdb/udump'

-- 根据pfile 创建spfile, 并 startup nomount.

ibm1 ->sqlplus
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jun 26 15:13:43 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 3221225472 bytes
Fixed Size 2076312 bytes
Variable Size 1996489064 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14700544 bytes
SQL>