-
编辑 删除
Oracle内建包UTL_FILE使用说明
在数据库的开发中，当PL/SQL语句很复杂的时候，我想写一些Log，就像java的Log4j那样。这样就可以很好的跟踪程序的运行情况。在网上找到的文章不是很好用，修改了一下。1：在Oracle服务器上建立一个目录并指定权限（我这个是unix的。windows用c:/tmp之类的就行）CREATE DIRECTORY TEMP AS '/tmp';GRANT READ,WRIT...
-
编辑 删除
oracle中执行execute的时候权限不足的解决办法
create or replace procedure p_create_table Authid Current_User is begin Execute Immediate 'create table create_table(id int)'; end p_create_table; 红色字体为关键 使用户可以使用权限执行execute 我们知道...
-
编辑 删除
check RMAN BACKUP status
SQL> select name, db_unique_name, open_mode from v$database;NAME DB_UNIQUE_NAME OPEN_MODE--------- ------------------------------ ----------SHRARS ...
-
编辑 删除
V$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_JOB_DETAILS展示了rman备份的相关细节。比如，rman备份持续时间、rman备份的执行次数、每一次rman备份工作的状态（failed or completed and so on），每次rman备份的起始时间等等。SQL> desc sys.v$rman_backup_job_details Name ...
-
编辑 删除
opatch命令报错Inventory is corrupted
测试环境中执行opatch报错，简单描述一下解决过程。 错误信息如下：[orat3@hpserver2 OPatch]$ ./opatch lsinventoryInvoking OPatch 10.2.0.5.1Oracle Interim Patch Installer version 10.2.0.5.1Copyright (c) 2010, Oracle Corporation. All rights reserved.Oracl...
-
编辑 删除
Oracle中Inventory目录作用以及如何重建此目录
oraInventory存放的是Oracle软件安装的目录信息，Oralce的安装升级都需要用到这个目录，来看看Oracle文档中对这个目录的一点说明：All Oracle software installations rely on this directory. Ensure that you back it up regularly. Do not delete this directory unless you have completely removed&nbs...
-
编辑 删除
check parameters
SQL> set linesize 200set pagesize 1000column name format a40column value format a60select inst_id, name,value from gv$parameterwhere name in ('db_create_file_dest', 'audit_file_dest', ...
-
编辑 删除
Troubleshooting impdp is hanging no progress
Troubleshooting impdp is hanging no progressSR 3-17141087871 : impdp is hanging no progressHello jyothi babu -Provide the following information1. The command used when importing (include parfile if used)2. What is it waiting on? set pagesize 1000 set linesize 120 set...
-
编辑 删除
Using RMAN and Data Protection for Oracle
https://www.ibm.com/support/knowledgecenter/SSTFZR_6.4.0/com.ibm.itsm.db.orc.doc/r_dporc_rman_script_ex.htmlIBM Tivoli Storage Manager for Databases, Data Protection for Oracle, Version 6.3Script examplesSample RMAN scripts illustrate how to create parallel backup streams to Tivoli...
-
编辑 删除
Restore archivelogs to a different location
RMAN>run>{>set archivelog destination to '/stage';>restore archivelog from logseq 100278 until logseq 100298;>}In some scenarios we may need to restore the archivelogs to a different location from its primary location using RMAN from its backups.Below are the methods to do it.1. &...
-
编辑 删除
check undo info
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';col status format a15col description format a40 word_wrapset serverout on size 999999 lines 150 verify off pages 50 echo off trimspool onbreak on reportcompute Sum LABEL SUM of undosize_MB on reportcompute Sum LABEL SUM of block_coun...
