dg搭建错误

1.duplicate时归档出错

RMAN> duplicate target database for standby from active database doreco                   ver nofilenamecheck;

Starting Duplicate Db at 21-JUL-21
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=765 device type=DISK
current log archived

contents of Memory Script:
{
   backup as copy reuse
   passwordfile auxiliary format  '/u01/app/oracle/product/19.0/db_1/db                   s/orapwvddb'   ;
}
executing Memory Script

Starting backup at 21-JUL-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1530 instance=vddb1 device type=DISK
Finished backup at 21-JUL-21

contents of Memory Script:
{
   sql clone "alter system set  control_files =
  ''/u01/app/oracle/oradata/vddb/VDDB_STD/controlfile/o1_mf_jhhdsqwz_.c                   tl'' comment=
 ''Set by RMAN'' scope=spfile";
   restore clone from service  'vddb' standby controlfile;
}
executing Memory Script

sql statement: alter system set  control_files =   ''/u01/app/oracle/or                   adata/vddb/VDDB_STD/controlfile/o1_mf_jhhdsqwz_.ctl'' comment= ''Set by                    RMAN'' scope=spfile

Starting restore at 21-JUL-21
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service vddb
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:14
output file name=/u01/app/oracle/oradata/vddb/VDDB_STD/controlfile/o1_m                   f_jhhdsqwz_.ctl
Finished restore at 21-JUL-21

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database
RMAN-05158: WARNING: auxiliary (tempfile) file name +DATA/VDDB/TEMPFILE                   /temp.261.1075890571 conflicts with a file used by the target database
RMAN-05529: warning: DB_FILE_NAME_CONVERT resulted in invalid ASM names                   ; names changed to disk group only.

contents of Memory Script:
{
   set newname for tempfile  1 to
 "+DATA";
   switch clone tempfile all;
   set newname for datafile  1 to
 "/u01/app/oracle/oradata/vddb/system.282.1075890349";
   set newname for datafile  3 to
 "/u01/app/oracle/oradata/vddb/sysaux.293.1075890415";
   set newname for datafile  4 to
 "/u01/app/oracle/oradata/vddb/undotbs1.296.1075890441";
   set newname for datafile  5 to
 "/u01/app/oracle/oradata/vddb/undotbs2.292.1075891335";
   set newname for datafile  7 to
 "/u01/app/oracle/oradata/vddb/users.283.1075890443";
   restore
   from  nonsparse   from service
 'vddb'   clone database
   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +DATA in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 21-JUL-21
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service vddb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup s                   et
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/ora                   data/vddb/system.282.1075890349
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:05:06
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service vddb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/orada                 ta/vddb/sysaux.293.1075890415
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:08:46
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service vddb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/vddb/undotbs1.
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:10
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service vddb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/vddb/undotbs2.
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:05
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service vddb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/vddb/users.283
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04
Finished restore at 21-JUL-21

sql statement: alter system archive log current
current log archived

contents of Memory Script:
{
   restore clone force from service  'vddb'
           archivelog from scn  7008830;
   switch clone datafile all;
}
executing Memory Script

Starting restore at 21-JUL-21
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service vddb
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=68
dbms_backup_restore.restoreCancel() failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/21/2021 16:06:36
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-19660: some files in the backup set could not be verified
ORA-19662: archived log thread 1 sequence 68 could not be verified
ORA-19849: error while reading backup piece from service vddb
ORA-19504: failed to create file "+DATA/vddb/archivelogfile/1_68_1075890542.dbf"
ORA-29701: unable to connect to Cluster Synchronization Service

解决方法：

利用rman备份归档文件，到备库上进行恢复

备份语句如下：

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

allocate channel c4 type disk;

backup archivelog all format ‘/u01/app/backup/newrmanbackarchi/ARC_%U.bak’;

release channel c1;

release channel c2;

release channel c3;

release channel c4;

}

run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup archivelog all format '/u01/app/backup/newrmanbackarchi/ARC_%U.bak';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}

 

2 .RMAN-06820: warning: failed to archive current log at primary database

RMAN-06820: warning: failed to archive current log at primary database

解决方法：

[oracle@pg03 admin]$ rman target sys/oracle@single01_std auxiliary sys/oracle@single01_std2 nocatalog

添加nocatalog关键字

说明：

catalog关键字