wlbzy的专栏

今天在安装oraclerac的时候，在图形安装界面下ssh直通一直不同过。查找问题，判断是应为oracle对ssh7.2不支持。ssh版本降下去后，可以正常安装。或者安装完rac后，在升级ssh不受影响。配置ssh直通oracle11g 不支持7.2[root@bmfw-ora1 ~]# more  /tmp/OraInstall2016-04-26_02-45-26PM/ss

502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each grouphas one member.A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In th

402.While querying the EMPLOYEES table, you receive an ORA-01578 message indicating blockcorruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. WhichRMAN c

302.You issue the following command:RMAN>CONFIGURE BACKUP OPTIMIZATION ON;What is the result of this command on your backups?B. Read-only datafiles will not be backed up as long as backups o

202.In which two aspects 方面 does hot patching 热补丁differ from conventional常规的 patching? (Choose two.)A. It consumes more memory compared with conventional patching与常规补丁比较消耗更多的内存D. It does not req

102.Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/p

1. While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements descri

132.You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays. Which two statements are true about the differential incremental backups?

Q1 View the Exhibit and identify the component marked with a question mark.A.Checkpoint (CKPT)Q2.SundayAn incremental level 0 backup backs up all blocks that have ever been in use in this da

1: Examine the following statement that is used to modify the primary key constraint on theSALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements are true

ORACLE 如何建立表外键例：学生表student (id, name , sex )    成绩表score (id ,math )  如何创建表，要求 有主键，有约束 解:  CREATE TABLE STUDENT(ID CHAR(10), NAME VARCHAR(8),SEX CHAR(1));    ALTER TABLE STUDENT ADD CONS

就职于一个系统集成公司，这两年没有少使用oracle。从单机到rac上都部署实施以及维护过，对于oracle的架构也有初步的了解，不过基本上是用到哪一部分部分去学习哪一部分。中间的过程曲折而繁复。从学习安装oracle、导入导出、rman备份、AWR报告分析、RAC搭建、ASM磁盘管理、集群故障排查、一路研究学习。        今年由于公司的需求以及自身想要全面成体系的学习了解ORACLE。

602.On Friday at 11:30 am you decided to flash back the database because of a user error that occurredat 8:30 am.Which option must you use to check whether a flashback operation can recover the da