Rman 实现oracle11g数据库clone

最新推荐文章于 2021-04-03 08:42:03 发布
最新推荐文章于 2021-04-03 08:42:03 发布
阅读量181 收藏
点赞数
文章标签： 数据库

Rman clone数据库的文档看了好几次了，就是没时间做，今天试试看：

cd $ORACLE_HOME/dbs

cp initnqaddite.ora initclone.ora

cp orapwnqaddite orapwclone 或者

orapwd file=$ORACLE_HOME/dbs/orapwclone password=clone entries=4

修改initclone.ora

[@more@]

手动替换nqaddite 成 clone vi 执行 :%s/nqaddite/clone/g

或者 perl -p -i -e 's/nqaddite/clone/g' initclone.ora

添加到参数文件里面

*.db_file_name_convert = ('nqaddite','clone')
*.log_file_name_convert = ('nqaddite','clone')

nomount启动clone数据库实例

export ORACLE_SID=clone

sqlplus "/ as sysdba" <

--create spfile from pfile;

startup nomount;

exit;

EOF

执行clone :

RMAN> run{
2> ALLOCATE auxiliary channel d1 device TYPE DISK;
3> duplicate target DATABASE TO "CLONE";
4> }
allocated channel: d1
channel d1: SID=152 device type=DISK
Starting Duplicate Db at 01-AUG-08
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/01/2008 07:24:16
RMAN-20208: UNTIL CHANGE is before RESETLOGS change
看一下数据库是否归档没有归档，关闭数据库，修改数据库启动参数加入：
*.log_archive_dest_1='LOCATION=/oracle/oradata/nqaddite/archive'
create spfile from pfile;
startup mount;
alter database archivelog;
alter database open;
再执行clone还是不行
RMAN> run{
2> SET UNTIL logseq 1583 thread 1;
3> ALLOCATE auxiliary channel d1 TYPE DISK;
4> duplicate target DATABASE TO "CLONE";
5> }
executing command: SET until clause
allocated channel: d1
channel d1: SID=152 device type=DISK
Starting Duplicate Db at 01-AUG-08
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/01/2008 07:24:24
RMAN-20208: UNTIL CHANGE is before RESETLOGS change
RMAN> run{
2> SET UNTIL scn 946655988;
3> ALLOCATE auxiliary channel d1 TYPE DISK;
4> duplicate target DATABASE TO "CLONE";
5> }
executing command: SET until clause
allocated channel: d1
channel d1: SID=152 device type=DISK
Starting Duplicate Db at 01-AUG-08
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/01/2008 07:24:44
RMAN-06457: UNTIL SCN (946655988) is ahead of last SCN in archived logs ()
怎么试都不行
我也执行数据库备份先
备份完再执行还是一样的错误。
看了一下归档日志目录好像没有日志 ，切换一下日志试试
[oracle@nq-data-center nqaddite]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Aug 1 07:28:49 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system switch logfile ;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oradata/nqaddite/archive
Oldest online log sequence 1581
Next log sequence to archive 1583
Current log sequence 1583
再执行clone试试 ， 这回成功了
RMAN> run{
2> SET UNTIL logseq 1583 thread 1;
3> ALLOCATE auxiliary channel d1 TYPE DISK;
4> duplicate target DATABASE TO "CLONE";
5> }
executing command: SET until clause
allocated channel: d1
channel d1: SID=152 device type=DISK
Starting Duplicate Db at 01-AUG-08
contents of Memory Script:
{
set until scn 946741401;
set newname for datafile 1 to
"/oracle/oradata/clone/system01.dbf";
set newname for datafile 2 to
"/oracle/oradata/clone/sysaux01.dbf";
set newname for datafile 3 to
"/oracle/oradata/clone/undotbs01.dbf";
set newname for datafile 4 to
"/oracle/oradata/clone/users01.dbf";
set newname for datafile 5 to
"/oracle/oradata/clone/example01.dbf";
set newname for datafile 6 to
"/oracle/oradata/clone/ADDITEM.dbf";
set newname for datafile 7 to
"/oracle/oradata/clone/ADDITEM2.dbf";
set newname for datafile 8 to
"/oracle/oradata/clone/ADDITEM_INDEX.dbf";
set newname for datafile 9 to
"/oracle/oradata/clone/ADDITEM_INDEX2.dbf";
set newname for datafile 10 to
"/oracle/oradata/clone/ADDITEM_INDEX3.dbf";
set newname for datafile 11 to
"/oracle/oradata/clone/ADDITEM3.dbf";
set newname for datafile 12 to
"/oracle/oradata/clone/ADDFILE.dbf";
set newname for datafile 13 to
"/oracle/oradata/clone/ADDITEM4.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 01-AUG-08
channel d1: starting datafile backup set restore
channel d1: specifying datafile(s) to restore from backup set
channel d1: restoring datafile 00001 to /oracle/oradata/clone/system01.dbf
channel d1: restoring datafile 00002 to /oracle/oradata/clone/sysaux01.dbf
channel d1: restoring datafile 00003 to /oracle/oradata/clone/undotbs01.dbf
channel d1: restoring datafile 00004 to /oracle/oradata/clone/users01.dbf
channel d1: restoring datafile 00005 to /oracle/oradata/clone/example01.dbf
channel d1: restoring datafile 00006 to /oracle/oradata/clone/ADDITEM.dbf
channel d1: restoring datafile 00007 to /oracle/oradata/clone/ADDITEM2.dbf
channel d1: restoring datafile 00008 to /oracle/oradata/clone/ADDITEM_INDEX.dbf
channel d1: restoring datafile 00009 to /oracle/oradata/clone/ADDITEM_INDEX2.dbf
channel d1: restoring datafile 00010 to /oracle/oradata/clone/ADDITEM_INDEX3.dbf
channel d1: restoring datafile 00011 to /oracle/oradata/clone/ADDITEM3.dbf
channel d1: restoring datafile 00012 to /oracle/oradata/clone/ADDFILE.dbf
channel d1: restoring datafile 00013 to /oracle/oradata/clone/ADDITEM4.dbf
channel d1: reading from backup piece /oracle/flash_recovery_area/NQADDITEM/backupset/2008_08_01/o1_mf_nnndf_TAG20080801T070607_494kcb1w_.bkp
channel d1: piece handle=/oracle/flash_recovery_area/NQADDITEM/backupset/2008_08_01/o1_mf_nnndf_TAG20080801T070607_494kcb1w_.bkp tag=TAG20080801T070607
channel d1: restored backup piece 1
channel d1: restore complete, elapsed time: 00:05:59
Finished restore at 01-AUG-08
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CLONE" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 ( '/oracle/oradata/clone/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oracle/oradata/clone/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oracle/oradata/clone/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oracle/oradata/clone/system01.dbf'
CHARACTER SET ZHS16GBK

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=661592112 file name=/oracle/oradata/clone/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=661592112 file name=/oracle/oradata/clone/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=661592112 file name=/oracle/oradata/clone/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=661592112 file name=/oracle/oradata/clone/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=661592112 file name=/oracle/oradata/clone/ADDITEM.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=661592112 file name=/oracle/oradata/clone/ADDITEM2.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=661592112 file name=/oracle/oradata/clone/ADDITEM_INDEX.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=661592112 file name=/oracle/oradata/clone/ADDITEM_INDEX2.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=661592112 file name=/oracle/oradata/clone/ADDITEM_INDEX3.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=661592112 file name=/oracle/oradata/clone/ADDITEM3.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=661592112 file name=/oracle/oradata/clone/ADDFILE.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=661592112 file name=/oracle/oradata/clone/ADDITEM4.dbf
contents of Memory Script:
{
set until scn 946741401;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 01-AUG-08
starting media recovery
archived log for thread 1 with sequence 1582 is already on disk as file /oracle/oradata/nqaddite/archive/1_1582_649874090.dbf
archived log file name=/oracle/oradata/nqaddite/archive/1_1582_649874090.dbf thread=1 sequence=1582
media recovery complete, elapsed time: 00:00:01
Finished recover at 01-AUG-08
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount ;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 217157632 bytes
Fixed Size 2142976 bytes
Variable Size 159386880 bytes
Database Buffers 50331648 bytes
Redo Buffers 5296128 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CLONE" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 ( '/oracle/oradata/clone/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oracle/oradata/clone/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oracle/oradata/clone/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oracle/oradata/clone/system01.dbf'
CHARACTER SET ZHS16GBK

contents of Memory Script:
{
set newname for tempfile 1 to
"/oracle/oradata/clone/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/oracle/oradata/clone/sysaux01.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/undotbs01.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/users01.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/example01.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/ADDITEM.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/ADDITEM2.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/ADDITEM_INDEX.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/ADDITEM_INDEX2.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/ADDITEM_INDEX3.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/ADDITEM3.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/ADDFILE.dbf";
catalog clone datafilecopy "/oracle/oradata/clone/ADDITEM4.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /oracle/oradata/clone/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/sysaux01.dbf RECID=1 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/undotbs01.dbf RECID=2 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/users01.dbf RECID=3 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/example01.dbf RECID=4 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/ADDITEM.dbf RECID=5 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/ADDITEM2.dbf RECID=6 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/ADDITEM_INDEX.dbf RECID=7 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/ADDITEM_INDEX2.dbf RECID=8 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/ADDITEM_INDEX3.dbf RECID=9 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/ADDITEM3.dbf RECID=10 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/ADDFILE.dbf RECID=11 STAMP=661592126
cataloged datafile copy
datafile copy file name=/oracle/oradata/clone/ADDITEM4.dbf RECID=12 STAMP=661592126
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=661592126 file name=/oracle/oradata/clone/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=661592126 file name=/oracle/oradata/clone/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=661592126 file name=/oracle/oradata/clone/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=661592126 file name=/oracle/oradata/clone/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=661592126 file name=/oracle/oradata/clone/ADDITEM.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=661592126 file name=/oracle/oradata/clone/ADDITEM2.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=661592126 file name=/oracle/oradata/clone/ADDITEM_INDEX.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=661592126 file name=/oracle/oradata/clone/ADDITEM_INDEX2.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=661592126 file name=/oracle/oradata/clone/ADDITEM_INDEX3.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=661592126 file name=/oracle/oradata/clone/ADDITEM3.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=661592126 file name=/oracle/oradata/clone/ADDFILE.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=661592126 file name=/oracle/oradata/clone/ADDITEM4.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 01-AUG-08
RMAN>
修改 listener.ora tnsnames.ora 加入 clone 重启监听器就好了。
参考：

如果需要配置dbconsole的话
[oracle@nq~]$ emca -config dbcontrol db -repos recreate

EMCA 开始于 2008-8-1 9:02:05
EM Configuration Assistant, 11.1.0.5.0 正式版
版权所有 (c) 2003, 2005, Oracle。保留所有权利。

输入以下信息:
数据库 SID: clone
监听程序端口号: 1521
SYS 用户的口令:
DBSNMP 用户的口令:
SYSMAN 用户的口令:
SYSMAN 用户的口令: 通知的电子邮件地址 (可选): heming@netqin.com
通知的发件 (SMTP) 服务器 (可选): mail.netqin.com
-----------------------------------------------------------------

已指定以下设置

数据库 ORACLE_HOME ................ /oracle/product/11.1.0/11g

本地主机名 ................ nq-data-center
监听程序端口号 ................ 1521
数据库 SID ................ clone
通知的电子邮件地址 ............... heming@netqin.com
通知的发件 (SMTP) 服务器 ............... mail.netqin.com

-----------------------------------------------------------------
是否继续? [是(Y)/否(N)]: y
2008-8-1 9:02:54 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 /oracle/cfgtoollogs/emca/clone/emca_2008_08_01_09_02_05.log。
2008-8-1 9:02:55 oracle.sysman.emcp.EMReposConfig invoke
信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...

2008-8-1 9:10:49 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功删除资料档案库
2008-8-1 9:10:49 oracle.sysman.emcp.EMReposConfig createRepository
信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...
2008-8-1 9:17:43 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功创建资料档案库
2008-8-1 9:17:48 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
信息: 正在将配置数据上载到 EM 资料档案库 (此操作可能需要一段时间)...
2008-8-1 9:18:36 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功上载配置数据
2008-8-1 9:18:39 oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
信息: 软件库已配置成功。
2008-8-1 9:18:39 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
信息: 正在部署预配档案...
2008-8-1 9:18:48 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
信息: 预配档案部署成功。
2008-8-1 9:18:48 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
信息: 正在保护 Database Control (此操作可能需要一段时间)...
2008-8-1 9:19:02 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
信息: 已成功保护 Database Control。
2008-8-1 9:19:02 oracle.sysman.emcp.util.DBControlUtil startOMS
信息: 正在启动 Database Control (此操作可能需要一段时间)...
2008-8-1 9:19:31 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: 已成功启动 Database Control
2008-8-1 9:19:31 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: >>>>>>>>>>> Database Control URL 为 https://nq-data-center:5500/em

应改是 emca -config dbcontrol db -repos create 快一些

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9614263/viewspace-1008219/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9614263/viewspace-1008219/

cl3011
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Legato备份Oracle数据库rman脚本
12-15
Legato是一种专业的备份解决方案，常用于企业级的数据库管理，如Oracle数据库。RMAN（Recovery Manager）是Oracle提供的一种强大的数据库备份和恢复工具。在本文中，我们将深入探讨如何使用Legato配合RMAN来备份...
Oracle Database 12c 数据库32个新特性与案例总结
11-19
Oracle Database 12c是Oracle公司推出的一个重要版本，它带来了许多创新特性和改进，旨在提升数据库性能、可扩展性和管理效率。以下是其中32个关键新特性的概述，结合实际案例进行分析： 1. **多租户架构...
oracle 进去rman,Oracle通过rman进行克隆
weixin_34332352的博客
04-03 105
一. 安装规划IPROLE192.168.1.235克隆对象192.168.1.221克隆库二. 备库创建相应的dump文件夹# 在主库查询对应的dump目录selectname, valuefromv$parameterwhere name in ('audit_file_dest','background_dump_dest','control_files','core_dump_dest',...
Oracle技术之通过RMAN 克隆数据库
weixin_33701617的博客
07-08 101
目的：在同一台机器上用rman 克隆库环境：RedHat 4 + Oracle 10g主库库名：db01克隆库名： clonedb1、主库db01 ，用rman进行备份（datafile、controlfile、archivelog file）08:49:43 SQL> show parameter name ;NAME ...
使用RMAN在线clone Oracle EBS
文档搬运工
04-13 572
-- 使用RMAN在线备份数据，然后在另外一台（同一台）上使用RAM备份进行clone EBS。 EBS R12.1.3 ，Oracle SID Test，克隆后Oracle Sid 为DEV 。 -- 主要步骤 1 数据库层和apps层预克隆 2 RMAN对数据库进行备份 3 删除掉数据文件、控制文件、online redo 4 RMAN对数据库进行恢复（恢复到原来的位置，也可以恢复到其他位置...
RMAN冷拷贝搭建dataguard物理备库
数据之路-忆梦前程
11-08 1154
1.配置主库环境 启用归档 SQL> alter system set log_archive_dest_1='location=/oracle/archive_log/arch_%t_%s_%r.arc' scope=spfile; 系统已更改。 SQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='arch_%t_%s_%r.arc' scope=
Oracle11g 和 Oracle12c rman克隆数据库
weixin_34268310的博客
04-25 440
一、oracle12c rman克隆步骤1、生成环境信息查询1）实例状态信息2）数据文件信息3）日志文件信息4）参数文件信息2、测试环境准备：0）数据库软件安装和配置1）pfile参数文件 2）密码文件 3）创建相关的目录 4）配置静态监听和TNS 5）启动中间件库到nomount 6）验证用户密码 7）生成用spfile启动。8）rman克隆准备9）执行rman克隆二、...
Oracle数据库数据迁移整理.pdf
11-04
Oracle数据库数据迁移是一个复杂的过程，涉及多个步骤和组件，确保数据在迁移过程中的一致性、完整性和可用性。以下是对标题和描述中所提及的知识点的详细解释： 1. **概述**： - 迁移的目标是将一个Oracle数据库...
oracle恢复表delete/truncate/drop的方法总结
congse3359的博客
02-02 301
在有rman备份的情况下,数据库级别,文件级别,块级别这种物理类的恢复相对方便,而因为用户误操作或业务bug引起的逻辑类恢复反而有时耗费大量时间. 以下是对表delete/truncate/drop后进行恢复的一些方法...
rman实现oracle数据库迁移
红磊的专栏
09-07 3815
1.    综述... 12.    原库备份... 22.1.     创建备份集目录：... 22.2.     创建Rman用户... 22.3.     备份数据库... 23.    准备目标服务器环境（安装Oracle）... 33.1.     配置目标服务器环境... 3安装缺失rpm.. 3检查HostName. 3配置系统内核参数... 33.2.     创建Oracle用户... 43.3.     配置Oracle用户环境... 4创建相应目录... 4修改Oracle启动环境..
使用RMAN duplicate对源库的某个incarnation进行duplicate操作时遇到的问题
cuiqiong6888的博客
07-05 307
按照文档的介绍，使用duplicate database targetdb incarnation YYY to dupdb可以针对targetdb的某个incarnation进行duplicate，但实际测试下来却有些问题 ...
Oracle Study之--Oracle 11gR2通过RMAN克隆数据库
天涯客*Blog
03-25 2225
Oracle Study之--Oracle 11gR2通过RMAN克隆数据库 Purpose of Database Duplication A duplicate database is useful for a variety of purposes, most of which involve testing. You can perform the following tasks
RMAN-06054: 介质恢复正在请求未知的线程 1 序列 105776 的归档日志以及起始 SCN 62897768726
鲨鱼胃的博客
10-10 5404
问题描述 在做异机恢复（RAC->单实例）的时候，recover database时遇到如下报错： RMAN-03002: recover 命令 (在 09/30/2019 08:36:48 上) 失败 RMAN-06054: 介质恢复正在请求未知的线程 1 序列 105776 的归档日志以及起始 SCN 62897768726 在11g官方文档error messages中对错误描述如下：...
RMAN Catalog 和 Nocatalog 的区别
热门推荐
David Dai -- Focus on Oracle
06-02 3万+
一．Nocatalog Nocatalog方式 就是用control file作为catalog，每一次备份都要往控制文件里面写好多备份信息，控制文件里面会有越来越多的备份信息。因此，当使用rman nocatalog方式备份时，备份controlfile是非常重要的。由于nocatalog时利用controlfile存放备份信息，建议将Oracle参数文件中的CONTROL_FILE_RECORD_KEEP_TIME值加大（缺省为7天）, 参数在$ORACLE_HOME/dbs/initSID.ora中，
ORA-600 [2662] Block SCN is ahead of Current SCN [ID 28929.1]
David Dai -- Focus on Oracle
12-29 1万+
<br /> <br />ORA-600 [2662] "Block SCN is ahead of Current SCN" [ID 28929.1]<br /> <br />Modified 09-DEC-2010     Type REFERENCE     Status PUBLISHED<br /> <br /> <br /> <br /> <br />Note: For additional ORA-600 related information please read Note:146580.
RMAN-06564错误的原因及解决办法
u014429186的博客
11-29 2991
遭遇RMAN-06564错误，如下： ? 1 2 3 4 5 6 7 8 9 10 11 12 RMAN> restore spfile from autobackup; Starting restore at 01-NOV-16 using target database control file inst
一个残缺的Oracle rman备份规复参考示例
weixin_30586085的博客
03-07 73
前导发轫：赛迪网作者：Benson 残缺的Oracle rman备份规复参考示例： 　 1、建rman库作为repository $more createrman_db1.sh set echo on spool makedb1.log create database rman datafile '/export/home/o...
Oracle 10g数据库RMAN备份与恢复详解
Oracle 10g版本引入了恢复管理器（RMAN），这是一个强大的备份和恢复工具，旨在提供高效且可靠的数据库保护方案。RMAN以其操作系统无关性而著称，这意味着用户可以在多种操作系统环境下执行相同的备份和恢复操作，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值