本站用于记录日常工作内容,虚拟化云计算,系统运维,数据库DBA,网络与安全。
附件是emcli工具软件Downloading and Deploying EM CLIThis chapter discusses the following Enterprise Manager Command Line Interface (EM CLI) topics:EM CLI InstallationDownloading and Deploying the EM CLI ClientGetting Started with EM CLISecurity and AuthenticationFormat Option Availability for Output Data Verbs2.1 EM CLI InstallationEM CLI provides two installable kits:EM CLI StandardThis kit supports the Standard mode only.EM CLI with Scripting modeThis kit supports all three modes, but only Interactive and Scripting modes enable you to provide Jython-based scripts.EM CLI consists of two components used to access the Enterprise Manager framework functionality:EM CLI clientThe EM CLI client is a command-line program (Sun Java JRE-based) that sends EM CLI verbs to a specific Oracle Management Service (OMS). In some respects, the EM CLI client functions as a command-line equivalent of an Enterprise Manager Cloud Control console. You can download the EM CLI client on any system within your...
oracle查看与删除oem企业管理器Web管理中自动备份任务调度job 1.在oracle oem中可以执行自动备份的job,注意,其不在dba_jobs,dba_scheduler_jobs中2.查看oem中的jobselect a.job_name, b.execution_hours, b.execution_minutes  from sysman.mgmt_job a, sysman.mgmt_job_schedule bwhere a.schedule_id = b.schedule_id   and a.job_type = 'Backup';3.删除oem中的job,注意必需先DELETE_ALL_EXECUTIONS,而后STOP_ALL_EXECUTIONS,最后DELETE_JOBDECLAREBEGIN  MGMT_JOBS.DELETE_ALL_EXECUTIONS(P_JOB_NAME => 'BACKUP_LABAPROD_000022', P_JOB_OWNER => 'SYS');  MGMT_JOBS.STOP_ALL_EXECUTIONS(P_JOB_NAME => 'BACKUP_LABAPROD_000022', P_JOB_OWNER => 'SYS');  MGMT_JOBS.DELETE_JOB(P_JOB_NAME => 'BACKUP_LABAPROD_000022', P_JOB_OWNER => 'SYS');END;
oracle 数据库主机账号修改密码后,关于EM企业管理器中的主机 首选身份证明,密码也需要变更,不然在EM中的 可用性,调度备份,就会不能正常使用了。需要修改,就比较麻烦了。如果主机没法使用EM后,就只有使用EM CLI命令行来修改了。先要安装EM Cli 工具。可以使用下面命令查看 EM所登陆的rman 备份任务SELECT a.job_name, b.execution_hours, b.execution_minutes  FROM sysman.mgmt_job a, sysman.mgmt_job_schedule b WHERE a.schedule_id = b.schedule_id AND a.job_type = 'Backup';附件是emcli工具软件SettingPreferred Credentials UsingEM CLIWhen you provide the agent credentials, you can choose to enter the preferred credentials registered with the Enterprise Manager system.However, ensure that the credentials were registered using EM CLI.Toregister the credentials as preferred credentials for one host at a time, run the following command on the host where the Management Agent is running:emcli set_credential -target_type=host -target_name="<host_name>" -credential_set=OHCreds -column="OH...
在MySQL数据库中,如果不指定innodb_file_per_table=1参数单独保存每个表的数据,MySQL的数据都会存放在ibdata1文件里,时间久了这个文件就会变的非常大。下面是参考网上的一些资料,把数据分别保存在各数据库子目录里的方法,这样新产生的ibdata1文件就不会太大了。下面是在Ubuntu 14.04.12 x64,MySQL5.5上对ibdata1进行瘦身,操作过程的整理。1、备份数据库中的数据。mysqldump -u root -p --extended-insert --all-databases --add-drop-database --disable-keys --flush-privileges --quick --routines --triggers > /home/all-database.sql//有的文档用的是这样的参数:mysqldump -q -uroot -p --add-drop-table --all-databases --events >/home/all-database.sql如果ibdata1上百GB,备份过程可能需要几小时。2、停止MySQL服务。service mysql stop3、删除ibdata1、ib_logfile*等文件mv ibdata1 ibdata1.20160419mv ib_logfile0 ib_logfile0.20160420mv ib_logfile1 ib_logfile1.201604204、修改my.cnf配置文件vi /etc/mysql/my.cnf在[mysqld]子项下增加如下配置:innodb_file_per_table = 15、删除MySQL、performance_schema之外的所有数据库cd /var/lib/mysql...
CentOS 7.4部署MariaDB Galera Cluster集群架构日期:2018-03-10]来源:Linux社区 作者:zzkkk[字体:大 中 小]Mariadb galera Cluster安装:操作系统:CentOS 7.4版本集群数量:3个节点主机信息: 192.168.153.142 node1 selinux=disabled firewalld关闭192.168.153.143 node2 selinux=disabled firewalld关闭192.168.153.144 node3 selinux=disabled firewalld关闭搭建步骤1.主机之间互相解析:三台节点都要执行vim /etc/hosts192.168.153.142 node1192.168.153.143 node2192.168.153.144 node32.安装软件包第一种方法:(yum install -y MariaDB-server MariaDB-client galera)配置yum安装源和配置mariadb galera安装源yum源配置挂iso设置mariadb的yum源并安装(所有节点都要)修改yum源文件vi /etc/yum.repos.d/mariadb.repo[mariadb]name = MariaDBbaseurl = http://yum.mariadb.org/10.3.5/centos74-amd64gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDBgpgcheck=1enabled=0安装galera软件时需要解决它的依赖包:boost-program-options.x86_64 (直接yum源安装即可)第二种方法:(rpm包安装)三个节点都需要安装从网上下载rpm包:  galera-25.3.23-1....
 
0

oracle 闪回详解

发表者:admin分类:数据库DBA2019-09-26 09:38:10 阅读[275]
Oracle 9i 开始支持闪回,Oracle10g开始全面支持闪回功能,Oracle11g有所完善,为大家快速的恢复数据,查询历史数据提供了很大的便捷方法。本文主要对Oracle常用闪回使用做些详细介绍,其中对于不常用的事务和版本闪回,这里就不做介绍一、Oracle闪回概述闪回级别闪回场景闪回技术对象依赖影响数据数据库表截断、逻辑错误、其他多表意外事件闪回DATABASE闪回日志、undo是DROP删除表闪回DROP回收站(recyclebin)是表更新、删除、插入记录闪回TABLE还原数据,undo是查询当前数据和历史数据对比闪回QUERY还原数据,undo否版本查询比较行版本闪回Version Query还原数据,undo否事务查询比较闪回Transaction Query还原数据,undo否归档DDL、DML闪回Archive归档日志是                二、Oracle闪回使用详解1、闪回开启(1)开启闪回必要条件 a.开启归档日志SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /home/U01/app/oracle/oradata/testdb/arch Oldest online log sequence 844 Next log sequence to archive 846 Current log ...
Oracle 11.2.0.4.0打PSU补丁升级至11.2.0.4.19 一、简单介绍:Oracle补丁一般分为2类:CPU和PSUØ  CPU:Critical Patch Update,紧急补丁更新。每季度发布一次,用来修复安全方面的累积型补丁,即最新的CPU补丁已经包含以往的CPU补丁,只需安装最新的CPU补丁即可。CPU已更名为SPU(Security Patch Update)。Ø  PSU:Patch Set Update,补丁集更新。Oracle选取在每个季度用户下载数量最多、且得到验证具有较低风险的补丁放入到每个季度的PSU中。在每个PSU中不但包含Bug的修复,还包含了最新的CPU。PSU通常随CPU一起发布。PSU通常是增量的,大部分PSU可以直接安装,但有些PSU必须要求安装上一个版本的PSU之后才能继续安装。二、演示环境:1、IP:192.168.1.2202、操作系统:CentOS 6.10 x86_643、Oracle软件安装包:p13390677_112040_Linux-x86-64_1of7.zip、p13390677_112040_Linux-x86-64_2of7.zip4、Oracle版本:11.2.0.4.05、OPatch软件安装包:p6880880_112000_Linux-x86-64.zip(大小为108M)6、OPatch版本:11.2.0.3.207、Patch补丁包:p28729262_112040_Linux-x86-64.zip8、Patch ID:Patch 28729262(Oracle Database Patch Set Update 11.2.0.4....
ORACLE数据库如何查看分区表的相关信息:如下语句,根据Toad所用SQL,其中可以根据自己的情况修改表名与表所属用户。Select   TABLE_NAME, PARTITION_NAME, HIGH_VALUE, HIGH_VALUE_LENGTH, PARTITION_POSITION,   TABLESPACE_NAME, LOGGING, nvl(INI_TRANS, -1) ini_trans, nvl(MAX_TRANS, -1) max_trans,  nvl(INITIAL_EXTENT, -1) initial_extent, nvl(NEXT_EXTENT, -1) next_extent,   nvl(MIN_EXTENT, -1) MIN_EXTENT, nvl(MAX_EXTENT, -1) MAX_EXTENT, nvl(PCT_INCREASE, -1) PCT_INCREASE, nvl(PCT_FREE, -1) PCT_FREE,   nvl(PCT_USED, -1) pct_used, nvl(FREELISTS, -1) freelists, nvl(FREELIST_GROUPS, -1) freelist_groups, buffer_pool,  LAST_ANALYZED, nvl(NUM_ROWS, -1) NUM_ROWS, nvl(BLOCKS, -1) BLOCKS, nvl(EMPTY_BLOCKS, -1) EMPTY_BLOCKS, nvl(AVG_SPACE, -1) AVG_SPACE  ,SUBPARTITION_COUNT  ,COMPRESSION  ,COMPRESS_FOR  ,FLASH_CACHE, CELL_FLASH_CACHEFROM SYS.DBA_TAB_PARTITIONSWHERE TABLE_OWNER = 'NEC'and TABLE_NAME = 'TH_REPORT'ORDER BY TABLE_NAME, PARTITION_POSITION;Select PAR...
Oracle11gr2/12c 安装提示[INS-30131]执行安装程序验证所需的初始设置失败总是报错:[INS-30131]执行安装程序验证所需的初始设置失败(原因:无法访问临时位置)网上很多同样错误,都是让共享下C盘啥的,结果照着做了,没啥用。。废了老半天劲也没搞定,于是在metalink上搜了下,咳咳,第一篇文章就是我所遇到的问题:Bug 21452473  Windows: INS-30131 while Installing 12.1.0.2 Database/Client on Windows姑且称为bug吧,解决方法在文档中也提供了:针对客户端安装,在cmd中执行命令;setup.exe -ignorePrereq -J"-Doracle.install.client.validate.clientSupportedOSCheck=false" 针对服务端安装,在cmd中执行命令:setup.exe -ignorePrereq -J"-Doracle.install.db.validate.supportedOSCheck=false" 
【Oracle】详解Oracle中NLS_LANG变量的使用目录结构:contents structure [+]关于NLS_LANG参数NSL_LANG常用的值 在MS-DOS模式和Batch模式中设置NLS_LANG注册表中NLS_LANG和系统环境变量中的NLS_LANG参考文章1,关于NLS_LANG参数Oracle provides Globalization Support that enables users to interact with a database in their own language, as defined by the NLS_LANG parameter. When you install Oracle Database Client components, Oracle Universal Installer sets the NLS_LANG parameter in the registry.The locale setting of your operating system determines the value of the NLS_LANG parameter at installation. Table C-1 lists the operating system locale and NLS_LANG value mappings.The NLS_LANG parameter is stored in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG subkey, where ID is the unique number identifying the Oracle home.The NLS_LANG parameter uses the following format:NLS_LANG = LANGUAGE_TERRITORY.CHARACTER_SET Oracle提供全球化的支持,通过定义NLS_LANG参数能够让用户用他们自己的语言...
    总共41页,当前第1页 | 页数:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11