- 博客(514)
- 资源 (40)
- 收藏
- 关注
原创 oracle表空间过大时候的处理
先查看所有表空间的数据使用情况SELECT Upper(F.TABLESPACE_NAME) "表空间名", D.TOT_GROOTTE_MB "表空间大小(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)", To_char(Round(( D.TOT_GROOT
2015-10-27 16:11:58 5866 3
原创 [实验-视频过程]oracle控制文件增加减少
控制文件控制文件是二进制文件 控制文件记录了数据库的结构和行为在 mount 时候读在数据库 open 时一直使用丢失需要恢复相关字典select name from v$controlfile;select TYPE,RECORD_SIZE,RECORDS_TOTAL,RECORDS_USED from V$CONTROLFILE_RECORD_SECTION;select value from
2015-10-20 15:29:22 1549
原创 [实验-视频过程]常用的oracle数据字典
数据字典数据字典是 oracle 的核心 分为两大类 存在于 system 表空间 ⋯$结尾的基本表 Dba_..,all_⋯.,user_⋯视图存在于内存中 X$⋯..的虚表 V$⋯的动态性能视图数据字典是我们建立数据库的时候运行脚本建立的. %oracle_home%\rdbms\admin\catalog.sql;脚本当中含有建立数据字典的语句.而 v$
2015-10-20 11:04:20 1504
原创 [实验-视频过程]启动关闭数据库的过程
启动数据库的三个台阶 nomount,mount,opensqlplus sys/oracle as sysdbaShutdown abort;Startup nomount;select instance_name,status from v$instance;启动数据库到第一个台阶 nomount 状态做了如下的工作. 1.读参数文件 2.分配内存 3.启动后台进程
2015-10-19 22:50:01 1489
原创 [实验-视频过程]RMAN备份和恢复
RMAN备份和恢复1、进入rman [oracle@el48 orcl]$ rman target /2、查看原来的备份 RMAN> list backup;using target database control file instead of recovery catalogList of Backup Sets===================BS Key Type LV Size
2015-10-19 18:40:29 2216
原创 [实验-视频过程]oracle热备份-单个表空间-备份和恢复操作演示
[实验-视频过程]oracle热备份-单个表空间-备份和恢复操作演示 针对一个表空间的恢复1、创建表空间drop tablespace test_backup including contents and datafiles;CREATE TABLESPACE test_backup DATAFILE '/u01/app/oracle/oradata/orcl/test_back.dbf' SI
2015-10-19 11:25:02 1684
原创 [实验-视频过程]oracle热备份-整个数据库-备份和恢复操作演示
[实验-视频过程]oracle热备份-整个数据库-备份和恢复操作演示先查看数据版本和数据文件所在位置10g以上版本支持整体表空间热备份select * from v$version;select name from v$datafiles;确认是否为归档模式archive log list; 查看如果不是改成归档模式shutdown immediate;startup mount;alter dat
2015-10-19 10:53:36 3105
原创 [实验-视频过程]简单有用的备份-oracle 物理冷备份操作
[实验-视屏过程]oracle 物理冷备份操作,主要是要对数据库使用到的重要文件作针对性的备份,数据文件,控制文件,联机日志文件,归档日志文件,参数文件,口令文件等 冷备份需要脱机备份,就是要先关闭数据库,比较适合可以停机的业务场景,如超市门店服务器,晚上12点到早上5点不营业可以关闭数据库,那么可以在这个时间段来做数据库冷备份。主要是以下三个步骤1 正常关闭数据库 2 备份所有重要的文件到备
2015-10-19 08:40:41 1634 1
原创 【实验-视频过程】数据库归档日志满了以后
归档日志满了以后、一、清理文件C:\Users\Administrator>19:24:36.78>sqlplus scott/tigerSQL*Plus: Release 11.2.0.1.0 Production on 星期五 10月 9 19:24:40 2015Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR: ORA
2015-10-14 14:25:29 1643 1
原创 【实验-视频过程】ORACLE EXPDP IMPDP导入导出同EXP IMP命令详细对比
ORACLE EXPDP IMPDP数据导入导出命令详解及同EXP IMP 命令详细对比一、EXPDP IMPDP EXP IMP 可以实现 1.可以实现逻辑备份和逻辑恢复 2.可以在数据库用户之间移动对象 3.可以在数据库之间移动对象 4.可以实现表空间转移二、EXPDP的命令详解C:\Users\Administrator>
2015-10-10 09:42:15 2492
原创 【实验-视频过程】闪回数据库Flashback database
一、打开闪回数据库1、确保数据库处于归档模式,如果为非归档模式,将数据库转换成归档模式SQL> select name,log_mode from v$database;NAME LOG_MODE--------- ------------ORCL NOARCHIVELOGSQL> select flashback_on from v$database;FLASHBAC
2015-10-08 21:06:11 1144
翻译 ocp-530
QUESTION NO: 530 Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.) 关 A. A single ADR can support multiple ADR homes for differen
2015-10-20 11:04:03 1434
翻译 ocp-529
QUESTION NO: 529? You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified freq
2015-10-20 11:03:47 1393
翻译 ocp-528
QUESTION NO: 528 You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recove
2015-10-20 11:03:34 1305
翻译 ocp-527
QUESTION NO: 527 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1
2015-10-20 11:03:21 1316
翻译 ocp-526
QUESTION NO: 526 You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive? A. Drop the table. B. Partition the
2015-10-20 11:03:09 1324 1
翻译 ocp-525
QUESTION NO: 525 Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.) A. ADR diagnostic fil
2015-10-20 11:02:52 1146
翻译 ocp-524
QUESTION NO: 524 Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure? A. only encryption and compression settings for all SecureFile LOBs B. only encryption and deduplication s
2015-10-20 11:02:41 1362
翻译 ocp-523
QUESTION NO: 523 An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The
2015-10-20 11:02:30 1184
翻译 ocp-522
QUESTION NO: 522 You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplicati
2015-10-20 11:02:06 1168
翻译 ocp-521
QUESTION NO: 521 View the Exhibit and examine the resource consumption details for the current plan in use by the database instance. Which two statements are true based on the output? (Choose two.)
2015-10-20 11:01:54 1212
翻译 ocp-520
QUESTION NO: 520 A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table r
2015-10-19 22:34:06 1728
翻译 ocp-519
QUESTION NO: 519 You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command: SQL> SELECT dbms_addm.get_r
2015-10-19 22:33:52 1277
翻译 ocp-518
QUESTION NO: 518 The INV_HISTORY table is created using the command:SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by range (inv_date) interval (nu
2015-10-19 22:33:34 1065
翻译 ocp-517
QUESTION NO: 517 Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_
2015-10-19 22:33:21 1080
翻译 ocp-516
QUESTION NO: 516 You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the bas
2015-10-19 22:33:07 1191
翻译 ocp-515
QUESTION NO: 515 Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary. B. It does not require database instance shutdown. C. It can detec
2015-10-19 22:32:54 971
翻译 ocp-514
QUESTION NO: 514? View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the Significance Level threshold type not available in the threshold setting?A. because AW
2015-10-19 22:32:39 1014
翻译 ocp-513
QUESTION NO: 513 You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you i
2015-10-19 22:32:07 979
翻译 ocp-512
QUESTION NO: 512? View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric? A. Oracle uses statistical relevance t
2015-10-19 22:31:54 1138
翻译 ocp-511
QUESTION NO: 511 Consider the following scenario for your database: -Backup optimization is enabled in RMAN. -The recovery window is set to 7 days in RMAN. -The most recent backup to disk for the T
2015-10-19 22:31:38 972
翻译 ocp-510
QUESTION NO: 510 Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage? A. It returns space usage of only BasicFile LOB chunks. B. It retur
2015-10-19 08:38:40 891
翻译 ocp-509
QUESTION NO: 509 Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs? A. It cannot be done in parallel. B. It can be done at the table leve
2015-10-19 08:38:26 921
翻译 ocp-508
QUESTION NO: 508 You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN p
2015-10-19 08:38:13 1009
翻译 ocp-507
QUESTION NO: 507 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1
2015-10-19 08:38:01 841
翻译 ocp-506
QUESTION NO: 506 Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT(‘HM_RUN_1061’) Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode : R
2015-10-19 08:37:47 761
翻译 ocp-505
QUESTION NO: 505 Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.) A. a job B. a program C. a schedule D. a PL/SQL procedure Answer:
2015-10-19 08:37:33 750
翻译 ocp-504
QUESTION NO: 504Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following erro
2015-10-19 08:37:19 715
翻译 ocp-503
QUESTION NO: 503 You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this con
2015-10-19 08:37:06 787
翻译 ocp-502
QUESTION NO: 502 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 st
2015-10-19 08:36:53 1029
华为云架构师H13_821考试资料独一份带备注的
2020-11-03
oa-ecology帮助文件
2013-05-04
网页特效代码集锦很多很炫效果
2010-07-23
.NET数据库通用接口SQLSERVER和ORACLE
2009-12-19
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人