随笔分类 -  Oracle_backup&restore

How To Clone A Database Home From One Server To Other(same SID,directory,path)
摘要：Check the oracle home to clone [oracle@lnx1 dbhome_1]$ opatch lsinv Invoking OPatch 11.2.0.1.3 Oracle Interim Patch Installer version 11.2.0.1.3 Copyright (c) 2010, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/product/11.2.0/dbhome_1 Central Inventory : /home/oracle/oraInventor 阅读全文
posted @ 2012-03-12 15:29 dbblog 阅读(813) 评论(0) 推荐(0)
Oracle归档日志删除
摘要：我们都都知道在controlfile中记录着每一个archivelog的相关信息，当然们在OS下把这些物理文件delete掉后，在我们的controlfile中仍然记录着这些archivelog的信息，在oracle的OEM管理器中有可视化的日志展现出，当我们手工清除archive目录下的文件后，这些记录并没有被我们从controlfile中清除掉，也就是oracle并不知道这些文件已经不存在了!这时候我们要做手工的清除的话，下面我经过实验，可以尝试这种方法：1. 进入rman 2. connect target /3. crosscheck archivelog all;4. delete 阅读全文
posted @ 2011-12-15 11:04 dbblog 阅读(3470) 评论(0) 推荐(0)
How to identify all the Corrupted Objects in the Database reported with RMAN
摘要：Applies to:Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 11.2.0.2 - Release: 8.1.7 to 11.2 Information in this document applies to any platform.GoalHow to identify all the corrupted segments in the database using RMAN.SolutionStep 1: Identify the corrupt blocksPopulate the v$database_bloc 阅读全文
posted @ 2011-10-09 15:25 dbblog 阅读(1689) 评论(0) 推荐(0)