-
编辑 删除
IZ0-053 Q672
672.You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11gdatabase. The Prod1, Prod2 and Prod3 Oracle Database 10g databases are registered in the recoverycatalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executesthe follow...
-
编辑 删除
IZ0-053 Q542(DISK_REPAIR_TIME)
542.You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails.You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and youdon't want to have to rebuild the disks from scratch. What do you do?A. Take ...
-
编辑 删除
非系统数据文件被删除恢复(IZ0-053, Q574)
574.A user sends you an email with the following error message: create table idtable(id number) *ERROR at line 1: ORA- 01110: data file 4: ,,/oracle01/oradata/orcl/users01.dbf ORA-27041:01116: error in opening database file 4 ORA-unable to open file Linux Error: 2: No such file or directoryAdditi...
-
编辑 删除
IZ0-053 Q561
561.If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,what will be the result when you issue the command alter database archivelog?A. The alter database archivelog command will fail.B. The alter database archivelog inconsistent command must be used to ...
-
编辑 删除
IZ0-053 Q455
455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the attribute is TRUE. B. The job will only be disabled if the value of the AUTO_DR...
-
编辑 删除
SQL Access Advisor 与SQL Tuning Advisor
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1794009000346753857In a nutshell - the tuning advisor o suggests sql profiles o gathering more or stale statistics o indexes that might be VERY useful o query rewrites the access advisor o ...
-
编辑 删除
OCP考试题库-IZ0-052 第10题
Examine the following statement that is used to modify the primary key constraint on the SALEStable:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements are true regarding the above command? (Choose three.)A.The constraint remains valid.B.The index on the c...
-
编辑 删除
OCP考试题库-185题
185.A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression? A. backup database all B. backup comp...
-
编辑 删除
Oracle SQL Model Clause
参考官方文档，学习了一下Oracle SQL Model语法。官方文档地址：http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/prod/bidw/sqlmodel/sqlmodel_otn.htm现将过程记录在这里：1. 准备过程, 连接到Oracle自带schema SH(sales history)，创建数据源： CREATE VIEW sales_view AS ...
-
编辑 删除
闪回版本查询(Flashback Version Query)
闪回版本查询是一个Oracle提供的一个比较有用的功能。我们可以用它来查看某一段时期内表数据所发生的变化。以下是示例：SQL> create table t2 as select rownum pkid, lpad('1', rownum, 'A') str from dual connect by rownum <= 5;SQL> col str format a10SQL> col pkid format 999SQL> select * from t2;...
-
编辑 删除
ORA-01591: lock held by in-doubt distributed transaction
同事想删除某个表的数据，但是一直报错，跟我说是锁。通过如下SQL查询，没有发现表锁相关会话：SELECT ddl.owner AS 用户, ddl.name AS 对象, ddl.type AS 类型, vs.osuser AS os_user, vs.machine, ...
-
编辑 删除
Linux下误删数据文件从文件句柄恢复数据文件
Linux操作系统中，如果文件从操作系统级别被rm掉，之前打开文件的进程仍然持有相应的文件句柄，所指向的文件仍然可以读写，并且该文件的文件描述符仍然可以从/proc目录读取。但是，此时如果关闭数据库，则此句柄会消失，除了扫描磁盘进行文件恢复外就没有其他办法了。因此在数据库出现问题的时候，如果不确认情况的复杂程...
-
编辑 删除
11GR2 Active Duplicate过程(单实例对单实例)
今天做了一下RMAN Active Duplicate实验。归根结底，弄明白了，其实整个过程还是挺简单的。两台虚拟机IP分别是192.168.13.128, 192.168.13.129, 源端service_name: test01, 目标端service_name:dup011. SOURCE端与TARGET端都要有相同的目录结构， 在目标端创建所需的目录结构 mkdir-p /u01/app/oracl...
-
编辑 删除
操作系统文件转储成BLOB
DECLARE v_src_file BFILE; v_dst_file BLOB; v_lgh_file NUMBER; c_directory VARCHAR2(20) := 'IMGUPLOAD_DIR'; v_index PLS_INTEGER;BEGIN FOR rec IN (SELECT * FROM h2.d_oldcertid_qdby q...
-
编辑 删除
处理一起ORA-00838过程
。。。
-
编辑 删除
Windows逻辑备份-EXPDP(保留5天内逻辑备份)批处理脚本
echo oracle database backup begins......set dt=%DATE%set FILE_NAME="%dt:~0,4%%dt:~5,2%%dt:~8,2%.dmp"echo %FILE_NAME%D:cd D:\backuprem ren H2USER.EXPDP.dmp H2USER.EXPDP.dmp.bak expdp system/sys@BYERP dumpfile=%FILE_NAME%.dmp directory=bybackup_dir compression=all schemas=H2 log=%FILE_NAME...
-
编辑 删除
一次Linux虚拟机安装Oracle 11G数据库经历
10.20下午，接到任务，说是要在客户的Linux系统上安装Oracle 11G数据库搭建一个测试环境。赶紧联系客户现场，远程过去。cat /etc/issue发现是Oracle Enterprise Linux 6.0。接着，想通过yum安装Oracle的依赖包。cd /etc/y/etc/yum.repos.dwget http://public-yum.oracle.com/public-yum-ol6.repo发现虚拟机无法...
-
编辑 删除
GoldenGate COLMAP字符串处理
项目中，因客户的要求，需要对数据进行截取的处理。以下是配置：<br /><br />map h2.t_vencus_base, target h2.t_vencus_base, COLMAP (usedefaults, vencusname = @STREXT(vencusname, 1, @STRFIND(vencusname, "\") - 1));<br /><br /><br />这里是把t_vencus_base的vencusname字段，以“\”为标志， 截取“\...
-
编辑 删除
记录一次ORA-00600：13013错误的处理
ddd
-
编辑 删除
ORA-00600: arguments: kkqcscpopn_Int:0
同事测试的时候，执行一个SELECT语句的时候出错了， 如图所示：感觉上像是个Oracle的bug。数据库版本：Oracle Database 11g Enterpris...
