(NBU成功恢复.doc

./bplist –S ‘server’ –C ‘clint’ –t 4 –R –l / SQL create pfile=/home/oracle/initrec.ora from spfile; File created. SQL exit 原来的init $ more initrec.ora PSAICNJ1.__db_cache_size=7683964928 PSAICNJ2.__db_cache_size=6761218048 PSAICNJ1.__java_pool_sizePSAICNJ2.__java_pool_sizePSAICNJ1.__large_pool_sizePSAICNJ2.__large_pool_sizePSAICNJ1.__shared_pool_size=822083584 PSAICNJ2.__shared_pool_size=1761607680 PSAICNJ1.__streams_pool_sizePSAICNJ2.__streams_pool_size*.audit_file_dest=/u01/app/oracle/admin/PSAICNJ/adump *.background_dump_dest=/u01/app/oracle/admin/PSAICNJ/bdump *.cluster_database_instances=2 *.cluster_database=true *.compatible=.0 *.control_files=+DATA/psaicnj/controlfile/current.256.692215713 *.core_dump_dest=/u01/app/oracle/admin/PSAICNJ/cdump *.db_block_size=8192 *.db_create_file_dest=+DATA *.db_domain= *.db_file_multiblock_read_count=16 *.DB_FILE_NAME_CONVERT=+DATA01,+DATA *.db_name=PSAICNJ *.db_unique_name=psaicnj *.FAL_CLIENT=psaicnj *.FAL_SERVER=stdby PSAICNJ1.instance_number=1 PSAICNJ2.instance_number=2 *.job_queue_processes=10 *.local_listener= *.lock_sga=TRUE *.log_archive_config=dg_config=(psaicnj,stdby) PSAICNJ1.log_archive_dest_1=location=/home/oracle valid_for=(all_logfiles,all_roles) db_unique_name=psaicnj *.log_archive_dest_1=location=/bak/arch valid_for=(all_logfiles,all_roles) db_unique_name=psaicnj *.log_archive_dest_2=service=stdby valid_for=(online_logfiles,primary_role) db_unique_name=psaicnj delay=120 r eopen *.log_archive_dest_state_1=enable *.log_archive_dest_state_2=enable *.log_archive_format=%t_%s_%r.arc *.log_archive_max_processes=5 *.open_cursors=300 *.pga_aggregate_target=3304062976 *.processes=300 *.remote_listener=LISTENERS_PSAICNJ *.remote_login_passwordfile=exclusive *.sga_max_size=8589934592 *.sga_target=8589934592 *.STANDBY_FILE_MANAGEMENT=AUTO PSAICNJ2.thread=2 PSAICNJ1.thread=1 *.undo_management=AUTO PSAICNJ1.undo_tablespace=UNDOTBS1 PSAICNJ2.undo_tablesp