EVISWANG的博客

概述：     Flashback Database 功能非常类似与RMAN 的不完全恢复， 它可以把整个数据库回退到过去的某个时点的状态， 这个功能依赖于Flashback log 日志。比RMAN 更快速和高效。因此Flashback Database 可以看作是不完全恢复的替代技术。sys dba删除的东西无法闪回， 其他用户的可以1．配置Flash Recovery A

RMAN> run{ ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_SERV=nbusrv, NB_ORA_CLIENT=Pbddb'; set until time='2019-03-14 23:30:00'; restore database; RELEASE CHANNEL ch00;}2&...

impdp  \'/ as sysdba\'   directory=dp_dir   dumpfile=ATS003_20190107_%U.dmp logfile=ATS003_20190107_imp3.log schemas=ATS003 remap_schema=ATS003:ATS003 TRANSFORM=SEGMENT_ATTRIBUTES:N...................

数据库rman恢复recoverSQL> recover database using backup controlfile until time '2018-11-27 02:00:00';ORA-00279: change 10495820489810 generated at 11/27/2018 00:00:15 needed forthread 1ORA-0028...

一、问题概述expdp通过parfile导数时候报错如下：ORA-39194: Table mode jobs require the tables to be comma separated.相关脚本为：userid='sys/uyeer432@pnccist as sysdba'directory=LZLLdumpfile=expdp_%Y%M%U.dmplogfile...

二. 恢复步骤：1. 参数文件恢复[oracle@localhost ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Tue Sep 5 05:50:45 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights

一. 问题描述：       BI分析部门反映夜间拉取的ORACLE备库数据和业务部门导入主库的数据不一致，之间相差近2个小时。二. 问题分析：     第一反映备库归档有GAP，主备库延迟，经过查询发现主备库归档并无延迟SQL> select process, status, sequence# , ACTIVE_AGENTS from v$managed_standby;P

IMP-00032: SQL statement exceeded buffer lengthIMP-00008: unrecognized statement in the export file:imp   aps20170131/aps20170131  file= INVEST_20170131_23.dmp  log= INVEST_20170131_23_imp.log

一. 问题描述： [oracle@crfdb1 temp]$ expdp  clspuser/clsp  dumpfile=hmtdb20130301_hmt_log.dmp directory= pump_dir  tables = crf_p2p_rpt_bill_pen_new query=crf_p2p_rpt_bill_pen_new:'"where ( GZ_YM = '201

一.问题分析      EXP时报这个错[oracle@host01 ~]$ exp scott/tiger file=emp_dept.dmp tables=empExport: Release 11.2.0.3.0 - Production on Sun Jul 3 16:47:02 2016Copyright (c) 1982, 2011, Oracle and/or

1. 问题描述巡检发现NBU备份周末有报错，手工备份不成功，查看NBU日志2016/6/20 10:44:51 - 信息 nbjm(PID=7248) starting backup job (jobid=65882) for client erpdb01.szgas.com, policy erpdb01_PROD1, schedule FULL  2016/6/20 10:44:5

1. 问题描述：RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10>

1.问题描述警告日志报错如下： Thu Feb 18 01:59:48 2016Errors in file/u01/PSPROD/oracle/diag/rdbms/psprod/PSPROD1/trace/PSPROD1_ora_45856.trc:ORA-00245: control file backup failed;target is likely on a loc

Fri Jan 01 05:38:42 2016LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (19502)LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandonedError 19502 for archive log file 2

输出日志：[oracle@tiger script]$ cat rman_db.shexportORACLE_HOME=/u01/oracle/product/11.2.0.4export ORACLE_SID=TIGERrman target / cmdfile=/u01/rman/script/rman_db.rcv msglog=/u01/rman/script/rman_full

[oracle@tiger script]$ crontab -l0 0 * * 0,3 /u01/rman/script/rman_db_inr0.sh0 0 * * 1,2,4-6 /u01/rman/script/rman_db_inr1.sh[oracle@tiger script]$ [oracle@tiger script]$ cat rman_db_inr0.sh

一. 导出数据（源环境）1.        创建目录：# mkdir -p /u01/datadump# chown oracle:dba /u01/datadump# su – oracle$ sqlplus "/as sysdba"SQL> create directory datapump as '/u01/datadump'; 2.        导出文件：$

[root@tiger script]# cat rman_db.sh export ORACLE_HOME=/u01/oracle/product/11.2.0.4export ORACLE_SID=TIGERrman target / cmdfile=/u01/rman/script/rman_db.rcv msglog=/u01/rman/script/rman_full_`da

RMAN> run{ ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_SERV=nbusrv, NB_ORA_CLIENT=Pbdopdb'; restore archivelog from sequence 34722 until sequence 34723 INCARNATION ALL; RELEAS...