-
编辑 删除
处理backup job 失败一例
今天查看运行在windows上的production数据库,发现上个星期五的备份job失败.报错误:ORA-27072: File I/O errorOSD-04008: WriteFile() failure, unable to write to fileO/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file. 查看metalink,发现原来是防病毒软件的问题,解决步骤如下:Include the following OS commands before running the RMAN backup script:net stop "SavRoam"net stop "Symantec AntiVirus"net stop "Symantec AntiVirus Defin
-
编辑 删除
Explain plan for and autotrace diffrence
The main difference have three points:1. Explain plan for : generate the execution plan not the actually execution plan will happen on database. the actually plan should query v$sql_plan view. Autotrace: generate the actually execution plan2. Explain plan for: only work at query statement that is SELECTs; Autotrace: works for any SQL and DML statements3.Explain plan for: you have to use utlxpls.sql to have the readable report for the execution plan.Autotrace: automaticaly show the execution plan
-
编辑 删除
understanding oracle 10g incremental updated backup using rman
those days i try to understand incremental updated backup, example :RMAN> run {2> recover copy of database with tag 'level_0';3> backup incremental level 1 for recover of copy with tag 'level_0' database format '/backup/%UORA10G';4> }Starting recover at 02-JAN-08using channel ORA_DISK_1no copy of datafile 1 found to recoverno copy of datafile 2 found to recoverno copy of datafile 3 found to recoverno copy of datafile 4 found to recoverFinished recover at 02-JAN-08Starting backup at 0
