`
njliuqi
  • 浏览: 10344 次
  • 性别: Icon_minigender_1
  • 来自: 北京
最近访客 更多访客>>
社区版块
存档分类
最新评论
文章列表
############################ 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/ ...
Global site tag (gtag.js) - Google Analytics