-
编辑 删除
rman 异机恢复脚本(路径不一致)
由于之前写rman 脚本的时候需要手动去修改一些路径很麻烦，没办法做此脚本方便大家。注此脚本使用前提数据库已经mount,也就是已经恢复了参数文件及控制文件<br /><div><div class="codeheads"><p>点击(<span style="cursor:pointer;color:red;" onclick="code_hide('code34')">此处</span>)折叠或打开<br /><br ...
-
编辑 删除
利用 Data Recovery Advisor诊断并修复失败ORA-01110
Diagnosing and Repairing Failures with Data Recovery AdvisorThe simplest way to diagnose and repair database problems is to use the Data Recovery Advisor. This Oracle Database tool provides an infrastructure for diagnosing persistent data failures, presenting repair options to the user, and automa...
-
编辑 删除
RMAN修复无效的数据块(ORA-01578)
Recovering Individual Data BlocksRMAN can recover individual corrupted datafile blocks. When RMAN performs a complete scan of a file for a backup, any corrupted blocks are listed in V$DATABASE_BLOCK_CORRUPTION. Corruption is usually reported in alert logs, trace files, or results of SQL queries....
-
编辑 删除
将FileSystem转换为ASM存储
[grid@OLEASM1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 18 02:42:27 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Automatic Storage Management ...
-
编辑 删除
Rman 单实例filesystem(Windows)恢复到ASM环境(Linux)
一.使用RMAN convert将Oracle 从Windows(windows server 2008 R2)迁移到Linux(OLE 6.5)官方文档关于RMAN CONVERT 解释(http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm#BRADV89986)Database ConversionTo convert a whole database to a different platform, both platforms must use the s...
-
编辑 删除
无备份恢复(归档模式)
无备份恢复表空间前提是归档存在[oracle@NetData-ora10g-118 ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Tue Aug 5 10:02:46 2014Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: NETDATA (DBID=348346524)RMAN> list backup of databa...
-
编辑 删除
无备份恢复(归档模式)
无备份恢复表空间前提是归档存在[oracle@NetData-ora10g-118 ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Tue Aug 5 10:02:46 2014Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: NETDATA (DBID=348346524)RMAN> list backup of databa...
-
编辑 删除
rman datafile恢复(归档模式)
模拟环境1. 做操作之前先备份数据库RMAN> run { # Hot database level 0 whole backup allocate channel t1 type disk; backup incremental level 0 skip inaccessible format '/oracle/ba...
