Oracle RMAN
文章平均质量分 81
leishifei
这个作者很懒,什么都没留下…
展开
-
Oracle RMAN 备份与恢复实例常用命令整理
1.检查数据库模式: sqlplus /nolog conn /as sysdba archive log list (查看数据库是否处于归档模式中) 若为非归档,则修改数据库归档模式 shutdown immediate sta原创 2011-08-29 21:35:30 · 557 阅读 · 0 评论 -
How to relocate datafiles using RMAN [ID 755620.1]
How to relocate datafiles using RMAN [ID 755620.1] Modified 06-DEC-2010 Type HOWTO Status PUBLISHED How to relocate datafiles using RMAN [ID 755620.1]Modified 06-DEC-2010 Type HOWTO Status PUBLISHEDIn this Document Goal Solution Referenc原创 2011-04-27 22:41:00 · 300 阅读 · 0 评论 -
RMAN Restore Database Slow / How To Improve RMAN Restore Performance [ID 467694.1]
RMAN Restore Database Slow / How To Improve RMAN Restore Performance [ID 467694.1] Modified 10-JUN-2010 Type HOWTO Status MODERATEDRMAN Restore Database Slow / How To Improve RMAN Restore Performance [ID 467694.1]Modified 10-JUN-2010 Type HOWTO原创 2011-04-27 22:27:00 · 245 阅读 · 0 评论 -
RMAN Backup Performance [ID 360443.1]
RMAN Backup Performance [ID 360443.1] Modified 02-JUL-2010 Type BULLETIN Status PUBLISHED <br />In this Document<br /> Purpose<br /> Scope and Application<br /> RMAN Backup Performance<br /> References<br /><br /> <br /> Applies to: <br />Oracl原创 2011-04-27 22:21:00 · 406 阅读 · 0 评论 -
Oracle10g / 11g - Getting Started with Recovery Manager (RMAN) [ID 360416.1]
Oracle10g / 11g - Getting Started with Recovery Manager (RMAN) [ID 360416.1] Modified 08-FEB-2011 Type BULLETIN Status PUBLISHED <br />In this Document<br /> Purpose<br /> Scope and Application<br /> Oracle10g / 11g - Getting Started with Recove原创 2011-04-28 15:20:00 · 847 阅读 · 0 评论 -
Performing duplicate database with ASM/OMF/RMAN [ID 340848.1]
Performing duplicate database with ASM/OMF/RMAN [ID 340848.1] Modified 23-OCT-2010 Type BULLETIN Status PUBLISHED <br />In this Document<br /> Purpose<br /> Scope and Application<br /> Performing duplicate database with ASM/OMF/RMAN<br /><br />原创 2011-04-28 10:41:00 · 390 阅读 · 0 评论 -
RMAN 'Duplicate Database' Feature in Oracle9i / 10G and 11G [ID 228257.1]
RMAN 'Duplicate Database' Feature in Oracle9i / 10G and 11G [ID 228257.1] Modified 01-FEB-2011 Type BULLETIN Status PUBLISHED <br />In this Document<br /> Purpose<br /> Scope and Application<br /> RMAN 'Duplicate Database' Feature in Oracle9i /原创 2011-04-27 22:54:00 · 354 阅读 · 0 评论 -
Creating a Data Guard Database with RMAN (Recovery Manager) using Duplicate Command [ID 183570.1]
Creating a Data Guard Database with RMAN (Recovery Manager) using Duplicate Command [ID 183570.1] Modified 19-OCT-2010 Type BULLETIN Status PUBLISHED "Checked for relevance on 21-Dec-2008"PURPOSE-------To understand and use the 9i Data Gu原创 2011-04-27 22:53:00 · 386 阅读 · 0 评论 -
RMAN 11GR2 : DUPLICATE WITHOUT CONNECTING TO TARGET DATABASE [ID 874352.1]
RMAN 11GR2 : DUPLICATE WITHOUT CONNECTING TO TARGET DATABASE [ID 874352.1]Modified 04-FEB-2011 Type HOWTO Status REVIEWEDRMAN 11GR2 : DUPLICATE WITHOUT CONNECTING TO TARGET DATABASE [ID 874352.1] Modified 04-FEB-2011 Type HOWTO Status REVIE原创 2011-04-27 23:00:00 · 496 阅读 · 0 评论 -
RMAN - How to restore the controlfile using RMAN [ID 580414.1]
RMAN - How to restore the controlfile using RMAN [ID 580414.1]Modified 10-JUN-2010 Type HOWTO Status PUBLISHEDRMAN - How to restore the controlfile using RMAN [ID 580414.1] Modified 10-JUN-2010 Type HOWTO Status PUBLISHED In this Document原创 2011-04-27 22:47:00 · 876 阅读 · 0 评论 -
RMAN Fast Incremental Backups [ID 262853.1]
RMAN Fast Incremental Backups [ID 262853.1] Modified 20-OCT-2010 Type BULLETIN Status PUBLISHED RMAN Fast Incremental Backups [ID 262853.1] Modified 20-OCT-2010 Type BULLETIN Status PUBLISHED Modified 20-OCT-2010 Type BULLETIN Statu原创 2011-04-27 22:31:00 · 289 阅读 · 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 评论 -
Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1]
Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1] Modified 08-MAR-2011 Type HOWTO Status MODERATED In this Do原创 2011-06-08 15:26:00 · 371 阅读 · 0 评论 -
Duplicate Database With RMAN Without Connecting To Target Database [ID 732624.1]
Duplicate Database With RMAN Without Connecting To Target Database [ID 732624.1] Modified 01-FEB-2011 Type HOWTO Status MODERATED <br />In this Document<br /> Goal<br /> Solution<br /> References<br /><br />Platforms: 1-914CU; <br /> This docume原创 2011-04-27 22:56:00 · 256 阅读 · 0 评论 -
RMAN: Restoring an RMAN Backup to Another Node [ID 73974.1]
RMAN: Restoring an RMAN Backup to Another Node [ID 73974.1] Modified 19-OCT-2010 Type BULLETIN Status PUBLISHED Checked for relevance on 02-JUL-2010PURPOSE------- The purpose of this document is to demonstrate a restore of an RMAN backup原创 2011-04-28 10:30:00 · 307 阅读 · 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备份中obsolete和expired的区别
<br />Rman备份中obsolete和expired的区别<br /><br /><br />obsolete:与retention policy相关,当备份或者副本根据保存策略而被丢弃的时候,就会被标记为该状态。比如你设置恢复窗口为7天,今天10号,那2号之前(包括2号)的都被认为是“过期的”。<br /><br />expired:使用crosscheck对备份进行校验,当备份或者副本被存储在rman目录中,但是并没有物理存在于备份介质上时,就会被标记为该状态;在操作系统层删除备份集后,用cros原创 2011-05-03 15:45:00 · 320 阅读 · 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 评论 -
create duplicate database using rman
create duplicate database using rman<br />You want to use RMAN to create a duplicate database on the same server by using RMAN backups.<br />My Source Database Name is MYTEST<br />Target (duplicate) Database name is MYDB <br />Step 1: Configure Listener.or转载 2011-05-01 10:00:00 · 298 阅读 · 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 评论 -
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 评论 -
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 评论 -
Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]
<br /> <br /> <br />Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1] Modified 12-DEC-2010 Type HOWTO Status MODERATED <br />In this Document<br /> Goal<br /> Solution<br /><br />Platforms: 1-914CU; <br /> <br />This原创 2011-04-27 22:49:00 · 505 阅读 · 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 评论 -
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 评论 -
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 评论 -
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 评论 -
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 database
<br />RMAN duplicate database是一个备份与恢复的过程。<br />duplicate database有一个优点,它会为duplicated database生成新的DBID。<br /><br />在metalink[ID 388431.1]给出了duplicate database的大致步骤:<br />1. Backup of the primary database.<br />2. Determine how much disk space will be requir原创 2011-04-10 12:50:00 · 355 阅读 · 0 评论 -
RMAN 检查数据文件和备份文件的一致性
<br />检查数据文件一致性,包括物理一致性跟逻辑一致性<br /><br />backup check logical validate database;<br /><br />$ rman target /<br /><br />Recovery Manager: Release 10.2.0.4.0 - Production on Mon May 30 03:04:15 2011<br /><br />Copyright (c) 1982, 2007, Oracle. All rights re原创 2011-05-30 16:38:00 · 493 阅读 · 0 评论 -
Windows下RMAN全备脚本
<br /><br />1. 修改RMAN相关参数<br />RMAN>show all;<br />RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;<br />RMAN>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:/backup/%F';<br />RMAN>exit;<br />如上设置,控制文件和参数文件spfile就会随着数据库备份自动备份到d:/backup目录下。<br /原创 2011-04-08 12:16:00 · 593 阅读 · 0 评论 -
RMAN REPORT 命令
<br />RMAN report 命令<br /><br />REPORT命令:<br />RMAN> report schema; 报告目标数据库的物理结构;<br />RMAN>report need backup days=3; 报告最近3天没有被备份的数据文件;<br />RMAN> report need backup days 3 tablespace users; 在USERS表空间上3天未备份的数据文件;<br />RMAN> report need backup incremental原创 2011-05-24 13:12:00 · 331 阅读 · 0 评论 -
Catalog下的RMAN增量备份SHELL脚本
<br />在执行脚本之前,先修改几个参数值:<br />修改控制文件的保存时间,从默认的7天改成14天<br />SQL> show parameter control<br />SQL> alter system set control_file_record_keep_time=14 scope=both; <br />开启控制文件的自动备份,开启之后在数据库备份或者数据文件(比如添加数据文件)有修改的时候都会自动备份控制文件和spfile文件。<br />configure controlfile原创 2011-04-08 12:05:00 · 401 阅读 · 0 评论 -
Nocatalog下的RMAN增量备份SHELL脚本
在执行脚本之前,先修改几个参数值:1. DB 参数:修改控制文件的保存时间,从默认的7天改成14天SQL> show parameter controlSQL> alter system set control_file_record_keep_time=14 scope=both; 2. RMAN 参数:开启控制文件的自动备份,开启之后在数据库备份或者数据文件(比如添加数据文件)有修改的时候都会自动备份控制文件和spfile文件。RMAN> CONFIGURE CONTROLFILE AUTOBACKUP原创 2011-04-08 10:54:00 · 365 阅读 · 0 评论 -
Nocatalog下的RMAN全备SHELL脚本
<br />在执行脚本之前,先修改几个参数值:<br />修改控制文件的保存时间,从默认的7天改成14天<br />SQL> show parameter control<br />SQL> alter system set control_file_record_keep_time=14 scope=both; <br />开启控制文件的自动备份,开启之后在数据库备份或者数据文件(比如添加数据文件)有修改的时候都会自动备份控制文件和spfile文件。<br />configure controlfile原创 2011-04-08 11:44:00 · 514 阅读 · 0 评论