【正文】 te materialized view log on T tablespace users with rowid。2）建立一個(gè)跨庫的物化視圖，不要求快刷、指定刷新頻率,只要能建出來、能刷新即可。 END。MV_T139。MV_T139。MV_T39。Materialized view created.SQL DELETE T WHERE ROWNUM = 1。如果基表不包括UPDATE和DELETE，只有INSERT操作，那么物化視圖中可以去掉COUNT(*)列。Materialized view created.物化視圖使用GROUP BY的寫法和使用DISTINCT的寫法是等價(jià)的，而且可以使用快速刷新。FROM T*ERROR at line 3:ORA12015: cannot create a fast refresh materialized view from a plex querySQL CREATE MATERIALIZED VIEW MV_T_COMPLETE 2 AS SELECT DISTINCT OWNER, OBJECT_TYPE 3 FROM T。Table created.SQL CREATE MATERIALIZED VIEW LOG ON T2 WITH ROWID, SEQUENCE (OWNER, OBJECT_TYPE) 3 INCLUDING NEW VALUES。s Guide10 Managing the Recovery CatalogCreating a Recovery Catalog2）Backup and Recovery Reference CONFIGURE搜索pressed（五）Section 4:數(shù)據(jù)倉庫管理【在db機(jī)操作】物化視圖n 例題1）創(chuàng)建一個(gè)能夠快速刷新的物化視圖，要求物化視圖能消除表中行的重復(fù)值。相關(guān)視圖V$flashback_database_logsection3階段考試需要注意的具體事項(xiàng)1）使用RMAN進(jìn)行全庫備份之后，馬上使用手工方式對(duì)數(shù)據(jù)庫再做一個(gè)冷備。（該參數(shù)用來控制flashback log 數(shù)據(jù)保留的時(shí)間，或者說，你希望flashback database 能夠恢復(fù)的最早的時(shí)間點(diǎn)。（啟動(dòng)Flashback功能）SQL select flashback_on from v$database。（禁用Flash Recovery Area的命令）3）啟用數(shù)據(jù)庫Flashback 功能SQL startup mount；SQL select name, current_s, flashback_on from v$database。39。 SCOPE=BOTH。（注意先后順序，先設(shè)置大小，再設(shè)置位置）SQLALTER SYSTEM SET DB_RECOVERY_FILE_DEST=39。alter database open。startup mount。丟失一個(gè)controlfile的恢復(fù)丟失datafile 1的恢復(fù)打開flashback database的功能（即配置flashback 數(shù)據(jù)庫）1）將數(shù)據(jù)庫設(shè)置為歸檔模式。BACKUP ARCHIVELOG ALL DELETE INPUT。3）使用RMAN進(jìn)行全庫備份。需要單獨(dú)記憶的一個(gè)命令：RMANCONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 39。/oracle/oradata/orcl/backup/cf_%F39。RMANCONFIGURE CONTROLFILE AUTOBACKUP ON。RMANCONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 39。如，configure device type disk backup type to pressed backupset parallelism 2。4）重新同步Recovery CatalogRESYNC CATALOG。RMAN REPORT SCHEMA。2）創(chuàng)建Recovery Catalogrman catalog rman/oracle或RMAN CONNECT CATALOG rman/catcatdbCREATE CATALOG TABLESPACE cat_ts。（四）Section 3：數(shù)據(jù)庫備份恢復(fù)【在db機(jī)操作】catalog的創(chuàng)建及同步1）創(chuàng)建recovery catalog schemaCONNECT SYS/oraclecatdb AS SYSDBACREATE USER rman IDENTIFIED BY cat TEMPORARY TABLESPACE temp DEFAULT TABLESPACE tools QUOTA UNLIMITED ON tools。3）在安裝grid control時(shí)當(dāng)提示設(shè)置某用戶的密碼時(shí)，一定要有字母、有數(shù)字，如oracle15）盡量在一臺(tái)機(jī)器上操作。section2階段考試需要注意的具體事項(xiàng)1）一定要注意配置/etc/hosts文件，將主機(jī)名與ip地址map起來。第四，配置通知。授權(quán)和角色。第二，創(chuàng)建一些表空間。gridcontrol的配置1）使用grid control對(duì)數(shù)據(jù)庫做一些操作第一，配置pga_aggregate_target等一些初始化參數(shù)。如果發(fā)現(xiàn)某個(gè)準(zhǔn)備要管理的對(duì)象在EM的瀏覽器操作界面中看不到，就手動(dòng)添加一下。在被管理的數(shù)據(jù)庫中（手動(dòng)建的那個(gè)庫和后來用dbca建的那個(gè)資料庫）， 將dbsnmp用戶解鎖，并設(shè)置密碼為oracle。用這種方法安裝Agent的速度很快，而且無需任何人工參與。然后，使用oracle用戶./ b 安裝目錄（在手動(dòng)建庫的機(jī)器上操作）。shell方式安裝agent。自動(dòng)建立sysman用戶。地址：xxx 　Smtp Server：。.existing dboms 不選no option，sga=300mprefil（千萬別忘了點(diǎn)prefill,以驗(yàn)證數(shù)據(jù)文件是否可以用）對(duì)于Repository庫是有一些初始化參數(shù)的要求的，我們需要做的就是設(shè)置SGA_TARGET = 300M，這樣內(nèi)存參數(shù)就自動(dòng)管理了，安裝OMS不會(huì)報(bào)任何錯(cuò)誤，另外對(duì)于job queue等其它的參數(shù)，在點(diǎn)擊開始安裝之后的某個(gè)界面，會(huì)彈出一個(gè)警告框，告訴你哪些參數(shù)不符合要求，如session_cached_cursors、aq_tm_processe等，需要改為多少多少，OK，安裝這個(gè)界面里的要求，依次修改數(shù)據(jù)庫的參數(shù)，然后重新啟動(dòng)數(shù)據(jù)庫，不需要退出安裝界面，在重啟完數(shù)據(jù)庫之后，點(diǎn)確定，直接繼續(xù)安裝就可以了。檢查db機(jī)的監(jiān)聽是否正常，如果有問題趕快調(diào)整。待dbca建庫完成之后。建庫時(shí)所有特殊選項(xiàng)全部去掉，建一個(gè)最簡(jiǎn)單的庫即可。s Guide10 Configuring and Administering the ListenerRegistering Information with a Nondefault Listener（三）Section 2：Gridcontrol安裝配置【在gridcontrol機(jī)上安裝gridcontrol軟件，在db機(jī)創(chuàng)建gridcontrol要使用的資料庫】girdcontrol的安裝安裝步驟如下：第一，做好安裝前的準(zhǔn)備工作。第二，：shuai=(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=salessvr)(PORT=1421)) (CONNECT_DATA=(SERVICE_NAME=shuai) (server=shared))第三，使用system用戶連接數(shù)據(jù)庫，方式如下：sqlplus system/oracleshuai第四，查看system用戶的連入方式。alter system set max_shared_servers=10 scope=both。 scope=both。alter system set dispatchers=39。lsnrctl start二、如何配置共享服務(wù)器模式。 scope=both。alter system set LOCAL_LISTENER=39。網(wǎng)絡(luò)配置n 例題一、如何配置一個(gè)非默認(rèn)端口的監(jiān)聽，并啟動(dòng)它。alter database default tablespace tbs1。39。)Note:Applications that use Oracle10g features will be running therefore, ensure the database and instance are appropriately configured.答案：主要是根據(jù)題目要求調(diào)整數(shù)據(jù)庫的初始化參數(shù)。,39。,39。八、As user SYS,run the script /home/oracle/scripts/. Ignore any errors concerning do not ignore any other errors.Investigate the parameter file for reasonable size for each parameter listed. Add additional parameters as you deem necessary to support an optimal database environment. In addition, modify or add the following listed parameters:UTL_FILE_DIR=(39。注意：日志組的2個(gè)member應(yīng)該分布在2個(gè)不同的磁盤上。/u01/app/oradata/shuai/39。) SIZE 100m,group 5 (‘/u01/app/oradata/test/’,’/u01/app/oradata/test/’) size 100m。, 39。六、Due to the expected high volumn of transaction, the database should have the following configuration:A minimum of 5 redo log groupsEach redo log group should not be a single point of failureFile size of 100MBSpecify the Location such that it minimizes contention and reduces the risk of a single point of failure case of disk drive failure.答案：sqlALTER DATABASE ADD LOGFILE GROUP 4 (39。四、Create a permanent tablespace to store data collected from the various Oracle the following specification:Tablespace name of toolsFile size of 48MBInitial extent size of 4MBNext extent size of 4MB答案：create tablespace tools datafile ‘……’size 48m extent management local uniform size 4m。 size 400m autoextend on maxsize 4g extent management local uniform size 1m。二、Create a permanent tablespace to store sample test the following specification:Tablespace name of EXAMPLEInitial datafile size of 400MB with the file expected to grow to 4GB.Initial extent size of 1MBNext extent size of 1MB答案：create tablespace example datafile 39。alter database default temporary tablespace TEMP_GRP。/u01/app/oradata/39。 size 50m tablespace group TEMP_GRP。參考的聯(lián)機(jī)文檔administrator’s guide2 creating a oracle database Manually Creating an Oracle Database（二）Section 1：數(shù)據(jù)庫和網(wǎng)絡(luò)的配置【在db機(jī)操作】數(shù)據(jù)庫配置（管理表空間）有如下考題需要注意：一、Create a temporary tablespace group that contains two temporary tablespaces to support batch process about creation of large indexes,and analyzing tables. Use the following specification:Temporary tablespace group named TEMP_GRP contain