按类别查询搜索结果
关于关键词 的检测结果,共 640
unix_5359 | 2018-07-24 11:43:05 | 阅读(810) | 评论(0)
18、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install.Your plan is to install both Oracle database and Grid Infrastructure.Which two are true in this scenario?A) Grid Infrastructure must be installed first.B) Both products ...【阅读全文】
unix_5359 | 2018-07-23 12:05:03 | 阅读(810) | 评论(0)
17、Which two statements are true about tablespaces?A) A database can contain multiple undo tablespaces.B) A database can contain only a single temporary tablespace.C) A database instance stores undo data In the SYSTEM tablespace If no undo tablespace exists.D) A database instance...【阅读全文】
unix_5359 | 2018-07-23 11:57:00 | 阅读(990) | 评论(0)
16、Your database Is configured In archivelog mode.The USERS01 tablespace Is currently online.You are required to take the tablespace offline.Which clause or clauses ensure that no media recovery is requiredwhen the tablespace Is brought back online?A) either the NORMAL or the ...【阅读全文】
unix_5359 | 2018-07-17 11:58:57 | 阅读(820) | 评论(0)
14、Which command is used to display files that no longer conform to the backup retention policy?A) REPORT OBSOLETEB) SHOW DATAFILE BACKUP COPIESC) CROSSCHECK BACKUPD) LIST EXPIRED BACKUPAnswer:A【阅读全文】
unix_5359 | 2018-07-12 10:13:47 | 阅读(870) | 评论(0)
10、Which two are true about consistent database backups?A) They can only be taken when a RECOVERY CATALOG is used.B) They can only be taken if the database Is in ARCHIVELOG mode.C) They can only be taken If shutdown NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and ...【阅读全文】
unix_5359 | 2018-07-10 14:17:56 | 阅读(600) | 评论(0)
6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).You select the "Install and Configure Grid Infrastructure for a Standalone Server" option.Which task is performed by OUI as part of this installation?A) creation and configuration of Enterp...【阅读全文】
hxl | 2018-05-11 08:59:57 | 阅读(0) | 评论(0)
因安全审计需要,在REPLICAT 中设置USERID and PASSWORD 的时候避免采用明文造成安全隐患,可以采用加密后的密码。具体方法如下:ggsci (localhost) 1> encrypt password mypasswd, ENCRYPTCKEY defaultUsing default key ...Encrypted password:  AACAAAAAAAAADAJHGCEFDEUGHDPIKDAlgorithm used:  BLOWF...【阅读全文】
【Oracle】 RAC 增 SCAN
zhangzhengxing | 2018-01-16 21:32:10 | 阅读(830) | 评论(0)
刚开始ip有点紧张,我就只设置了一个SCAN,怕轮询不了,必须在加SCAN IP这样来增加: [root@esm1 ~]# /u01/grid/11g/bin/srvctl config scan SCAN name: racscan, Network: 1/192.168.116.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: /racscan/192.168.116.254我们看看scan监听的情况 [root@esm1 ~]# /u01/gr...【阅读全文】
Roobbin | 2018-01-02 18:33:12 | 阅读(3310) | 评论(0)
exp 用户/密码@orcl tables= file=e:\1111.dmp owner=所属用户 query=\" where条件语句\";【阅读全文】
蓦然princes | 2017-08-28 14:51:50 | 阅读(0) | 评论(0)
http://www.cnblogs.com/kerrycode/p/3842215.html【阅读全文】
hlroracle | 2017-08-15 09:44:00 | 阅读(1050) | 评论(0)
使用asm磁盘的时候控制文件损坏或者丢失的恢复方法【阅读全文】
heyuxuanlove | 2017-05-18 22:21:01 | 阅读(2080) | 评论(0)
--摘抄于Metalink如何在 RAC 集群或单机 ASM 环境中对已经存在的 Diskgroup 添加新磁盘(最佳实践) 适用于: Oracle Database - Enterprise Edition - 版本 10.1.0.2 到 12.1.0.1 [发行版 10.1 到 12.1]本文档所含信息适用于所有平台目标在您将磁盘加入到已有的生产磁盘组之前,您可以使...【阅读全文】
kdxcne | 2017-04-11 18:43:26 | 阅读(1510) | 评论(0)
http://blog.csdn.net/xiaoyankevin/article/details/54177668模拟操作系统内存从2G增加为8G后,调整数据库内存参数,示例中参数不作为实际生产环境参考,因为因需所取,调整参数需要根据数据库相应调整,避免小牛拉大车,大牛拉小车的现象。查看原始配置数据[root@rac1 ~]# echo "kernel.shmmax ...【阅读全文】
mancs | 2017-03-24 09:18:37 | 阅读(390) | 评论(0)
以下都是在oracle服务器中进行操作vi listener.ora增加listener_1522 =  (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.30)(PORT = 1522))    )...【阅读全文】
不一样的天空w | 2017-03-15 01:54:53 | 阅读(1810) | 评论(0)
之前有同学想要给11gR2的RAC添加LISTENER监听器,查看了listener.ora并发现问题: [oracle@vrh2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-DEC-2011 02:51:40Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PO...【阅读全文】
zhouyf605 | 2017-02-21 14:43:43 | 阅读(2470) | 评论(0)
视图v$segstat  如果有跟段相关等等待,可以进一步查询具体是什么原因导致,比如contentionTS   热块   ITL事务槽contention  段扫描等 Name                 Null?    Type&n...【阅读全文】
不一样的天空w | 2017-01-24 10:50:02 | 阅读(2020) | 评论(0)
liyf0371 | 2017-01-13 11:14:20 | 阅读(1400) | 评论(0)
1、删除失败节点的相关信息--在存活节点上删除失败节点注册[root@dbrac2 bin]# ./srvctl remove nodeapps -n dbrac1[root@dbrac2 bin]# ./crs_unregister ora.dbrac.dbrac1.inst[root@dbrac2 bin]# ./crs_unregister ora.dbrac1.ASM1.asm[root@dbrac2 bin]# ./crs_unregister ora.dbrac1.LISTENER_DBRAC1.lsnr[r...【阅读全文】
lhrbest | 2016-12-27 22:56:48 | 阅读(1300) | 评论(0)
clairelili | 2016-12-02 16:30:47 | 阅读(390) | 评论(0)