安科网

Oracle 11gR2使用RMAN duplicate复制数据库——Backup-based

午后红茶

午后红茶

2017-02-11

关注 关注

本实例测试Oracle 11g使用rman复制数据库。11g的RMAN duplicate 可以通过Active database duplicate和Backup-based duplicate两种方法实现。这里的测试使用的是Backup-based duplicate。

1、旧库或网络不可用，但是有备份

实验环境：

target db：

ip 192.168.56.10

oracle_sid=mydb

oracle_version=11.2.0.3

auxiliary db：

ip 192.168.56.150

oracle_sid=oradu

oracle_version=11.2.0.3

1、备份target db

RMAN> backup database include current controlfile plus archivelog delete all input;

 

Starting backup at 20-MAR-16

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=25 RECID=47 STAMP=906998693

input archived log thread=1 sequence=26 RECID=48 STAMP=906999061

channel ORA_DISK_1: starting piece 1 at 20-MAR-16

channel ORA_DISK_1: finished piece 1 at 20-MAR-16

piece handle=/u01/app/oracle/product/11.2.0/db/dbs/34r0vd8l_1_1 tag=TAG20160320T161101 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/u01/app/oracle/product/11.2.0/db/dbs/arch/1_25_906314379.dbf RECID=47 STAMP=906998693

archived log file name=/u01/app/oracle/product/11.2.0/db/dbs/arch/1_26_906314379.dbf RECID=48 STAMP=906999061

Finished backup at 20-MAR-16

Starting backup at 20-MAR-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/mydb/system01.dbf

input datafile file number=00002 name=/u01/app/oracle/oradata/mydb/sysaux01.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/mydb/undotbs01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/mydb/users01.dbf

channel ORA_DISK_1: starting piece 1 at 20-MAR-16

channel ORA_DISK_1: finished piece 1 at 20-MAR-16

piece handle=/u01/app/oracle/product/11.2.0/db/dbs/35r0vd8m_1_1 tag=TAG20160320T161102 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 20-MAR-16

channel ORA_DISK_1: finished piece 1 at 20-MAR-16

piece handle=/u01/app/oracle/product/11.2.0/db/dbs/36r0vdad_1_1 tag=TAG20160320T161102 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 20-MAR-16

Starting backup at 20-MAR-16

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=27 RECID=49 STAMP=906999120

channel ORA_DISK_1: starting piece 1 at 20-MAR-16

channel ORA_DISK_1: finished piece 1 at 20-MAR-16

piece handle=/u01/app/oracle/product/11.2.0/db/dbs/37r0vdag_1_1 tag=TAG20160320T161200 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/u01/app/oracle/product/11.2.0/db/dbs/arch/1_27_906314379.dbf RECID=49 STAMP=906999120

Finished backup at 20-MAR-16

Starting Control File and SPFILE Autobackup at 20-MAR-16

piece handle=/u01/app/oracle/product/11.2.0/db/dbs/c-2820637901-20160320-05 comment=NONE

Finished Control File and SPFILE Autobackup at 20-MAR-16

2、复制参数文件和创建密码文件

--必须保持target DB和auxiliary DB的密码一致。这里我直接把target db的密码文件复制到auxiliary db对应的目录下

--target db上执行

[oracle@localhost ~]$ cd $ORACLE_HOME/dbs

[oracle@localhost dbs]$ scp orapwmydb [email protected]:/home/oracle

[email protected]'s password:

orapwmydb                                    100% 1536    1.5KB/s  00:00   

[oracle@localhost dbs]$ scp initmydb.ora [email protected]:/home/oracle

[email protected]'s password:

initmydb.ora                                  100%  193    0.2KB/s  00:00   

3、把旧机器的备份复制到新机器上的对应目录

[oracle@localhost dbs]$ scp /u01/app/oracle/product/11.2.0/db/dbs/34r0vd8l_1_1 [email protected]:/home/oracle/bak

[email protected]'s password:

34r0vd8l_1_1                                  100% 5457KB  5.3MB/s  00:00   

[oracle@localhost dbs]$ scp /u01/app/oracle/product/11.2.0/db/dbs/35r0vd8m_1_1 [email protected]:/home/oracle/bak

[email protected]'s password:

35r0vd8m_1_1                                  100% 1049MB  15.0MB/s  01:10   

[oracle@localhost dbs]$ scp /u01/app/oracle/product/11.2.0/db/dbs/36r0vdad_1_1 [email protected]:/home/oracle/bak

[email protected]'s password:

36r0vdad_1_1                                  100% 9952KB  9.7MB/s  00:00   

[oracle@localhost dbs]$ scp /u01/app/oracle/product/11.2.0/db/dbs/37r0vdag_1_1 [email protected]:/home/oracle/bak

[email protected]'s password:

37r0vdag_1_1                                  100%  10KB  10.0KB/s  00:00   

4、更改密码文件、参数文件的文件名和参数文件中的对应的实例名(实例名不变时不需要执行),

把目录转换参数加入参数文件中(实例名、目录不变时不需要)

本实验中更新实例名为oradu

[oracle@localhost ~]$ mv initmydb.ora initoradu.ora

[oracle@localhost ~]$ mv orapwmydb orapworadu

vi initoradu.ora把所有的旧实例名mydb改为oradu，并加入转换参数

db_file_name_convert=('/u01/app/oracle/oradata/mydb/','/u01/app/oracle/oradata/oradu/')

log_file_name_convert=('/u01/app/oracle/oradata/mydb/','/u01/app/oracle/oradata/oradu/')

新建目录

mkdir -p /u01/app/oracle/oradata/oradu/

不改变实例名只需要新建目录

mkdir -p /u01/app/oracle/oradata/mydb/

移动参数文件和密码文件到默认目录中/u01/app/oracle/product/11.2.0/db/dbs/

[oracle@localhost ~]$ mv initoradu.ora /u01/app/oracle/product/11.2.0/db/dbs/

[oracle@localhost ~]$ mv orapworadu /u01/app/oracle/product/11.2.0/db/dbs/

5、启动到nomount

[oracle@localhost ~]$ export ORACLE_SID=oradu

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 20 16:31:43 2016

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

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  238034944 bytes

Fixed Size                  2227136 bytes

Variable Size            180356160 bytes

Database Buffers          50331648 bytes

Redo Buffers                5120000 bytes

SQL>

6、使用RMAN开始复制

[oracle@localhost ~]$ rman auxiliary /

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Mar 20 16:33:11 2016

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

connected to auxiliary database: ORADU (not mounted)

RMAN> duplicate database to oradu backup location '/home/oracle/bak';

Starting Duplicate Db at 20-MAR-16

contents of Memory Script:

{

  sql clone "alter system set  db_name =

 ''MYDB'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

  sql clone "alter system set  db_unique_name =

 ''ORADU'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

  shutdown clone immediate;

  startup clone force nomount

  restore clone primary controlfile from  '/home/oracle/bak/36r0vdad_1_1';

  alter clone database mount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''MYDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''ORADU'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    238034944 bytes

Fixed Size                    2227136 bytes

Variable Size                180356160 bytes

Database Buffers              50331648 bytes

Redo Buffers                  5120000 bytes

Starting restore at 20-MAR-16

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=18 device type=DISK

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02

output file name=/u01/app/oracle/oradata/oradu/control01.ctl

output file name=/u01/app/oracle/oradata/oradu/control02.ctl

Finished restore at 20-MAR-16

database mounted

released channel: ORA_AUX_DISK_1

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=18 device type=DISK

contents of Memory Script:

{

  set until scn  2815228;

  set newname for datafile  1 to

 "/u01/app/oracle/oradata/oradu/system01.dbf";

  set newname for datafile  2 to

 "/u01/app/oracle/oradata/oradu/sysaux01.dbf";

  set newname for datafile  3 to

 "/u01/app/oracle/oradata/oradu/undotbs01.dbf";

  set newname for datafile  4 to

 "/u01/app/oracle/oradata/oradu/users01.dbf";

  restore

  clone database

  ;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-MAR-16

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/oradu/system01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/oradu/sysaux01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/oradu/undotbs01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/oradu/users01.dbf

channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/bak/35r0vd8m_1_1

channel ORA_AUX_DISK_1: piece handle=/home/oracle/bak/35r0vd8m_1_1 tag=TAG20160320T161102

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05

Finished restore at 20-MAR-16

contents of Memory Script:

{

  switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=5 STAMP=907000504 file name=/u01/app/oracle/oradata/oradu/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=6 STAMP=907000504 file name=/u01/app/oracle/oradata/oradu/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=7 STAMP=907000504 file name=/u01/app/oracle/oradata/oradu/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=8 STAMP=907000504 file name=/u01/app/oracle/oradata/oradu/users01.dbf

contents of Memory Script:

{

  set until scn  2815228;

  recover

  clone database

    delete archivelog

  ;

}

executing Memory Script

executing command: SET until clause

Starting recover at 20-MAR-16

using channel ORA_AUX_DISK_1

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=27

channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/bak/37r0vdag_1_1

channel ORA_AUX_DISK_1: piece handle=/home/oracle/bak/37r0vdag_1_1 tag=TAG20160320T161200

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/u01/app/oracle/product/11.2.0/db/dbs/arch1_27_906314379.dbf thread=1 sequence=27

channel clone_default: deleting archived log(s)

archived log file name=/u01/app/oracle/product/11.2.0/db/dbs/arch1_27_906314379.dbf RECID=1 STAMP=907000505

media recovery complete, elapsed time: 00:00:01

Finished recover at 20-MAR-16

Oracle instance started

Total System Global Area    238034944 bytes

Fixed Size                    2227136 bytes

Variable Size                180356160 bytes

Database Buffers              50331648 bytes

Redo Buffers                  5120000 bytes

contents of Memory Script:

{

  sql clone "alter system set  db_name =

 ''ORADU'' comment=

 ''Reset to original value by RMAN'' scope=spfile";

  sql clone "alter system reset  db_unique_name scope=spfile";

  shutdown clone immediate;

  startup clone nomount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''ORADU'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area    238034944 bytes

Fixed Size                    2227136 bytes

Variable Size                180356160 bytes

Database Buffers              50331648 bytes

Redo Buffers                  5120000 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORADU" RESETLOGS ARCHIVELOG

  MAXLOGFILES    16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES    8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP  1 ( '/u01/app/oracle/oradata/oradu/redo01.log', '/u01/app/oracle/oradata/oradu/redo01_01.log' ) SIZE 100 M  REUSE,

  GROUP  2 ( '/u01/app/oracle/oradata/oradu/redo02.log', '/u01/app/oracle/oradata/oradu/redo02_01.log' ) SIZE 100 M  REUSE,

  GROUP  3 ( '/u01/app/oracle/oradata/oradu/redo03.log', '/u01/app/oracle/oradata/oradu/redo03_01.log' ) SIZE 100 M  REUSE,

  GROUP  4 ( '/u01/app/oracle/oradata/oradu/redo04.log', '/u01/app/oracle/oradata/oradu/redo04_01.log' ) SIZE 100 M  REUSE

 DATAFILE

  '/u01/app/oracle/oradata/oradu/system01.dbf'

 CHARACTER SET ZHS16GBK

contents of Memory Script:

{

  set newname for tempfile  1 to

 "/u01/app/oracle/oradata/oradu/temp01.dbf";

  switch clone tempfile all;

  catalog clone datafilecopy  "/u01/app/oracle/oradata/oradu/sysaux01.dbf",

 "/u01/app/oracle/oradata/oradu/undotbs01.dbf",

 "/u01/app/oracle/oradata/oradu/users01.dbf";

  switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/oradu/temp01.dbf in control file

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/sysaux01.dbf RECID=1 STAMP=907000517

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/undotbs01.dbf RECID=2 STAMP=907000517

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/users01.dbf RECID=3 STAMP=907000517

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=907000517 file name=/u01/app/oracle/oradata/oradu/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=907000517 file name=/u01/app/oracle/oradata/oradu/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=907000517 file name=/u01/app/oracle/oradata/oradu/users01.dbf

Reenabling controlfile options for auxiliary database

Executing: alter database add supplemental log data

contents of Memory Script:

{

  Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 20-MAR-16

RMAN>

7、验证是否可用

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 20 16:36:52 2016

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

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

ORADU    READ WRITE

oracle oracle数据库

午后红茶

午后红茶

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
午后红茶

午后红茶

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号