CentOS+Oracle19C+DG主从问题(高手请进)

[lg868]

allocated channel: prmy1
channel prmy1: SID=269 device type=DISK

allocated channel: prmy2
channel prmy2: SID=399 device type=DISK

allocated channel: prmy3
channel prmy3: SID=18 device type=DISK

allocated channel: prmy4
channel prmy4: SID=145 device type=DISK

allocated channel: stby
channel stby: SID=263 device type=DISK

Starting Duplicate Db at 19-FEB-20

contents of Memory Script:
{
backup as copy reuse
passwordfile auxiliary format '/u01/app/oracle19c/product/19.3.0/dbhome_1/dbs/orapwplm1' ;
}
executing Memory Script

Starting backup at 19-FEB-20
Finished backup at 19-FEB-20

contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle19c/oradata/PLM1/control01.ctl';
restore clone primary controlfile to '/u01/app/oracle19c/oradata/PLM1/control02.ctl' from
'/u01/app/oracle19c/oradata/PLM1/control01.ctl';
}
executing Memory Script

Starting backup at 19-FEB-20
channel prmy1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle19c/product/19.3.0/dbhome_1/dbs/snapcf_plm1.f tag=TAG20200219T225317
channel prmy1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 19-FEB-20

Starting restore at 19-FEB-20

channel stby: copied control file copy
Finished restore at 19-FEB-20

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

contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle19c/oradata/PLM1/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle19c/oradata/PLM1/system01.dbf";
set newname for datafile 3 to
"/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf";
set newname for datafile 4 to
"/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf";
set newname for datafile 7 to
"/u01/app/oracle19c/oradata/PLM1/users01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle19c/oradata/PLM1/system01.dbf" datafile
3 auxiliary format
"/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf" datafile
4 auxiliary format
"/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf" datafile
7 auxiliary format
"/u01/app/oracle19c/oradata/PLM1/users01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle19c/oradata/PLM1/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 19-FEB-20
channel prmy1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle19c/oradata/PLM1/system01.dbf
channel prmy2: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf
channel prmy3: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf
channel prmy4: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle19c/oradata/PLM1/users01.dbf
output file name=/u01/app/oracle19c/oradata/PLM1/users01.dbf tag=TAG20200219T225326
channel prmy4: datafile copy complete, elapsed time: 00:00:01
output file name=/u01/app/oracle19c/oradata/PLM1/system01.dbf tag=TAG20200219T225326
channel prmy1: datafile copy complete, elapsed time: 00:00:15
output file name=/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf tag=TAG20200219T225326
channel prmy2: datafile copy complete, elapsed time: 00:00:15
output file name=/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf tag=TAG20200219T225326
channel prmy3: datafile copy complete, elapsed time: 00:00:15
Finished backup at 19-FEB-20

sql statement: alter system archive log current

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1032821622 file name=/u01/app/oracle19c/oradata/PLM1/system01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1032821622 file name=/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1032821622 file name=/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1032821622 file name=/u01/app/oracle19c/oradata/PLM1/users01.dbf
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

RMAN-05535: warning: All redo log files were not defined properly.
Finished Duplicate Db at 19-FEB-20
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: stby


上面是错误信息

这个是主initplm1_stby.ora
plm1.__data_transfer_cache_size=0
plm1.__db_cache_size=587202560
plm1.__inmemory_ext_roarea=0
plm1.__inmemory_ext_rwarea=0
plm1.__java_pool_size=16777216
plm1.__large_pool_size=16777216
plm1.__oracle_base='/u01/app/oracle19c'#ORACLE_BASE set from environment
plm1.__pga_aggregate_target=637534208
plm1.__sga_target=956301312
plm1.__shared_io_pool_size=50331648
plm1.__shared_pool_size=268435456
plm1.__streams_pool_size=0
plm1.__unified_pga_pool_size=0
*.audit_file_dest='/u01/app/oracle19c/admin/plm1/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/u01/app/oracle19c/oradata/PLM1/control01.ctl','/u01/app/oracle19c/oradata/PLM1/control02.ctl'
*.db_block_size=8192
*.db_name='plm1'
*.diagnostic_dest='/u01/app/oracle19c'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=plm1XDB)'
*.fal_client='PLM1'
*.fal_server='PLM1_STBY'
*.local_listener='LISTENER_PLM1'
*.log_archive_config='dg_config=(plm1,plm1_stby)'
*.log_archive_dest_1='LOCATION=/u01/app/oracle19c/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=plm1'
*.log_archive_dest_2='service=plm1_stby async valid_for=(online_logfile,primary_role) db_unique_name=plm1_stby'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='ENABLE'
*.memory_target=1507m
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.processes=320
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.DB_FILE_NAME_CONVERT=('/u01/app/oracle19c/oradata/PLM1/','/u01/app/oracle19c/oradata/PLM1/')
*.LOG_FILE_NAME_CONVERT=('/u01/app/oracle19c/oradata/PLM1/','/u01/app/oracle19c/oradata/PLM1/')


这个是从initplm1_stby.ora
plm1.__pga_aggregate_target=637534208
plm1.__sga_target=956301312
plm1.__shared_io_pool_size=50331648
plm1.__shared_pool_size=268435456
plm1.__streams_pool_size=0
plm1.__unified_pga_pool_size=0
*.audit_file_dest='/u01/app/oracle19c/admin/plm1/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/u01/app/oracle19c/oradata/PLM1/control01.ctl','/u01/app/oracle19c/oradata/PLM1/control02.ctl'
*.db_block_size=8192
*.db_name='plm1'
*.db_unique_name='plm1_stby'
*.diagnostic_dest='/u01/app/oracle19c'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=plm1XDB)'
*.fal_client='PLM1_STBY'
*.fal_server='PLM1'
*.local_listener='LISTENER_PLM1'
*.log_archive_config='dg_config=(plm1,plm1_stby)'
*.log_archive_dest_1='LOCATION=/u01/app/oracle19c/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=plm1_stby'
*.log_archive_dest_2='service=plm1 async valid_for=(online_logfile,primary_role) db_unique_name=plm1'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='ENABLE'
*.db_unique_name='plm1'
*.memory_target=1507m
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.processes=320
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.DB_FILE_NAME_CONVERT=('/u01/app/oracle19c/oradata/PLM1/','/u01/app/oracle19c/oradata/PLM1/')
*.LOG_FILE_NAME_CONVERT=('/u01/app/oracle19c/oradata/PLM1/','/u01/app/oracle19c/oradata/PLM1/')

请问大神们，哪里错了，我创建的“log7a.log”，”log8a.log“，”log9a.log“，”log10a.log“无法同步到从服务器的PLM1文件夹中，
select group#,sequence#,status, bytes/1024/1024 from v$standby_log;确能查到

[天凯科技]

检查一下STANDBY_FILE_MANAGEMENT=AUTO 这个参数是否设置了，另外检查一下备端的文件夹是否有权限，关于ADG在线搭建，可参考https://dbs-service.cn/a/113.html