ITPub博客

Why does an online redolog keeps active after checkpoint completion?From : www.orafaq.com[@more@]Re: Why does an online redolog keeps active after checkpoint completion?From: Anton Buijs <remove_aammbuijs_at_xs4all.nl> Date: Sat, 2 Aug 2003 20:37:42 +0200Message-ID: <3f2c0506$0$49107$e4fe514c@news.xs4all.nl> Dave Hau <davehau-no-spam-123_at_no-spam.netscape.net> schreef in berichtnieuws OoSWa.122$6d2.89_at_newssvr22.news.prodigy.com... | "Anton Buijs" <remove_aammb

一，自信心 二， 堅韌三，循序漸進，不可急躁四，用心揣摩，斟酌五，多做試驗六，準確的自我評估[@more@]-----------------------------------------一，自信心 要相信自己有能力和技巧解決碰到的任何問題與困難。這是一場決鬥，勝利屬於勇者。二，堅韌百折不撓，字字如金。其中深意非親身體會所能領悟的到。三，循序漸進，不可急燥“急燥” ，需修身養性方可克服。四，用心揣摩，斟酌凡事惟有用心，才會有成功的機會。五，多做試驗事非經過不知難。隻有親身經歷才知其中玄機。六，準確的自我評估

Shared Server[@more@]DISPATCHERS="(ADDRESS=(PROTOCOL=tcp) (HOST=144.25.16.201)(PORT=5000))(DISPATCHERS=1)" DISPATCHERS="(ADDRESS=(PROTOCOL=tcp) (HOST=144.25.16.201)(PORT=5001))(DISPATCHERS=1)" Note: You can specify multiple DISPATCHERS in the initialization file, but they must be adjacent to each other.

RMAN Until Time Recoverybackup current controlfile;tag : 最多 32 個字符[@more@]run{set until time ="timestamp '2005-09-29 08:04:01'";restore database;alter database mount;recover database;alter database open resetlogs;}then do full database backup;

1 , create tablespace rman_ts datafile '' size 20m extent management local uniform size 128k ;2 , create user rman_user identified by rman default tablespace rman_ts quota unlimited on rman_ts;3 , grant recovery_catalog_owner to rman_user ; grant connect , resource to rman;4 , rman catalog rman_user/rman@rman ; create catalog tablespace rman_ts;5 , connect target 'sys/password@sid as sysdba'6 , register database[@more@]

Oracle RMAN Backup and Recover test after creating database , the catalog.sql , catproc.sql must be executed in sqlplus using sysdba;[@more@]測試環境：win2003 server , oracle 92 , NOarchivelog mode1,cannot backup database in open or nomount mode;2,backup must be done in mount mode.

RMAN Backup Closed database backup :Target database must be mounted(not open);Include datafiles , control files , archived redo log files.Open database backup :Tablespace should not be put in backup mode;Include datafiles , control files , archived redo log files.Image Copy :Backup Set :Full BackupIncremental backup (differential backup , cumulative backup)Multiplexed Backup Sets :Multiplexing is controlled by the following : Filesperset , Maxopenfiles.Parallelization of Backup Sets :1,Configuri

Export and Import Utilities[@more@]Export File:is an Oracle binary-format dump file that is typically located on disk or tape.Create session , Imp_full_database , Exp_full_database , exp 'test/test@orcvk as sysdba' transport_tablespace= y tablespaces=test file = 'e:test_data.dmp' log='e:test_dmp.log' Export Parameters :rows : specifies whether or not the rows of table data are exporteddirect : specifies use of direct path

Oracle Parameters:[@more@]control_file_record_keep_time (default 7 days) control_files db_create_file_dest db_create_online_log_dest_n ( n:1-5) db_block_size db_cache_size db_nk_cache_size (n : 2,4,8,16,32) log_archive_start log_archive_dest_n ( n: 1-10 ) log_archive_dest_state_n ( n: 1-10 ) log_archive_dest log_archive_duplex_dest log_archive_format (Example:%%oracle_sid%%T%TS%S.ARC) log_archive_max_processes log_archive_min_succeed_dest log_archive_trace remote_archive_enable

Client-------------------------Oracle Database Server--------------------------------------------------------[@more@]Client Application(uses OCI) --------Oracle RDBMS(uses OPI)Two Task Common -----------------Two Task CommonOracle Net Foundation Layer -------Oracle Net Foundation LayerOracle Protocol Support---------------Oracle Protocol SupportNetwork Protocol -------------------Network Protocol

QUESTION 132 -----------------------------------------------------------132. Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts.Today your database crashes and you now want to use the backups from last night. What do you need to do?A.You need to perform the restore and recover operations manually, because the backup was made manually. B.First yo

Timestamp , interval year to month , interval day to second:create table test_data_type(start_time timestamp(6) , duration_1 interval day(6) to second(6) , duration_2 interval year(2) to month );insert into test_data_type(start_time) select to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss' ) ,'yyyy-mm-dd hh24:mi:ss.ff') from dual;select start_time , sysdate , start_time - sysdate from test_data_type;insert into test_data_type(duration_1)select interval '5 2' day to hour - interval '1:30' hour

一，實施步驟： 1,整理源數據庫中表，索引，視圖，及存儲過程。計劃導入的先後順序。 2,計劃從sql server 到 oracle 數據類型的對應及轉換，特別注意日期類型。 3,用 sql server 中的創建角本工具生成一些數據庫對象的創建角本。 4,用 sql server 中的導入導出工具導出表中的數據到文本文件中。 5,用 Oracle sql*loader 裝載數據。二，結論： 1,從中觀察到：一個 20648 行的表，大約要用 30M 左右的空間。The Control File Script :-- Import lk_job_register table-- Created 2005-08

在這裡，將記錄下，我的人生之路。[@more@]