安科网

最简单的11g Active DataGuard(ADG)搭建配置过程（项目步骤）

HackAge

HackAge

2015-07-25

关注 关注

一、环境介绍:
    我在db01和db02两台Linux虚拟机上首先分别安装了一套数据库软件，在db01主机上创建了名为woo的数据库；我们这次的实验是要搭建了一套Oracle 11g Active DataGuard；目的是为了实现数据库同步的功能，并且了解Oracle 11g DG的基本功能。

db01:192.168.1.50
db02:192.168.1.51

二、11g ADG部署：

1、pri端和sty端配置静态监听

[oracle@sty admin]$ cat listener.ora
 
# listener.ora Network Configuration File: /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /DBSoft/oracle/product/11.2.4/dbhome_1)

    (PROGRAM = extproc)

    )

      (SID_DESC =

    (SID_NAME = Woo )

    (ORACLE_HOME = /DBSoft/oracle/product/11.2.4/dbhome_1)

    )

  )

 

[oracle@sty admin]$cat tnsname.ora

# tnsnames.ora Network Configuration File: /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

STY =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = woo)

    )

  )

PRI =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.50)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = woo)

    )

  )

2、修改primary端初始化参数文件

startup mount;
 
alter database archivelog;

alter database force logging;

alter database open;

alter system set log_archive_config = 'DG_CONFIG=(pri,sty)' scope=spfile;

alter system set log_archive_dest_1 = 'LOCATION=/DBBackup/Archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pri' scope=spfile;

alter system set log_archive_dest_2 = 'SERVICE=sty LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=sty' scope=spfile;

alter system set log_archive_dest_state_1 = ENABLE;

alter system set log_archive_dest_state_2 = ENABLE;

alter system set fal_server=sty scope=spfile;

alter system set fal_client=pri scope=spfile;

alter system set standby_file_management=AUTO scope=spfile;

3、在primary端pfile参数文件和密码文件，并且拷贝到standby段相应位置

SQL> create pfile from spfile;
 

File created.

[oracle@db01 dbs]$ scp initwoo.ora orapwwoo db02:/DBSoft/oracle/product/11.2.4/dbhome_1/dbs

[email protected]'s password:
 initwoo.ora                                                                                    100% 1260    1.2KB/s  00:00   
 orapwwoo                                                                                      100% 1536    1.5KB/s  00:00

 [oracle@db01 oracle]$ scp -r admin/ diag/ fast_recovery_area/ oradata/ 192.168.1.51:$ORACLE_BASE
 [email protected]'s password:
 init.ora.512201522543                                                                          100% 1778    1.7KB/s  00:01   
 dp.log                                                                                        100%  116    0.1KB/s  00:00   
 ........

   

4、修改standby端的监听文件及初始化参数文件

--修改监听文件
 
[oracle@db02 ~]$ cd $ORACLE_HOME/network/admin

[oracle@db02 admin]$ vi listener.ora

# listener.ora Network Configuration File: /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = db02)(PORT = 1521))

    )

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /DBSoft/oracle/product/11.2.4/dbhome_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = woo)

      (ORACLE_HOME = /DBSoft/oracle/product/11.2.4/dbhome_1)

      (SID_NAME = woo)

    )

  )

ADR_BASE_LISTENER = /DBSoft/oracle

--启动监听

[oracle@db02 dbs]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-JUN-2015 21:29:57

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting /DBSoft/oracle/product/11.2.4/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production

System parameter file is /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora

Log messages written to /DBSoft/oracle/diag/tnslsnr/db02/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db02)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date 17-JUN-2015 21:29:57

Uptime 0 days 0 hr. 0 min. 1 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora

Listener Log File /DBSoft/oracle/diag/tnslsnr/db02/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db02)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "woo" has 1 instance(s).

  Instance "woo", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

--查看监听状态

[oracle@db02 dbs]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-JUN-2015 21:30:02

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date 17-JUN-2015 21:29:57

Uptime 0 days 0 hr. 0 min. 4 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora

Listener Log File /DBSoft/oracle/diag/tnslsnr/db02/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db02)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "woo" has 1 instance(s).

  Instance "woo", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@db02 dbs]$

--修改参数文件

[oracle@db02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 17 21:35:54 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1188511744 bytes

Fixed Size 1364228 bytes

Variable Size 754978556 bytes

Database Buffers 419430400 bytes

Redo Buffers 12738560 bytes

SQL> create spfile from pfile='/DBSoft/oracle/product/11.2.4/dbhome_1/dbs/initwoo.ora';

File created.

SQL>

SQL> shutdown abort;

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1188511744 bytes

Fixed Size 1364228 bytes

Variable Size 754978556 bytes

Database Buffers 419430400 bytes

Redo Buffers 12738560 bytes

SQL>

alter system set db_unique_name=sty scope=spfile;

alter system set log_archive_config='DG_CONFIG=(pri,dg)' scope=spfile;

alter system set log_archive_dest_1 ='LOCATION=/DBBackup/Archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=sty' scope=spfile;

alter system set log_archive_dest_2 ='SERVICE=pri LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=pri' scope=spfile;

alter system set fal_server=pri scope=spfile;

alter system set fal_client=sty scope=spfile;

SQL> shutdown abort;

ORACLE instance shut down.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1188511744 bytes

Fixed Size 1364228 bytes

Variable Size 754978556 bytes

Database Buffers 419430400 bytes

Redo Buffers 12738560 bytes

SQL>

SQL>

 5、在primary端通过Rman Duplicate创建备库,在db01上执行如下命令

rman target sys/oracle@pri auxiliary sys/oracle@sty nocatalog
 duplicate target database for standby from active database nofilenamecheck;

 [oracle@db01 ~]$ rman target sys/oracle@pri auxiliary sys/oracle@sty nocatalog

 Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jun 17 22:33:54 2015

 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

 connected to target database: WOO (DBID=4221729487)
 using target database control file instead of recovery catalog
 connected to auxiliary database: WOO (not mounted)

 RMAN>

 RMAN> duplicate target database for standby from active database nofilenamecheck;

 Starting Duplicate Db at 17-JUN-15
 allocated channel: ORA_AUX_DISK_1
 channel ORA_AUX_DISK_1: SID=19 device type=DISK

 contents of Memory Script:
 {
    backup as copy reuse
    targetfile  '/DBSoft/oracle/product/11.2.4/dbhome_1/dbs/orapwwoo' auxiliary format
  '/DBSoft/oracle/product/11.2.4/dbhome_1/dbs/orapwwoo'  ;
 }
 executing Memory Script

 Starting backup at 17-JUN-15
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID=44 device type=DISK
 Finished backup at 17-JUN-15

 contents of Memory Script:
 {
    backup as copy current controlfile for standby auxiliary format  '/DBSoft/oracle/oradata/woo/control01.ctl';
    restore clone controlfile to  '/DBSoft/oracle/fast_recovery_area/woo/control02.ctl' from
  '/DBSoft/oracle/oradata/woo/control01.ctl';
 }
 executing Memory Script

 Starting backup at 17-JUN-15
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting datafile copy
 copying standby control file
 output file name=/DBSoft/oracle/product/11.2.4/dbhome_1/dbs/snapcf_woo.f tag=TAG20150617T223502 RECID=1 STAMP=882657308
 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
 Finished backup at 17-JUN-15

 Starting restore at 17-JUN-15
 using channel ORA_AUX_DISK_1

 channel ORA_AUX_DISK_1: copied control file copy
 Finished restore at 17-JUN-15

 contents of Memory Script:
 {
    sql clone 'alter database mount standby database';
 }
 executing Memory Script

 sql statement: alter database mount standby database

 contents of Memory Script:
 {
    set newname for tempfile  1 to
  "/DBSoft/oracle/oradata/woo/temp01.dbf";
    switch clone tempfile all;
    set newname for datafile  1 to
  "/DBSoft/oracle/oradata/woo/system01.dbf";
    set newname for datafile  2 to
  "/DBSoft/oracle/oradata/woo/sysaux01.dbf";
    set newname for datafile  3 to
  "/DBSoft/oracle/oradata/woo/undotbs01.dbf";
    set newname for datafile  4 to
  "/DBSoft/oracle/oradata/woo/users01.dbf";
    backup as copy reuse
    datafile  1 auxiliary format
  "/DBSoft/oracle/oradata/woo/system01.dbf"  datafile
  2 auxiliary format
  "/DBSoft/oracle/oradata/woo/sysaux01.dbf"  datafile
  3 auxiliary format
  "/DBSoft/oracle/oradata/woo/undotbs01.dbf"  datafile
  4 auxiliary format
  "/DBSoft/oracle/oradata/woo/users01.dbf"  ;
    sql 'alter system archive log current';
 }
 executing Memory Script

 executing command: SET NEWNAME

 renamed tempfile 1 to /DBSoft/oracle/oradata/woo/temp01.dbf in control file

 executing command: SET NEWNAME

 executing command: SET NEWNAME

 executing command: SET NEWNAME

 executing command: SET NEWNAME

 Starting backup at 17-JUN-15
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting datafile copy
 input datafile file number=00001 name=/DBSoft/oracle/oradata/woo/system01.dbf
 output file name=/DBSoft/oracle/oradata/woo/system01.dbf tag=TAG20150617T223532
 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:58
 channel ORA_DISK_1: starting datafile copy
 input datafile file number=00002 name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
 output file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf tag=TAG20150617T223532
 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:30
 channel ORA_DISK_1: starting datafile copy
 input datafile file number=00003 name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
 output file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf tag=TAG20150617T223532
 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
 channel ORA_DISK_1: starting datafile copy
 input datafile file number=00004 name=/DBSoft/oracle/oradata/woo/users01.dbf
 output file name=/DBSoft/oracle/oradata/woo/users01.dbf tag=TAG20150617T223532
 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
 Finished backup at 17-JUN-15

 sql statement: alter system archive log current

 contents of Memory Script:
 {
    switch clone datafile all;
 }
 executing Memory Script

 datafile 1 switched to datafile copy
 input datafile copy RECID=1 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/system01.dbf
 datafile 2 switched to datafile copy
 input datafile copy RECID=2 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
 datafile 3 switched to datafile copy
 input datafile copy RECID=3 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
 datafile 4 switched to datafile copy
 input datafile copy RECID=4 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/users01.dbf
 Finished Duplicate Db at 17-JUN-15

#至此已经恢复完成

6、在primary 和standby端添加standby日志

SQL> alter database add standby logfile
 
group 4 ('/DBSoft/oracle/oradata/woo/styredo04.log') size 50m,

group 5 ('/DBSoft/oracle/oradata/woo/styredo05.log') size 50m,

group 6 ('/DBSoft/oracle/oradata/woo/styredo06.log') size 50m,

group 7 ('/DBSoft/oracle/oradata/woo/styredo07.log') size 50m;

SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;

    GROUP# THREAD# SEQUENCE# ARC STATUS

---------- ---------- ---------- --- ----------

        4 0 0 YES UNASSIGNED

        5 0 0 YES UNASSIGNED

        6 0 0 YES UNASSIGNED

        7 0 0 YES UNASSIGNED

7、在standby端开启实时日志应用

SQL> recover managed standby database using current logfile disconnect from session;
 
Media recovery complete.

SQL>

oracle oracle数据库

HackAge

HackAge

0 关注 0 粉丝 0 动态

关注 关注

相关推荐

关于使用PLSQL Developer时出现报错ora-12514的问题

　　在登陆PLSQL Developer时报ora-12513错误，需要修改本地数据库的监听配置文件，其过程相对简单。　　在Oracle安装目录中搜索找到listener.ora文件，并修改成txt格式后打开，需要添加的代码及添加位置如下图所示：。　　确认

lklong 2020-11-22

oracle锁表该如何解决

where l.object_id　=　o.object_id and l.session_id=s.sid;如果杀不掉可以加个 immediate 立即杀掉 试试；如果利用上面的命令杀死一个进程后，进程状态被置为"killed"，但是

oraclemch 2020-11-06

Oracle表字段有Oracle关键字出现异常解决方案

现在进行项目改造，数据库需要迁移，由原来的使用GBase数据库改为使用Oracle数据库，今天测试人员在测试时后台报了一个异常。把SQL语句单独复制出来进行查询，还是报错，仔细分析原因才知道是表中的字段使用了Oracle中的关键字size。一般来说建表的时

shilukun 2020-10-10

甲骨文推出Oracle Exadata云服务X8M

甲骨文推出Oracle Exadata云服务X8M，已可在Oracle云基础设施 上使用。企业可以通过26个全球云区域和Oracle专有云本地化解决方案，使用Oracle Exadata云服务X8M，加速运行具挑战性的事务处理和数据分析项目。无论是在云端还

周嘉笙 2020-11-09

oracle备份之备份测试脚本的方法（冷备、热备、rman)

2、没有备份参数文件，参数文件可以另外备份，没有必要每次都备份，只需要在改变设置后备份一次。

warden00 2020-08-31

限制ip访问Oracle数据库的方法步骤

本次实验环境是Centos6.10 + Oracle 11.2.0.4单实例，数据库服务器ip地址为192.168.31.71. 这里需要注意的是必须把本机ip地址加进来，否则监听启动会报错。tcp.invited_nodes的意思是开通白名单，不在白名单

zhuzhufxz 2020-09-16

Oracle和MySQL的数据导入为何差别这么大

经常会有一些朋友咨询我一些数据库的问题，我注意到一个很有意思的现象，凡是数据导入的问题，基本上都是Oracle类的，MySQL类的问题脑子里想了下竟然一次都没有。我们来梳理一下这个问题，分别从导出导入的方式来聊聊。导出有哪些工具呢，主要有exp，expdp

bfcady 2020-08-16

Oracle数据库的实例/表空间/用户/表之间关系简单讲解

完整的Oracle数据库通常由两部分组成：Oracle数据库和数据库实例。1) 数据库是一系列物理文件的集合；2) Oracle数据库实例则是一组Oracle后台进程/线程以及在服务器分配的共享内存区。Oracle有一个很大的内存快，成为全局区。Oracl

Hody 2020-08-16

浅谈入门级oracle数据库数据导入导出步骤

Oracle数据库是通过表空间来存储物理表的，一个数据库实例可以有N个表空间，一个表空间下可以有N张表。表空间是数据库的逻辑划分，每个数据库至少有一个表空间。

FightFourEggs 2020-08-16

oracle数据库的删除方法详解

使用DBCA进行删除的数据库必须处于OPEN状态，否则不能删除。到此这篇关于oracle数据库的删除方法详解的文章就介绍到这了,更多相关oracle数据库的删除方法内容请搜索安科网以前的文章或继续浏览下面的相关文章希望大家以后多多支持安科网！

数据库设计 2020-08-16

Oracle通过LogMiner实现数据同步迁移

最近在研究如何实现Oracle数据库之间的数据同步，网上的资料确实比较少。最好用的Oracle数据库同步工具是：GoldenGate ，而GoldenGate是要收费的。那么还有什么好的办法来同步Oracle的数据吗？没错，就是使用LogMiner来实现O

yanghuatong 2020-08-16

ORACLE数据库中Rownum用法详解

ORACLE 中ROWNUM用法总结!对于 Oracle 的 rownum 问题，很多资料都说不支持>,>=,=,between...and，只能用以上符号(<、<=、!=)，并非说用>,& gt;=,=,betwee

dbasunny 2020-08-16

oracle数据库关于索引建立及使用的详细介绍

索引是与表相关的一个可选结构，在逻辑上和物理上都独立于表的数据，索引能优化查询，不能优化DML操作，Oracle自动维护索引，频繁的DML操作反而会引起大量的索引维护。如果该语句同时还要访问除索引列之外的列，那么，数据库会使用rowid来查找表中的行。通常

罗罗 2020-08-16

Oracle 11g 数据库的部署的图文教程

Oracle Database，又名Oracle RDBMS，或简称Oracle。是甲骨文公司的一款关系数据库管理系统。它是在数据库领域一直处于领先地位的产品。可以说Oracle数据库系统是目前世界上流行的关系数据库管理系统，系统可移植性好、使用方便、功能

ihuaqiang 2020-08-16

静默安装卸载 ORACLE

dbca -silent -deleteDatabase -sourceDB adbtest -sysDBAUserName sys -sysDBAPassword leo

choice0 2020-07-30

oracle数据库跟踪工具

有没有一个能跟踪oracle数据库中执行SQL代码的跟踪工具？通过Oracle企业管理器建立跟踪从Top Consumers页面开始。该页面显示服务、模块、客户和动作对系统资源的当前使用情况。您可以单击Top Services、Top Modules、To

娜娜 2020-07-28

踩坑了！踩坑了！NHibernate使用批量插入Oracle数据，Batch属性

今天看NHibernate文档，发现了NHibernate提供批量操作数据的支持，目前仅支持sql server和Oracle，果断要试试啊。结果发现，竟然批量插入Oracle数据无效。--启动批量操作，可有效减少nh与数据库的连接。设置为0时，默认不启动

solarspot 2020-07-28

oracle 11g修改归档日志目录及大小

NAME TYPE VALUE. ------------------------------------ ----------- -----------------------

踩风火轮的乌龟 2020-07-26

Logstash Oracle同步设置

# 是否清除sql_last_value的记录，需要增量同步时此字段必须为false；# 同步频率，默认每分钟同步一次；where updated_at>:sql_last_value and updated_at<sysdate order

娜娜 2020-07-20

服务器断电导致的ORACLE异常 : ORA-00214 ORA-01033 ORA-01034 ORA-00172 ORA-27101

工作环境中的集群迁移之后，oracle出了挺多问题，最开始一直没找到原因，后来发现做迁移的人是冷迁移的，且数据库节点是硬关机的，惊了（。ORACLE 例程已经启动。数据库装载完毕。ORA-01151：如需要，请使用介质恢复以…SQL> recover

xwb 2020-07-19

关于ORACLE索引的几种扫描方式

一条sql执行的效率因执行计划的差异而影响，经常说这条sql走索引了，那条sql 全表扫了。索引是怎么走的呢，说说我了解到的几种索引走的方式。具体来说，仅当查询谓词使用等号运算符引用唯一索引键中的所有列时，数据库才执行唯一扫描.数据库从索引条目中获取行标识

娜娜 2020-07-18

Oracle期末复习

数据库是存储数据的多个物理文件的集合，如控制文件，数据文件，参数文件，日志文件，临时文件等 ，它是静态的、永久的，只要文件存在它就存在。数据库名就是对数据库的标识。就是由内存空间和工作进程两部分组成。容器数据库是Oracle 12c引入的新特性，允许容器数

流云追风 2020-07-04

Oracle 导入数据库dmp文件

场景：windows2008 R2系统 ，往新安装的oracle11g数据库导入同事给的dmp文件到指定的新建的用户。在导入dmp文件之前，先打开查看dmp文件的表空间名称。使用数据库dba用户创建用户并赋予相应的导入导出等权限。个人试过几次，最后选择命令

dataminer 2020-06-25

oracle 授予权限和收回权限 grant和revoke 以及角色的创建 删除

ALLON数据对象名,SELECTON数据对象名,UPDATEON数据对象名,DELETEON数据对象名,INSERTON数据对象名,--用户授权GRANTCONNECT,RESOURCETO用户名;GRANTSELECTON表名TO用户名;GRANTSE

娜娜 2020-06-22

oracle执行计划打印

下班逗猫闲得无聊，写写自己对几种oracle执行计划打印的认识。废话少说开始吧方式一：explain plan for使用explain plan for，这种查询方式适合查看单条执行SQL的执行计划。explain plan for的查看方式也有两种：1

zhangchaoming 2020-06-21

Oracle数据库视图创建以及优点分析

select s.xh,s.classid,s.xm,s.sex,s.birthday,c.cname from student s,classstu c where s.classid=c.classid

goodriver 2020-06-17
HackAge

HackAge

W3CSchool教程
HTML 教程
CSS 教程
Bootstrap 教程
Javascript 教程
jQuery 教程
后端教程
C 教程
Java 教程
PHP 教程
Python 教程
Go 教程
移动开发
Android 教程
Swift 教程
Kotlin 教程
jQuery Mobile 教程
ionic 教程
关于我们
新闻动态
联系方式
招聘英才
安科实验室
帮助与反馈

安科网(Ancii)，中国第一极客网

Copyright © 2013 - 2019 Ancii.com

京ICP备18063983号 京公网安备11010802014868号