oracle 19c datagruad复制备库RMAN-05535

最新推荐文章于 2024-04-10 15:11:43 发布

Oracledddbaaa

最新推荐文章于 2024-04-10 15:11:43 发布

阅读量2.1k

点赞数 1

分类专栏： RMAN 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/qq_37124497/article/details/127774567

版权

RMAN 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

[redhat8:oracle]:/u01>rman target sys/oracle123@wqjdb auxiliary sys/oracle123@wqjdbadg

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Nov 10 01:05:32 2022
Version 19.14.0.0.0

connected to target database: WQJDB (DBID=1538044496)
connected to auxiliary database: WQJDB (not mounted)

RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
Starting Duplicate Db at 10-NOV-22
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=254 device type=DISK
current log archived

contents of Memory Script:
{
backup as copy reuse
passwordfile auxiliary format ‘/u01/app/oracle/product/19c/db_1/dbs/orapwwqjdbadg’ ;
}
executing Memory Script

Starting backup at 10-NOV-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=38 device type=DISK
Finished backup at 10-NOV-22

contents of Memory Script:
{
restore clone from service ‘wqjdb’ standby controlfile;
}
executing Memory Script

Starting restore at 10-NOV-22
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 wqjdb
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/control01.ctl
Finished restore at 10-NOV-22

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 (datafile) file name /u01/app/oracle/oradata/WQJDB/system01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/WQJDB/sysaux01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/WQJDB/undotbs01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/WQJDB/users01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /stage/datafile01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/WQJDB/temp01.dbf conflicts with a file used by the target database

contents of Memory Script:
{
set newname for tempfile 1 to
“/u01/app/oracle/oradata/WQJDB/temp01.dbf”;
switch clone tempfile all;
set newname for datafile 1 to
“/u01/app/oracle/oradata/WQJDB/system01.dbf”;
set newname for datafile 2 to
“/u01/app/oracle/oradata/WQJDB/sysaux01.dbf”;
set newname for datafile 3 to
“/u01/app/oracle/oradata/WQJDB/undotbs01.dbf”;
set newname for datafile 4 to
“/u01/app/oracle/oradata/WQJDB/users01.dbf”;
set newname for datafile 5 to
“/stage/datafile01.dbf”;
restore
from nonsparse from service
‘wqjdb’ clone database
;
sql ‘alter system archive log current’;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/WQJDB/temp01.dbf 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 10-NOV-22
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 wqjdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/WQJDB/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service wqjdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/WQJDB/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service wqjdb
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/oradata/WQJDB/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service wqjdb
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/WQJDB/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service wqjdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /stage/datafile01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 10-NOV-22

sql statement: alter system archive log current
current log archived

contents of Memory Script:
{
restore clone force from service ‘wqjdb’
archivelog from scn 1132743;
switch clone datafile all;
}
executing Memory Script

Starting restore at 10-NOV-22
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 wqjdb
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=45
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service wqjdb
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=46
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 10-NOV-22

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1120352760 file name=/u01/app/oracle/oradata/WQJDB/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=1120352760 file name=/u01/app/oracle/oradata/WQJDB/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=1120352760 file name=/u01/app/oracle/oradata/WQJDB/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=1120352760 file name=/u01/app/oracle/oradata/WQJDB/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=1120352760 file name=/stage/datafile01.dbf

contents of Memory Script:
{
set until scn 1132875;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 10-NOV-22
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 45 is already on disk as file /u01/app/oracle/archivelog/1_45_1117343440.dbf
archived log for thread 1 with sequence 46 is already on disk as file /u01/app/oracle/archivelog/1_46_1117343440.dbf
archived log file name=/u01/app/oracle/archivelog/1_45_1117343440.dbf thread=1 sequence=45
archived log file name=/u01/app/oracle/archivelog/1_46_1117343440.dbf thread=1 sequence=46
media recovery complete, elapsed time: 00:00:00
Finished recover at 10-NOV-22

contents of Memory Script:
{
delete clone force archivelog all;
}
executing Memory Script

released channel: ORA_DISK_1
released channel: ORA_AUX_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=38 device type=DISK
deleted archived log
archived log file name=/u01/app/oracle/archivelog/1_45_1117343440.dbf RECID=1 STAMP=1120352758
deleted archived log
archived log file name=/u01/app/oracle/archivelog/1_46_1117343440.dbf RECID=2 STAMP=1120352759
Deleted 2 objects

RMAN-05535: warning: All redo log files were not defined properly.
RMAN-05535: warning: All redo log files were not defined properly.
RMAN-05535: warning: All redo log files were not defined properly.
RMAN-05535: warning: All redo log files were not defined properly.
RMAN-05535: warning: All redo log files were not defined properly.
RMAN-05535: warning: All redo log files were not defined properly.
Finished Duplicate Db at 10-NOV-22

操作环境、软件版本等信息
redhat8.4
oracle19.3尝试过的解决方法
1.两边路径一致设置转换参数报错依旧。

SQL> show parameter convert

NAME				     TYPE			       VALUE
------------------------------------ --------------------------------- ------------------------------
db_file_name_convert		     string			       /u01/app/oracle/oradata/WQJDB/
								         , /u01/app/oracle/oradata/WQJDB/, /stage/, /stage/
log_file_name_convert		     string			       /u01/app/oracle/oradata/WQJDB/
								          , /u01/app/oracle/oradata/WQJDB/

2.设置standby_file_management 为MANUAL也是报错
standby_file_management string MANUAL
RMAN-05535: warning: All redo log files were not defined properly.

# 最终解决方案：
duplicate完之后
检查生产
SQL> select group#,member from v$logfile;


SQL> select group#,member from v$logfile;

    GROUP# MEMBER
---------- --------------------------------------------------
	 1 /u01/app/oracle/oradata/WQJDB/redo01.log
	 2 /u01/app/oracle/oradata/WQJDB/redo02.log
	 3 /u01/app/oracle/oradata/WQJDB/redo03.log
	 4 /u01/app/oracle/oradata/WQJDB/standlog1.log
	 5 /u01/app/oracle/oradata/WQJDB/standlog2.log
	 6 /u01/app/oracle/oradata/WQJDB/standlog3.log

6 rows selected.

检查备库：

SQL> select member from v$logfile;


/u01/app/oracle/product/19c/db_1/dbs/broken0
/u01/app/oracle/product/19c/db_1/dbs/broken1
/u01/app/oracle/product/19c/db_1/dbs/broken2
/u01/app/oracle/product/19c/db_1/dbs/broken3
/u01/app/oracle/product/19c/db_1/dbs/broken4
/u01/app/oracle/product/19c/db_1/dbs/broken5

6 rows selected.

SOLUTION :
在备库执行：execute the rename like the following:

alter database rename file ‘/u01/app/oracle/product/19c/db_1/dbs/broken0’ to ‘/u01/app/oracle/oradata/WQJDB/redo01.log’;
alter database rename file ‘/u01/app/oracle/product/19c/db_1/dbs/broken1’ to ‘/u01/app/oracle/oradata/WQJDB/redo02.log’;
alter database rename file ‘/u01/app/oracle/product/19c/db_1/dbs/broken2’ to ‘/u01/app/oracle/oradata/WQJDB/redo03.log’;
alter database rename file ‘/u01/app/oracle/product/19c/db_1/dbs/broken3’ to ‘/u01/app/oracle/oradata/WQJDB/standlog1.log’;
alter database rename file ‘/u01/app/oracle/product/19c/db_1/dbs/broken4’ to ‘/u01/app/oracle/oradata/WQJDB/standlog2.log’;
alter database rename file ‘/u01/app/oracle/product/19c/db_1/dbs/broken5’ to ‘/u01/app/oracle/oradata/WQJDB/standlog3.log’;

由于RMAN备份，数据库处于不一致状态，不能直接open，我们先开始物理备库的日志应用：

recover managed standby database using current logfile disconnect;
recover managed standby database cancel;

打开物理备库：
alter database open;
再追加日志，开始恢复
recover managed standby database using current logfile disconnect;
然后检查进程：

SQL> select process,status, GROUP#, SEQUENCE#,block#,blocks from v$managed_standby;

PROCESS 		    STATUS				 GROUP# 			 SEQUENCE#		 BLOCK# 	      BLOCKS
--------------------------- ------------------------------------ -------------------- -------------------- -------------------- --------------------
ARCH			    CLOSING				    4					48		      1 	   4
DGRD			    ALLOCATED				 N/A			    0		      0   
DGRD			    ALLOCATED				 N/A				 0		     0 	      0
ARCH			    CLOSING				  5					49		      1 		  39
ARCH			    CLOSING				 4					50		      1 		   7
ARCH			    CLOSING				 6					47		      1 		1234
RFS			       IDLE				    N/A					 0		      0 		   0
RFS			       IDLE				      3					51		    926 		   1
MRP0			    APPLYING_LOG			N/A		     51		      926 	       409600

9 rows selected.

同步正常。