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;確能查到
uj5u.com熱心網友回復：
檢查一下STANDBY_FILE_MANAGEMENT=AUTO 這個引數是否設定了，另外檢查一下備端的檔案夾是否有權限，關于ADG在線搭建，可參考https://dbs-service.cn/a/113.html轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/18038.html
標籤：高級技術
下一篇：SQL問題