njliuqi
- 浏览: 10344 次
- 性别:
- 来自: 北京
-
最新评论
文章列表
############################
station 1(primary database)
#############################
IPADDR:192.168.1.4
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
ORACLE_SID=primary
db_unique_name=primary
############################
station 2(standby database)
###########################
IPADDR:192.168.1.8
ORAC ...
1. query
SQL>SELECT name FROM V$DATAFILE;
NAME
--------------------------------------------------------------------------------
+DGROUP1/edison/datafile/system.256.735732721
+DGROUP1/edison/datafile/undotbs1.258.735732723
+DGROUP1/edison/datafile/sysaux.257.735732721
+DGROUP1/edison/datafile/users ...
1. create virtual disk
[root@localhost~]# fdisk -l
/dev/sda1
/dev/sdb1
/dev/sdc1
/dev/sdd1
/dev/sde1
2. install oracle asm lib
rpm -ivh oracleasm-support-2.0.3-1
rpm -ivh oracleasm-2.6.18-8.el5-2.0.4-1.el5
rpm -ivh oracleasmlib-2.0.3-1.el5
== create user and group == [root@localhost ...
官方说明文档 http://www.oracle.com/technology/global/cn/deploy/availability/htdocs/Flashback_Overview.htm
1. Overview of Flashback Features
Oracle Database has a group of features, known collectively as flashback, that provide ways to view past states of database objects or to return database objects to ...
A stamp that defines a committed version of a database at a point in time. Oracle assigns every committed transaction a unique SCN.
SCN是顺序递增的一个数字，在Oracle中用来标识数据库的每一次改动，及其先后顺序。SCN的最大值是0xffff.ffffffff。
Commit SCN
Offline SCN
Checkpoint SCN
Resetlog SCN
Stop SCN
High and Low SCN
3. SCN & ...
1. SEGMENT EXTEND BLOCK
http://cotana/wiki/?action=userform&uid=1242887634.4.5192
2. memory structures
Type
Description
Database buffer cache
Memory area userd to store blocks read from data files. Data is read into the blocks by server processes and written out by DBWn asynchronously. ...
1. 测试系统 rhel 5.4 + oracle 10g r 2
系统中有c,c++的编译环境，要安装以下rpm
rpm -ivh kernel-headers-2.6.18-164.el5.i386.rpm
rpm -ivh compat-glibc-headers-2.3.4-2.26.i386.rpm
rpm -ivh compat-glibc-2.3.4-2.26.i386.rpm
rpm -ivh compat-libstdc++-33-3.2.3-61.i386.rpm
rpm -ivh compat-libf2c-34-3.4.6-4.i386.rpm
...
1.必须已有的安装包：perl
GNU readline http://cnswww.cns.cwru.edu/php/chet/readline/rltop.html
Term::ReadLine::Gnu http://search.cpan.org/dist/Term-ReadLine-Gnu/
IO::Tty http://search.cpan.org/dist/IO-Tty/
2.安装包：
readline-4.3.tar.gz
uniread-1.01.tar.gz http://sourceforge.net/projects/uniread/
...