Oracle 备份与恢复
文章平均质量分 74
leishifei
这个作者很懒,什么都没留下…
展开
-
Oracle RMAN 备份与恢复实例常用命令整理
1.检查数据库模式: sqlplus /nolog conn /as sysdba archive log list (查看数据库是否处于归档模式中) 若为非归档,则修改数据库归档模式 shutdown immediate sta原创 2011-08-29 21:35:30 · 557 阅读 · 0 评论 -
Recover truncate table using RMAN tablespace point in time recovery
Recover truncate table using RMAN tablespace point in time recovery<br />Here I’m go to demonstrate How do we recover truncate table using RMAN tablespace point in time recovery.<br />I hope This post may very user friendly for you without confusion <br />转载 2011-04-30 22:20:00 · 399 阅读 · 0 评论 -
RMAN Recover database noredo commands
RMAN Recover database noredo commands<br />Posted by azardba on February 13, 2011<br />When our db running in noarchivelog mode, Online redolog file may failure occur during startup your db, how do you recover if you have a consistent cold backup avilable转载 2011-04-30 20:02:00 · 796 阅读 · 0 评论 -
How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN [ID 223543.1]
How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN [ID 223543.1] Modified 02-FEB-2011 Type FAQ Status PUBLISHED <br />In this Document<br /> Purpose<br /> Questions and Answers<br /> General overview of procedure to recover from a原创 2011-04-27 22:57:00 · 765 阅读 · 0 评论 -
RMAN: RAC Backup and Recovery using RMAN [ID 243760.1]
RMAN: RAC Backup and Recovery using RMAN [ID 243760.1] 修改时间 20-OCT-2010 类型 BULLETIN 状态 PUBLISHED "Checked for relevance on 02-JUL-2010"RAC Backup and Recovery using RMANObjectives:===========1. Verify the database mode and archive d原创 2011-04-27 10:43:00 · 388 阅读 · 0 评论 -
RMAN format 参数说明
<br />RMAN format 参数说明<br /> <br /><br />FORMAT = 'format_string'<br /><br />Specifies a filename to use for the backup piece. Any name that is legal as a sequential filename on the platform is allowed, if each backup piece has a unique name. If backing up原创 2011-04-22 12:26:00 · 424 阅读 · 0 评论 -
RMAN SHOW ALL 配置信息浅析
<br />RMAN SHOW ALL 配置信息浅析<br /> <br />1. 显示当前的配置信息<br />1.01 RMAN> show all;<br /><br /><br />2. 常用的configure选项<br /><br />2.01 保存策略 (retention policy)<br />configure retention policy to recovery window of 7 days;<br />configure retention policy to redund原创 2011-04-14 21:52:00 · 1341 阅读 · 0 评论 -
Oracle RMAN 完全恢复
Objectivel Describe the use of RMAN for restoration and recoveryl Perform complete recovery in ARCHIVELOG model Restore datafiles to different locationsl Relocate and recover a tablespace by using archived redo log filesRestoration Using RMANl Restore file原创 2011-04-14 13:25:00 · 1523 阅读 · 0 评论 -
Oracle10g新特性:闪回恢复区(Flash recovery area)设置与监控
Oracle10g新特性:闪回恢复区(Flash recovery area)设置与监控1.设置闪回恢复区闪回恢复区主要通过3个初始化参数来设置和管理•db_recovery_file_dest:指定闪回恢复区的位置 •db_recovery_file_dest_size:指定闪回恢复区的可用空间大小 •db_flashback_retention_target:指定数据库可以回退的时间,单位为分钟,默认1440分钟,也就是一天。当然,实际上可回退的时间还决定于闪回恢复区的大小,因为里面保存了回退所需要的f原创 2011-04-16 06:16:00 · 462 阅读 · 0 评论 -
Oracle误删除表数据后的恢复详解
Oracle误删除表数据后的恢复详解测试环境:SYSTEM:IBM AIX 5L Oracle Version:10gR21. undo_retention参数的查询与修改使用show parameter undo命令查看当前的数据库参数undo_retention设置。显示如下:SQL> show parameter undoNAME TYPE VALUE-------------原创 2011-04-15 10:46:00 · 5788 阅读 · 0 评论 -
Oracle的差异增量备份和累积增量备份
<br /> 在rman增量备份中,有差异增量和累积增量的概念<br /> 1、概念<br /> 差异增量:是备份上级及同级备份以来所有变化的数据块,差异增量是默认增量备份方式<br /> 累积增量:是备份上级备份以来所有变化的块<br /> 因为累积增量是备份上级备份以来所有变化的数据块,所以累积增量需要更多的备份时间,同时需要较小的恢复时间;而差异增量正好相反,它可以备份同级备份以来变化的数据块。所以会减少备份时间,但需要更多的恢复时间.在oracle 9中增量备份需要通过转载 2011-06-02 13:55:00 · 292 阅读 · 0 评论 -
RMAN Configuring Tablespaces for Exclusion
RMAN Configuring Tablespaces for Exclusion<br />In some cases you may want to exclude specified tablespace part of the regular backup schedule, as in these cases: A tablespace is easy to rebuild, so it is more cost-effective to rebuild it than back it up e转载 2011-05-01 09:37:00 · 229 阅读 · 0 评论 -
Can I Store Datapump dumpfiles in ASM diskgroup?
Can I Store Datapump dumpfiles in ASM diskgroup?<br />One of my friend asked me , Can I store Datapump dumpfile in asm diskgroup?. Yes you can. Now we can see How do we create directory and store dumpfile.<br />Step 1: Go To ASM Instance and Create New Dir转载 2011-05-01 09:43:00 · 239 阅读 · 0 评论 -
Oracle Online Redo log的状态分析及故障处理方法
Redo日志组的状态:Current:目前正在写的日志组;Active:目前不在写,但是还未进行ckpt,即cache中脏数据还未写入datafile,恢复时需要用到此日志组;Inactive:目前不在写,已进行ckpt,实例恢复不需要此日志组。 由于每3秒进原创 2011-08-30 06:37:30 · 509 阅读 · 0 评论 -
Oracle 传输表空间迁移数据总结
Oracle 传输表空间迁移数据总结 这几天杭州的 天气太热,不想出去玩,在这边等待面试结果,突然间想到这个问题,所以在网上找了点资料,总结一下。 注意:迁移表空间之前必需先建立相对应的用户,要不然会迁移不成功的。有时,我们需要把比较大的数据进行跨平台(10G原创 2011-08-02 09:08:48 · 1893 阅读 · 0 评论 -
ORACLE EXP/IMP的使用详解
ORACLE EXP/IMP的使用详解 导入/导出是ORACLE幸存的最古老的两个命令行工具,其实我从来不认为Exp/Imp是一种好的备份方式,正确的说法是Exp/Imp只能是一个好的转储工具,特别是在小型数据库的转储,表空间的迁移,表的抽取,检测逻辑和物理冲突等中有不小的功劳。原创 2011-07-22 13:29:31 · 465 阅读 · 0 评论 -
How to recover datafile not backed up
How to recover datafile not backed up<br />Recently i just added one datafile for a tablespace and later, had a media failure occur before I backuped recently datafile.In this case , How do we recover.<br />We have previous Good Database backup.<br />Redo转载 2011-05-01 14:18:00 · 375 阅读 · 0 评论 -
ORA-19566: exceeded limit of 0 corrupt blocks
ORA-19566: exceeded limit of 0 corrupt blocks<br /> <br />When i try to take backup, it will shows block corrupted errors,<br />RMAN> backup database;<br />Starting backup at 25-MAY-10<br />using channel ORA_DISK_1<br />channel ORA_DISK_1: starting full da转载 2011-05-01 10:02:00 · 753 阅读 · 0 评论 -
Transport the tablespace on Same OS platform
Transport the tablespace on Same OS platform<br />You want to transport tablespaces using RMAN backups instead of performing the transportable tablespaces operation on the live production database.<br />Source Database : MYTEST<br />Target Database : MYDB转载 2011-05-01 09:59:00 · 5692 阅读 · 0 评论 -
Recovering after loss of all members of the INACTIVE redo log group
Recovering after loss of all members of the INACTIVE redo log group<br />You’re attempting to open your database and receive this message<br />ORA-00313: open failed for members of log group 2 of thread 1<br />ORA-00312: online log 2 thread 1:<br />‘/home/转载 2011-05-01 09:58:00 · 254 阅读 · 0 评论 -
Recovering After loss of all members of the CURRENT redo log group
Recovering After loss of all members of the CURRENT redo log group<br /> <br />All of the members of a current online redo log group in your database have experience media failure.<br />You lose all members of a current online redo log group. Here are poss转载 2011-05-01 09:57:00 · 447 阅读 · 0 评论 -
RMAN : Restoring datafiles to Nondefault locations
RMAN : Restoring datafiles to Nondefault locations<br />You have just experiences a serious media failure and won’t able to restore datafiles to their original location.In this case, you need to restore datafiles to a nondafault location.<br />You can use转载 2011-05-01 09:53:00 · 292 阅读 · 0 评论 -
How to export from oracle 11.2 and import into 10.2 version
How to export from oracle 11.2 and import into 10.2 version<br />I think many OTN users asked repeately this question How do i export from higher version and import into lower version.I just show here How do we do.<br />First : Using Datapump from Oralce 1转载 2011-05-01 09:48:00 · 469 阅读 · 0 评论 -
ORA-19909: datafile 1 belongs to an orphan incarnation 一例
ORA-19909: datafile 1 belongs to an orphan incarnationSQL> startup mount;ORACLE instance started.Total System Global Area 6847938560 bytesFixed Size 2219808 bytesVariable Size 3539992800 bytesDatabase Buffers 3288334336原创 2011-04-13 16:23:00 · 2430 阅读 · 0 评论 -
Oracle 11g Data Guard 使用duplicate from active database 创建 standby database 实验
<br /><br />Oracle 11g Data Guard 使用duplicate from active database 创建 standby database 实验<br /> <br />使用duplicate from active database 来搭建standby database,主库的停机时间很少,只需要重启一下,使参数生效。也可以用这种方法进行DB迁移。DG搭建好,然后把备库激活就可以了,这样整个迁移中宕机时间也比较短。<br /><br />Oracle 11g的physi原创 2011-04-12 16:02:00 · 681 阅读 · 0 评论 -
Oracle 11gR2 利用RMAN duplicate from active database 复制数据库实验
<br />Our Lab Environments<br />Source database Duplicate database<br />SYSTEM: IBM AIX 5L SYSTEM: IBM AIX 5L<br />IP ADDRESS:172.30.2.40 IP ADDRESS:172原创 2011-04-11 16:41:00 · 665 阅读 · 0 评论 -
RMAN 备份常用脚本
<br />1. 建立 RMAN 用户(create_rmanuser.sql)<br />create user rmanuser identified by 1234 default tablespace users temporary tablespace temp;<br />grant connect,resource,recovery_catalog_owner to rmanuser;<br />exit;<br /><br />2. 建立恢复目录(create_catalog.rcv)<br原创 2011-04-10 12:55:00 · 325 阅读 · 0 评论 -
RMAN DUPLICATE SELECTS WRONG SCN IF SET UNTIL SEQUENCE, WORKS FINE IF SET UNTIL SCN [ID 1076816.1]
RMAN DUPLICATE SELECTS WRONG SCN IF SET UNTIL SEQUENCE, WORKS FINE IF SET UNTIL SCN [ID 1076816.1] Modified 03-MAY-2010 Type PROBLEM Status MODERATED In this Document Symptoms Changes Cause Solution References This document is being delivered原创 2011-05-27 06:55:00 · 712 阅读 · 0 评论 -
How to map SCN with Timestamp before 10g? [ID 365536.1]
How to map SCN with Timestamp before 10g? [ID 365536.1] Modified 16-MAY-2006 Type HOWTO Status PUBLISHED In this Document Goal Solution Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.6.0Information in this document applies to any原创 2011-05-27 06:51:00 · 290 阅读 · 0 评论 -
How to locate SCN/Time of DROP TABLE using LogMiner [ID 93370.1]
How to locate SCN/Time of DROP TABLE using LogMiner [ID 93370.1] Modified 17-APR-2009 Type BULLETIN Status PUBLISHED PURPOSE This article discusses and demonstrates how to locate and analyze a DROP TABLE statement in online and archived redo原创 2011-05-27 06:45:00 · 634 阅读 · 0 评论 -
Flashback Table Feature in Oracle Database 10g [ID 265254.1]
Flashback Table Feature in Oracle Database 10g [ID 265254.1] Modified 25-JUL-2010 Type HOWTO Status PUBLISHED ***Checked for relevance on 25-Jul-2010***PURPOSE=======This bulletin illustrates the new Flashback Table feature provided with th原创 2011-05-27 06:37:00 · 330 阅读 · 0 评论 -
How to restore and recover an Oracle database to a 'Point in Time' using an on-line backup
Problem<br /> How to restore and recover an Oracle database to a 'Point in Time' using an on-line backupSolution<br />When restoring and recovering an Oracle database damaged by a user error or process failure, a very specific procedure must be followed.<b转载 2011-05-26 22:16:00 · 431 阅读 · 0 评论 -
How To Get Time/Scn From Last Night Backup To Create Duplicate Database [ID 560328.1]
How To Get Time/Scn From Last Night Backup To Create Duplicate Database [ID 560328.1] Modified 02-APR-2008 Type HOWTO Status MODERATED In this Document Goal Solution This document is being delivered to you via Oracle Support's Rapid Visibility (R原创 2011-05-27 06:42:00 · 408 阅读 · 0 评论 -
Oracle数据库中误删除数据后恢复
<br />Oracle数据库中误删除数据后恢复<br /><br />SCN(系统改变号),它的英文全拼为:System Change Number ,它是数据库中非常重要的一个数据结构。<br />SCN提供了Oracle的内部时钟机制,可被看作逻辑时钟,这对于恢复操作是至关重要的<br />注释:Oracle 仅根据 SCN 执行恢复。<br />它定义了数据库在某个确切时刻提交的版本。在事物提交时,它被赋予一个唯一的标示事物的SCN 。一些人认为 SCN 是指, System Commit Numb原创 2011-05-26 21:54:00 · 457 阅读 · 0 评论 -
recover [SQL*PLUS]
<br /><br />recover [SQL*PLUS]<br />recover database until cancel<br />recover database until time '2004-03-21:22:59:04'<br />recover database until change 123456<br /><br />recover datafile 'filename' until cancel<br />recover datafile 'filename' until ti原创 2011-05-26 20:29:00 · 322 阅读 · 0 评论 -
RMAN Enhancements in Oracle Database 10g
RMAN Enhancements in Oracle Database 10g<br />Oracle 10g includes many RMAN enhancements making it a more complete tool, including the following.Flash Recovery AreaIncrementally Updated BackupsFast Incremental BackupsBACKUP for Backupsets and Image CopiesC转载 2011-05-17 16:50:00 · 487 阅读 · 0 评论 -
RMAN RECOVERY CATALOG 配置实例
<br /><br />Oracle RMAN配置与备份信息默认是存放在target数据库的控制文件中,我们可以配置一个recovery catalog服务器来存储这些信息,另外还可以用其来存储一些全局的脚本。<br /><br />下面我将演示恢复目录的配置过程,其中172.30.10.40为catalog数据库所在的主机,172.30.10.37为target数据库所在的主机。<br /><br />环境:IBM AIX 5300-08 <br />catalog数据库Oracle 10g 10.2.0原创 2011-04-10 17:32:00 · 364 阅读 · 0 评论 -
Creating a Duplicate Database on a New Host. [ID 388431.1]
Creating a Duplicate Database on a New Host. [ID 388431.1] Modified 01-FEB-2011 Type HOWTO Status PUBLISHED In this Document Goal Solution Duplicate database from server A to server B (Non ASM) 1. Backup of the primary database. 2. De原创 2011-06-01 20:46:00 · 383 阅读 · 0 评论 -
RMAN Restore Database Slow / How To Improve RMAN Restore Performance [ID 467694.1]
<br />RMAN Restore Database Slow / How To Improve RMAN Restore Performance [ID 467694.1]<br /> <br />--------------------------------------------------------------------------------<br />Modified 10-JUN-2010 Type HOWTO Status MODERATED<br /><br />I原创 2011-04-13 09:38:00 · 276 阅读 · 0 评论 -
Oracle 11g RMAN 异机duplicate数据库
Oracle 11g RMAN 异机duplicate数据库实验平台: IBM AIX 5L + Oracle 11g 目标库信息:ORACLE_BASE: /u01/app/oracleORACLE_HOME: /u01/app/oracle/product/11.2.0/db_1ORACLE_SID:orclIP: 172.30.2.40辅助库信息:ORACLE_BASE: /u01/app/oracleORACLE_HOME: /u01/app/oracle/product/11.2.0/db_1OR原创 2011-04-12 06:25:00 · 1906 阅读 · 0 评论