DG重做备库步骤.docx
免费下载
1
、备库
:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; --
取
消日志应用
SQL> SHUTDOWN IMMEDIATE; --
关闭数据库
SQL> startup nomount; --
启动备库到
nomount
状态
2
、
rman
连接主库和备库，如连接时报错，则在后边添加参数
nocatalog
[oracle@standby dbs]$ rman target sys/oracle@orcl_pd auxiliary sys/oracle@orcl_st
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Nov 8 16:10:25 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1373955189)
connected to auxiliary database: ORCL (not mounted)
3
、复制数据库
RMAN> duplicate target database for standby from active database ;
在执行
duplicate
的时候，如果源库和目标库目录相同，那么在
duplicate
时，需要加上
nofilenamecheck
，如下：
RMAN> duplicate target database for standby from active database nofilenamecheck;
--
执行结果如下，没有明显报错。
===================================================================
==========================
Starting Duplicate Db at 22-APR-22
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=146 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/opt/app/dbhome/dbs/orapwmydb' auxiliary format
'/opt/app/dbhome/dbs/orapwmydb' ;
}
executing Memory Script
Starting backup at 22-APR-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=203 device type=DISK
Finished backup at 22-APR-22
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format
'/opt/app/MYDB/control/control01.ctl';
restore clone controlfile to '/opt/app/MYDB/control/control02.ctl' from
'/opt/app/MYDB/control/control01.ctl';
}
executing Memory Script
Starting backup at 22-APR-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/opt/app/dbhome/dbs/snapcf_mydb.f tag=TAG20220422T172526
RECID=13 STAMP=1102699526
of 10
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论