1. 查看当前数据库版本信息 [oracle@oracle19c ~]$ cd $ORACLE_HOME [oracle@oracle19c dbhome_1]$ ./OPatch/opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517242;Database Release Update : 19.
1. 操作前提 a. 数据文件创建之后的所有归档日志都可以用 b. 控制文件包含损坏的数据文件的名称 c. 没有相应的数据文件备份 2. 操作步骤 a. 删除数据文件模拟丢失 [oracle@oracle19c O19C]$ rm -rf aw01.dbf b. 关闭数据库 SQL> shutdown abort; c. 还原数据文件 SQL>
丢失多路复用日志组成员的恢复 a. 准备数据 #创建一个新的日志组 SQL> select group#, member from v$logfile; GROUP# MEMBER ----------------------------------------------- 3 /opt/oracle/oradata/O19C/redo03.lo
使用备份控制文件进行恢复 a. 准备数据库 create table tb01(id int); insert into tb01 values(1); insert into tb01 values(2); commit; b. 备份控制文件 SQL> select name from v$controlfile; NAME ---------------
编辑脚本su - oracle $ vi hugepages_settings.sh ------------------------------------------ #!/bin/bash # # hugepages_settings.sh # # Linux bash script to compute values for the # recommended HugePages/Huge
with aa as (SELECT IID, USERNAME, to_char(BEGIN_TIME,'mm/dd hh24:mi') begin_time, SQL_ID, decode(COMMAND_TYPE,3,'SELECT',2,'INSERT',6,'UPDATE',7,'DELETE',189,'MERGE INTO',
问题描述[oracle@servername db]$ OPatch/opatch version OPatch/opatch: line 839: [: too many arguments OPatch/opatch: line 839: [: too many arguments Java (1.7) could not be located. OPatch cannot proceed!
服务器配置检查1) 检查/tmp目录,至少需要400MB空间 2) 检查swap分区 256 MB: 3 times the size of RAM Between 256 MB and 512 MB: 2 times the size of RAM Between 512 MB and 2 GB: 1.5 times the size of RAM Between 2 GB and 16
Sets kernel parameters, if necessary, to values required for successful installation, including:Shared memory parameters.Open file descriptor and UDP send/receive parameters.Creates and sets permissio
select trunc(t.first_time) "Date", to_char(t.first_time, 'DY') "Day", count(1), sum(decode(to_char(first_time, 'HH24'), '00',1,0)) "H0", sum(decode(to_char(first_time, 'HH24'), '01',1,0)) "H1", sum(de
安装依赖包su - root yum -y install unzip yum -y install binutils.x86_64 yum -y install gcc.x86_64 yum -y install gcc-c++.x86_64 yum -y install glibc.i686 yum -y install glibc.x86_64 yum -y install gli
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号