随笔分类 - Oracle
摘要：今天从Windows 上把一个1TB的数据库导入到linux oracle 11g中，频繁出现如下的APEX报错： Fri Nov 18 15:43:41 2022Errors in file /u01/app/oracle/diag/rdbms/dagl/dagl/trace/dagl_j000_
阅读全文
摘要：客户端 NLS_LANG 的设置方法Windows:# 常用中文字符集set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK# 常用unicode字符集set NLS_LANG=american_america.AL32UTF8可以通过修改注册表键值永久设置HK
阅读全文
摘要：select group#, sequence#, members, bytes, status, archived from v$log;select group#, status, type, member from v$logfile;添加redo组alter database add log
阅读全文
摘要：脚本内容：cat /opt/oracle/datadmp/expdp_adam.sh#!/bin/sh. /home/oracle/.bash_profilecd /opt/oracle/datadmp/find ./ -name "*.dmp" -mtime +3 -exec rm {} \;fi
阅读全文
摘要：Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:\Users\Administrator>expdp \"/ as sysdba\" attach=SYS_EXPORT_FULL_02 Expo
阅读全文
摘要：查看Oracle字符集： SQL> select * from nls_database_parameters; PARAMETER VALUE NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMER
阅读全文
摘要：[oracle@dbtest backup]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu May 5 13:58:39 2022 Copyright (c) 1982, 2013, Oracle. All r
阅读全文
摘要：1、查找特定表大小 select round(BYTES/1024/1024,2)||'M' from Dba_Segments where segment_name=upper('表名')； 2、查找数据库中占用空间较大的对象 SELECT OWNER,SEGMENT_NAME,SUM(bytes
阅读全文
摘要：[oracle@oracle-pd ~]$ sqlplus "/ as sysdba" SQL*Plus: Release 12.2.0.1.0 Production on Tue Aug 10 17:15:59 2021 Copyright (c) 1982, 2016, Oracle. All
阅读全文
摘要：查看归档警告 select * from V$RMAN_OUTPUT where lower(output) like '%warning%'; 有双节点集群同步到单机DG，看到rac备份上有警告 RMAN-08120: WARNING: archived log not deleted, not
阅读全文
摘要：[grid@rac01 ~]$ crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4535: Cannot communicate with Cluster Ready ServicesCRS-4530:
阅读全文
摘要：ASMCMD> commands: md_backup, md_restore lsattr, setattr cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias mkdir, pwd, rm, rmalias chdg, chkdg, dro
阅读全文
摘要：expdp时出现如下 报错， Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODYORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EX
阅读全文
摘要：SQL> startupORACLE instance started. Total System Global Area 6263357440 bytesFixed Size 2264856 bytesVariable Size 1241514216 bytesDatabase Buffers 4
阅读全文
摘要：一个1T的RAC数据库恢复到单机上，在恢复数据时出现如下报错： RMAN> recover database; Starting recover at 2021-01-21 05:18:12using channel ORA_DISK_1using channel ORA_DISK_2 starti
阅读全文
摘要：配置基于时间的备份保留策略 RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; 恢复spfile RMAN> restore spfile from '/bk/xxxxxx'; 如果在Oracle10g里这里就是控制文件，因为
阅读全文
摘要：SQL> select * from v$instance; select * from v$instance * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number:
阅读全文
