Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.