- 博客(974)
- 资源 (40)
- 收藏
- 关注
RSS订阅
原创 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
6159
原创 [实验-视频过程]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
1621
原创 [实验-视频过程]常用的oracle数据字典
数据字典数据字典是 oracle 的核心 分为两大类 存在于 system 表空间 ⋯$结尾的基本表 Dba_..,all_⋯.,user_⋯视图存在于内存中 X$⋯..的虚表 V$⋯的动态性能视图数据字典是我们建立数据库的时候运行脚本建立的. %oracle_home%\rdbms\admin\catalog.sql;脚本当中含有建立数据字典的语句.而 v$
2015-10-20 11:04:20
1562
原创 [实验-视频过程]启动关闭数据库的过程
启动数据库的三个台阶 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
1527
原创 ［实验-视频过程］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
2257
原创 ［实验-视频过程］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
1744
原创 [实验－视频过程]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
3199
原创 [实验-视频过程]简单有用的备份-oracle 物理冷备份操作
［实验-视屏过程］oracle 物理冷备份操作，主要是要对数据库使用到的重要文件作针对性的备份，数据文件，控制文件，联机日志文件，归档日志文件，参数文件，口令文件等 冷备份需要脱机备份，就是要先关闭数据库，比较适合可以停机的业务场景，如超市门店服务器，晚上12点到早上5点不营业可以关闭数据库，那么可以在这个时间段来做数据库冷备份。主要是以下三个步骤1 正常关闭数据库 2 备份所有重要的文件到备
2015-10-19 08:40:41
1678
原创 【实验-视频过程】数据库归档日志满了以后
归档日志满了以后、一、清理文件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
1699
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
2581
原创 【实验-视频过程】闪回数据库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
1193
原创 oracle 安装过程中检查步骤出现的错误和解决方法
Checking operating system requirements ...Expected result: One of redhat-3,redhat-4,SuSE-9,asianux-1,asianux-2Actual Result: redhat-4Check complete. The overall result of this check is: Passed========
2008-09-17 16:24:00
25379
原创 Oracle数据库满了修改的过程20171123
查看表空间的使用情况SELECT Upper(F.TABLESPACE_NAME) "表空间名", D.TOT_GROOTTE_MB "表空间大小(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)", To_char(Round(( D.TOT_GROOT
2017-11-24 14:37:03
968
原创 Oracle 简单清理归档日志文件
查看归档SQL> archive log list;数据库日志模式 存档模式自动存档 启用存档终点 USE_DB_RECOVERY_FILE_DEST最早的联机日志序列 2536下一个存档日志序列 2538当前日志序列 2538先查看一下存储的位置 SQL> show paramet
2016-07-19 16:32:30
11903
原创 Exp Imp 导入导出常见问题解决方法-字符集的后续问题
Oracle 命令行imp时报值太大(ORA-12899) 不停的循环，提示字段值太大查看日志经由常规路径由 EXPORT:V11.02.00 创建的导出文件 已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入 导入服务器使用 AL32UTF8 字符集 (可能的字符集转换)解决办法是：修改字符集解决办法：SQL>select * from V$NLS_P
2016-06-12 21:21:44
22696
原创 Exp Imp 导入导出常见问题解决方法
1、IMP导入时出现表空间不存在表空间 'EAI1011' 不存在表空间 'YGZJ_DATA' 不存在表空间 'WEBMDATA' 不存在因为已经是导入错误了 所以要重新删除后再导入解决方法 建立表空间 ，删除已经导入的表，重新导入操作drop user JXPCYW CASCADE;DROP USER EAI CASCADE; DROP USER JXPCJIEKOU CASCADE;
2016-06-05 21:49:34
5881
原创 ORA-12518: 错误 客户端连接不上
ORA-12518: 错误 客户端连接不上解决方案： 第一步：process和session改大检查process和session a)本机使用连接到oracle，查看process进程数：select count(*) from v$process; –取得数据库目前的进程数。select value from v$parameter where name = ‘processes’;
2016-05-09 13:07:45
25850
原创 使用IMP导出数据备份并简单FTP实现异地存储
使用IMP导出数据备份并简单FTP实现异地存储 简介情况： 一共3个服务器 21 14 130 21 生产服务器 14 测试服务器（备份1） 130 备份服务器（备份2）21上做简单导出数据库备份———–autobackup.bat————-每天00:00运行 备份del d:\ncdatabackup\dmp\jxpc_*.dmpdel d:\ncdataback
2015-12-12 22:04:40
2380
翻译 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
1487
翻译 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
1441
翻译 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
1358
翻译 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
1358
翻译 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
1391
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
1193
翻译 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
1408
翻译 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
1231
翻译 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
1200
翻译 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
1251
翻译 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
1776
翻译 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
1321
翻译 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
1099
翻译 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
1107
翻译 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
1240
翻译 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
1006
翻译 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
1044
翻译 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
1034
翻译 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
1173
翻译 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
997
翻译 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
933
翻译 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
960
华为云架构师H13_821考试资料独一份带备注的
2020-11-03
oa-ecology帮助文件
2013-05-04
网页特效代码集锦很多很炫效果
2010-07-23
.NET数据库通用接口SQLSERVER和ORACLE
2009-12-19
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人