allocatedchannel:prmy1
channelprmy1:SID=269devicetype=DISK
allocatedchannel:prmy2
channelprmy2:SID=399devicetype=DISK
allocatedchannel:prmy3
channelprmy3:SID=18devicetype=DISK
allocatedchannel:prmy4
channelprmy4:SID=145devicetype=DISK
allocatedchannel:stby
channelstby:SID=263devicetype=DISK
StartingDuplicateDbat19-FEB-20
contentsofMemoryScript:
{
backupascopyreuse
passwordfileauxiliaryformat'/u01/app/oracle19c/product/19.3.0/dbhome_1/dbs/orapwplm1';
}
executingMemoryScript
Startingbackupat19-FEB-20
Finishedbackupat19-FEB-20
contentsofMemoryScript:
{
backupascopycurrentcontrolfileforstandbyauxiliaryformat'/u01/app/oracle19c/oradata/PLM1/control01.ctl';
restorecloneprimarycontrolfileto'/u01/app/oracle19c/oradata/PLM1/control02.ctl'from
'/u01/app/oracle19c/oradata/PLM1/control01.ctl';
}
executingMemoryScript
Startingbackupat19-FEB-20
channelprmy1:startingdatafilecopy
copyingstandbycontrolfile
outputfilename=/u01/app/oracle19c/product/19.3.0/dbhome_1/dbs/snapcf_plm1.ftag=TAG20200219T225317
channelprmy1:datafilecopycomplete,elapsedtime:00:00:01
Finishedbackupat19-FEB-20
Startingrestoreat19-FEB-20
channelstby:copiedcontrolfilecopy
Finishedrestoreat19-FEB-20
contentsofMemoryScript:
{
sqlclone'alterdatabasemountstandbydatabase';
}
executingMemoryScript
sqlstatement:alterdatabasemountstandbydatabase
RMAN-05158:WARNING:auxiliary(datafile)filename/u01/app/oracle19c/oradata/PLM1/system01.dbfconflictswithafileusedbythetargetdatabase
RMAN-05158:WARNING:auxiliary(datafile)filename/u01/app/oracle19c/oradata/PLM1/sysaux01.dbfconflictswithafileusedbythetargetdatabase
RMAN-05158:WARNING:auxiliary(datafile)filename/u01/app/oracle19c/oradata/PLM1/undotbs01.dbfconflictswithafileusedbythetargetdatabase
RMAN-05158:WARNING:auxiliary(datafile)filename/u01/app/oracle19c/oradata/PLM1/users01.dbfconflictswithafileusedbythetargetdatabase
RMAN-05158:WARNING:auxiliary(tempfile)filename/u01/app/oracle19c/oradata/PLM1/temp01.dbfconflictswithafileusedbythetargetdatabase
contentsofMemoryScript:
{
setnewnamefortempfile1to
"/u01/app/oracle19c/oradata/PLM1/temp01.dbf";
switchclonetempfileall;
setnewnamefordatafile1to
"/u01/app/oracle19c/oradata/PLM1/system01.dbf";
setnewnamefordatafile3to
"/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf";
setnewnamefordatafile4to
"/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf";
setnewnamefordatafile7to
"/u01/app/oracle19c/oradata/PLM1/users01.dbf";
backupascopyreuse
datafile1auxiliaryformat
"/u01/app/oracle19c/oradata/PLM1/system01.dbf"datafile
3auxiliaryformat
"/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf"datafile
4auxiliaryformat
"/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf"datafile
7auxiliaryformat
"/u01/app/oracle19c/oradata/PLM1/users01.dbf";
sql'altersystemarchivelogcurrent';
}
executingMemoryScript
executingcommand:SETNEWNAME
renamedtempfile1to/u01/app/oracle19c/oradata/PLM1/temp01.dbfincontrolfile
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
Startingbackupat19-FEB-20
channelprmy1:startingdatafilecopy
inputdatafilefilenumber=00001name=/u01/app/oracle19c/oradata/PLM1/system01.dbf
channelprmy2:startingdatafilecopy
inputdatafilefilenumber=00003name=/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf
channelprmy3:startingdatafilecopy
inputdatafilefilenumber=00004name=/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf
channelprmy4:startingdatafilecopy
inputdatafilefilenumber=00007name=/u01/app/oracle19c/oradata/PLM1/users01.dbf
outputfilename=/u01/app/oracle19c/oradata/PLM1/users01.dbftag=TAG20200219T225326
channelprmy4:datafilecopycomplete,elapsedtime:00:00:01
outputfilename=/u01/app/oracle19c/oradata/PLM1/system01.dbftag=TAG20200219T225326
channelprmy1:datafilecopycomplete,elapsedtime:00:00:15
outputfilename=/u01/app/oracle19c/oradata/PLM1/sysaux01.dbftag=TAG20200219T225326
channelprmy2:datafilecopycomplete,elapsedtime:00:00:15
outputfilename=/u01/app/oracle19c/oradata/PLM1/undotbs01.dbftag=TAG20200219T225326
channelprmy3:datafilecopycomplete,elapsedtime:00:00:15
Finishedbackupat19-FEB-20
sqlstatement:altersystemarchivelogcurrent
contentsofMemoryScript:
{
switchclonedatafileall;
}
executingMemoryScript
datafile1switchedtodatafilecopy
inputdatafilecopyRECID=1STAMP=1032821622filename=/u01/app/oracle19c/oradata/PLM1/system01.dbf
datafile3switchedtodatafilecopy
inputdatafilecopyRECID=2STAMP=1032821622filename=/u01/app/oracle19c/oradata/PLM1/sysaux01.dbf
datafile4switchedtodatafilecopy
inputdatafilecopyRECID=3STAMP=1032821622filename=/u01/app/oracle19c/oradata/PLM1/undotbs01.dbf
datafile7switchedtodatafilecopy
inputdatafilecopyRECID=4STAMP=1032821622filename=/u01/app/oracle19c/oradata/PLM1/users01.dbf
Oracleerrorfromauxiliarydatabase:ORA-01275:OperationRENAMEisnotallowedifstandbyfilemanagementisautomatic.
RMAN-05535:warning:Allredologfileswerenotdefinedproperly.
Oracleerrorfromauxiliarydatabase:ORA-01275:OperationRENAMEisnotallowedifstandbyfilemanagementisautomatic.
RMAN-05535:warning:Allredologfileswerenotdefinedproperly.
Oracleerrorfromauxiliarydatabase:ORA-01275:OperationRENAMEisnotallowedifstandbyfilemanagementisautomatic.
RMAN-05535:warning:Allredologfileswerenotdefinedproperly.
Oracleerrorfromauxiliarydatabase:ORA-01275:OperationRENAMEisnotallowedifstandbyfilemanagementisautomatic.
RMAN-05535:warning:Allredologfileswerenotdefinedproperly.
Oracleerrorfromauxiliarydatabase:ORA-01275:OperationRENAMEisnotallowedifstandbyfilemanagementisautomatic.
RMAN-05535:warning:Allredologfileswerenotdefinedproperly.
Oracleerrorfromauxiliarydatabase:ORA-01275:OperationRENAMEisnotallowedifstandbyfilemanagementisautomatic.
RMAN-05535:warning:Allredologfileswerenotdefinedproperly.
Oracleerrorfromauxiliarydatabase:ORA-01275:OperationRENAMEisnotallowedifstandbyfilemanagementisautomatic.
RMAN-05535:warning:Allredologfileswerenotdefinedproperly.
FinishedDuplicateDbat19-FEB-20
releasedchannel:prmy1
releasedchannel:prmy2
releasedchannel:prmy3
releasedchannel:prmy4
releasedchannel: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_BASEsetfromenvironment
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/archiveVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=plm1'
*.log_archive_dest_2='service=plm1_stbyasyncvalid_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='SIMPLIFIEDCHINESE'
*.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/archiveVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=plm1_stby'
*.log_archive_dest_2='service=plm1asyncvalid_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='SIMPLIFIEDCHINESE'
*.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文件夹中，
selectgroup#,sequence#,status,bytes/1024/1024fromv$standby_log;确能查到
分 -->
|
