工程日志數(shù)據(jù)庫(kù)遷移到asm-資料下載頁(yè)
2025-06-24 12:09本頁(yè)面
【正文】 atabase altered.15:29:50 SYS@ prodselect member from v$logfile。MEMBER+DG1/prod/onlinelog/+DG1/prod/onlinelog/+DG1/prod/onlinelog/+DG1/prod/onlinelog/5 重啟遇到問題[15:35:18oracle@aix207 dbs]$sqlplus 39。/as sysdba39。SQL*Plus: Release Production on Thu Mar 27 15:35:20 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.15:35:20 SYS@ prodstartupORACLE instance started.Total System Global Area 612368384 bytesFixed Size 2022800 bytesVariable Size 142606960 bytesDatabase Buffers 461373440 bytesRedo Buffers 6365184 bytesORA00205: error in identifying control file, check alert log for more info控制文件報(bào)錯(cuò)15:35:29 SYS@ prodshow parameter controlNAME TYPE VALUE control_file_record_keep_time integer 7control_files string +DG1, +DG1, +DG115:38:29 SYS@ prodshow parameter pfile。NAME TYPE VALUE spfile string +DG1/15:39:10 SYS@ prodalter system set db_create_file_dest=39。+DG139。 sid=39。prod39。System altered.15:39:36 SYS@ prodalter system set control_files=39。 +DG1/39。 scope=spfile sid=39。prod39。System altered.15:43:28 SYS@ prodcreate pfile=39。/home/oracle/39。 from spfile=39。+DG1/39。File created. [15:49:32oracle@aix207]$vi =461373440=4194304=4194304=134217728=0*.audit_file_dest=39。/u01/app/oracle/admin/prod/adump39。*.background_dump_dest=39。/u01/app/oracle/admin/prod/bdump39。*.patible=39。39。*.control_files=39。+DG1/prod/controlfile/39。,39。+DG1/prod/controlfile/39。,39。+DG1/prod/controlfile/cu39。Restore Controlfile=39。 +DG1/39。注意：如果這行不注釋，重啟數(shù)據(jù)庫(kù)ALTER SYSTEM SET CONTROL_FILES不生效*.core_dump_dest=39。/u01/app/oracle/admin/prod/cdump39。*.db_block_size=8192=39。+DG139。*.db_domain=39。39。*.db_file_multiblock_read_count=16*.db_name=39。prod39。*.db_recovery_file_dest_size=2147483648*.db_recovery_file_dest=39。/disk1/flash_recovery_area39。*.dispatchers=39。(PROTOCOL=TCP) (SERVICE=prodXDB)39。*.event=39。10298 trace name context forever,level 3239。*.job_queue_processes=10*.log_archive_dest_1=39。LOCATION=/arch/archive mandatory39。*.open_cursors=300*.pga_aggregate_target=203423744*.processes=150*.remote_login_passwordfile=39。EXCLUSIVE39。*.sga_target=612368384*.undo_management=39。AUTO39。*.undo_tablespace=39。UNDOTBS139。*.user_dump_dest=39。/u01/app/oracle/admin/prod/udump39。16:01:02 SYS@ prodstartup nomount force pfile=39。/home/oracle/39。ORACLE instance started.Total System Global Area 612368384 bytesFixed Size 2022800 bytesVariable Size 142606960 bytesDatabase Buffers 461373440 bytesRedo Buffers 6365184 bytes16:01:02 SYS@ prodcreate spfile=39。+DG1/39。 from pfile=39。/home/oracle/ 39。15:45:01 SYS@ prodshutdown immediateORA01507: database not mountedORACLE instance shut down.16:05:14 SYS@ prodstartupORACLE instance started.Total System Global Area 612368384 bytesFixed Size 2022800 bytesVariable Size 142606960 bytesDatabase Buffers 461373440 bytesRedo Buffers 6365184 bytesDatabase mounted.Database opened.16:01:41 SYS@ prodselect name from v$controlfile。NAME+DG1/prod/controlfile/+DG1/prod/controlfile/+DG1/prod/controlfile/16:01:56 SYS@ prodselect name from v$datafile。NAME+DG1/prod/datafile/+DG1/prod/datafile/+DG1/prod/datafile/+DG1/prod/datafile/+DG1/prod/datafile/16:02:04 SYS@ prodselect member from v$logfile。MEMBER+DG1/prod/onlinelog/+DG1/prod/onlinelog/+DG1/prod/onlinelog/+DG1/prod/onlinelog/16:02:13 SYS@ prodselect instance_name,status from v$instance。INSTANCE_NAME STATUS prod OPEN16:02:28 SYS@ prodselect file,checkpoint_change from v$datafile。 FILE CHECKPOINT_CHANGE 1 2950368 2 2950368 3 2950368 4 2950368 5 295036816:02:55 SYS@ prodselect file,checkpoint_change from v$datafile_header。 FILE CHECKPOINT_CHANGE 1 2950368 2 2950368 3 2950368 4 2950368 5 2950368數(shù)據(jù)庫(kù)恢復(fù)正常 [后續(xù)工作計(jì)劃]再進(jìn)行多方面的測(cè)試，與公司相關(guān)人員交流，探討解決方案。迪思杰（北京）數(shù)碼技術(shù)有限公司 Page 17 of 17 竭誠(chéng)為您服
語(yǔ)文相關(guān)推薦
鄂ICP備17016276號(hào)-1