ORA-19527: physical standby redo log must be renamed
Error record:
1Percentrman replication database reported an error.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1:'/ u01 Grease appScale oracleGrexoradata Universe pdbUnix redo01.log'
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 2 thread 1:'/ u01Accord oradata online log redo02.log'
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 3 thread 1:'/ u01Accord oradata online log redo03.log'
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 4 thread 0:'/ u01 thread
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 5 thread 0:'/ u01 thread
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 6 thread 0:'/ u01 thread
Solution:
The standby and primary database settings are as follows:-the database needs to be restarted.
Alter system set LOG_FILE_NAME_CONVERT='pdb','pdb' scope=spfile
After modification, rman returns to normal and no error is reported:
Recovery Manager: Release 12.1.0.2.0-Production on Thu Dec 28 00:18:59 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to target database: PDB (DBID=3386854302)
Connected to auxiliary database: PDB (not mounted)
RMAN > 2 > 3 > 4 > 5 >
Starting Duplicate Db at 28-DEC-17
Using target database control file instead of recovery catalog
Allocated channel: ORA_AUX_DISK_1
Channel ORA_AUX_DISK_1: SID=272 device type=DISK
Current log archived
Contents of Memory Script:
{
Backup as copy reuse
Targetfile'/ u01 targetfile'/ u01apapwpdb' auxiliary format
'/ u01apapwpdb` / u01apapwpdb'
}
Executing Memory Script
Starting backup at 28-DEC-17
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID=364 device type=DISK
Finished backup at 28-DEC-17
Contents of Memory Script:
{
Backup as copy current controlfile for standby auxiliary format'/ u01qapplash oracleandoradata'pdbUniverse control01.ctl'
}
Executing Memory Script
Starting backup at 28-DEC-17
Using channel ORA_DISK_1
Channel ORA_DISK_1: starting datafile copy
Copying standby control file
Output file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/snapcf_pdb.f tag=TAG20171228T001903
Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 28-DEC-17
Contents of Memory Script:
{
Sql clone 'alter database mount standby database'
}
Executing Memory Script
Sql statement: alter database mount standby database
Contents of Memory Script:
{
Set newname for tempfile 1 to
"/ u01/app/oracle/oradata/pdb/temp01.dbf"
Switch clone tempfile all
Set newname for datafile 1 to
"/ u01/app/oracle/oradata/pdb/system01.dbf"
Set newname for datafile 3 to
"/ u01/app/oracle/oradata/pdb/sysaux01.dbf"
Set newname for datafile 4 to
"/ u01/app/oracle/oradata/pdb/undotbs01.dbf"
Set newname for datafile 6 to
"/ u01/app/oracle/oradata/pdb/users01.dbf"
Backup as copy reuse
Datafile 1 auxiliary format
"/ u01/app/oracle/oradata/pdb/system01.dbf" datafile
3 auxiliary format
"/ u01/app/oracle/oradata/pdb/sysaux01.dbf" datafile
4 auxiliary format
"/ u01/app/oracle/oradata/pdb/undotbs01.dbf" datafile
6 auxiliary format
"/ u01/app/oracle/oradata/pdb/users01.dbf"
Sql 'alter system archive log current'
}
Executing Memory Script
Executing command: SET NEWNAME
Renamed tempfile 1 to / u01/app/oracle/oradata/pdb/temp01.dbf in control file
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Starting backup at 28-DEC-17
Using channel ORA_DISK_1
Channel ORA_DISK_1: starting datafile copy
Input datafile file number=00001 name=/u01/app/oracle/oradata/pdb/system01.dbf
Output file name=/u01/app/oracle/oradata/pdb/system01.dbf tag=TAG20171228T001909
Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
Channel ORA_DISK_1: starting datafile copy
Input datafile file number=00003 name=/u01/app/oracle/oradata/pdb/sysaux01.dbf
Output file name=/u01/app/oracle/oradata/pdb/sysaux01.dbf tag=TAG20171228T001909
Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
Channel ORA_DISK_1: starting datafile copy
Input datafile file number=00004 name=/u01/app/oracle/oradata/pdb/undotbs01.dbf
Output file name=/u01/app/oracle/oradata/pdb/undotbs01.dbf tag=TAG20171228T001909
Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Channel ORA_DISK_1: starting datafile copy
Input datafile file number=00006 name=/u01/app/oracle/oradata/pdb/users01.dbf
Output file name=/u01/app/oracle/oradata/pdb/users01.dbf tag=TAG20171228T001909
Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 28-DEC-17
Sql statement: alter system archive log current
Current log archived
Contents of Memory Script:
{
Backup as copy reuse
Archivelog like "/ u01/arc/1_47_963859490.dbf" auxiliary format
"/ u01/arc/1_47_963859490.dbf" archivelog like
"/ u01/arc/1_48_963859490.dbf" auxiliary format
"/ u01/arc/1_48_963859490.dbf"
Catalog clone archivelog "/ u01/arc/1_47_963859490.dbf"
Catalog clone archivelog "/ u01/arc/1_48_963859490.dbf"
Switch clone datafile all
}
Executing Memory Script
Starting backup at 28-DEC-17
Using channel ORA_DISK_1
Channel ORA_DISK_1: starting archived log copy
Input archived log thread=1 sequence=47 RECID=74 STAMP=963879658
Output file name=/u01/arc/1_47_963859490.dbf RECID=0 STAMP=0
Channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Channel ORA_DISK_1: starting archived log copy
Input archived log thread=1 sequence=48 RECID=75 STAMP=963879659
Output file name=/u01/arc/1_48_963859490.dbf RECID=0 STAMP=0
Channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 28-DEC-17
Cataloged archived log
Archived log file name=/u01/arc/1_47_963859490.dbf RECID=1 STAMP=963879661
Cataloged archived log
Archived log file name=/u01/arc/1_48_963859490.dbf RECID=2 STAMP=963879662
Datafile 1 switched to datafile copy
Input datafile copy RECID=2 STAMP=963879662 file name=/u01/app/oracle/oradata/pdb/system01.dbf
Datafile 3 switched to datafile copy
Input datafile copy RECID=3 STAMP=963879662 file name=/u01/app/oracle/oradata/pdb/sysaux01.dbf
Datafile 4 switched to datafile copy
Input datafile copy RECID=4 STAMP=963879662 file name=/u01/app/oracle/oradata/pdb/undotbs01.dbf
Datafile 6 switched to datafile copy
Input datafile copy RECID=5 STAMP=963879662 file name=/u01/app/oracle/oradata/pdb/users01.dbf
Contents of Memory Script:
{
Set until scn 1827407
Recover
Standby
Clone database
Delete archivelog
}
Executing Memory Script
Executing command: SET until clause
Starting recover at 28-DEC-17
Using channel ORA_AUX_DISK_1
Starting media recovery
Archived log for thread 1 with sequence 47 is already on disk as file / u01/arc/1_47_963859490.dbf
Archived log for thread 1 with sequence 48 is already on disk as file / u01/arc/1_48_963859490.dbf
Archived log file name=/u01/arc/1_47_963859490.dbf thread=1 sequence=47
Archived log file name=/u01/arc/1_48_963859490.dbf thread=1 sequence=48
Media recovery complete, elapsed time: 00:00:00
Finished recover at 28-DEC-17
Finished Duplicate Db at 28-DEC-17
RMAN >
Recovery Manager complete.
