5.DFQ安装_V1.docxVIP

数据库安装，参见数据库安装数据库安装完成后，点击OK继续下一步恢复数据库，此处数据库为重建数据库，根据备份恢复后，要修改ID，用以下的脚本重建在执行脚本前，需要建立以下目录（oradfq:dba）/oracle/DFQ/saptrace/usertrace/oracle/DFQ/saptrace/background/oracle/DFQ/saptrace/audit/oracle/DFQ/oraarch/oracle/DFQ/oraflash/oracle/DFQ/sapcheck/DFDLOG/mirrlogA/DFDLOG/mirrlogB/DFDLOG/origlogA/DFDLOG/origlogBchown –R oradfq:dba /DFDLOG/ (run as root)su – oradfqcd /oracle/DFQchown –R oradfq:dba sapcheck oraflash oraarch saptrace ln –s /DFDLOG/mirrlogA mirrlogAln –s /DFDLOG/mirrlogB mirrlogBln –s /DFDLOG/origlogA origlogAln –s /DFDLOG/origlogB origlogBSTARTUP NOMOUNT;CREATE CONTROLFILE set DATABASE DFQ RESETLOGS ARCHIVELOG MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXDATAFILES 1000 MAXINSTANCES 50 MAXLOGHISTORY 55246LOGFILE GROUP 1 ( /oracle/DFQ/origlogA/log_g11m1.dbf, /oracle/DFQ/mirrlogA/log_g11m2.dbf ) SIZE 200M BLOCKSIZE 512, GROUP 2 ( /oracle/DFQ/origlogB/log_g12m1.dbf, /oracle/DFQ/mirrlogB/log_g12m2.dbf ) SIZE 200M BLOCKSIZE 512, GROUP 3 ( /oracle/DFQ/origlogA/log_g13m1.dbf, /oracle/DFQ/mirrlogA/log_g13m2.dbf ) SIZE 200M BLOCKSIZE 512, GROUP 4 ( /oracle/DFQ/origlogB/log_g14m1.dbf, /oracle/DFQ/mirrlogB/log_g14m2.dbf ) SIZE 200M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE /oracle/DFQ/sapdata1/system_1/system.data1, /oracle/DFQ/sapdata1/sysaux_1/sysaux.data1, /oracle/DFQ/sapdata1/undo_1/undo.data1, /oracle/DFQ/sapdata2/sr3_1/sr3.data1, /oracle/DFQ/sapdata2/sr3_2/sr3.data2, /oracle/DFQ/sapdata2/sr3_3/sr3.data3, /oracle/DFQ/sapdata2/sr3_4/sr3.data4, /oracle/DFQ/sapdata2/sr3_5/sr3.data5, /oracle/DFQ/sapdata2/sr3_6/sr3.data6, /oracle/DFQ/sapdata3/sr3731_1/sr3731.data1, /oracle/DFQ/sapdata4/sr3usr_1/sr3usr.data1CHARACTER SET UTF8;alter database open resetlog;ALTER TABLESPACE PSAPTEMP ADD TEMPFILE /oracle/DFQ/sapdata1/temp_1/temp.data1 SIZE 8G REUSE AUTOEXTEND ON NEXT MAXSIZE 10G;shutdown immediate;完成安装