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

When i am creating Standby database using RMAN active database option , it has thrown below Errors while creating online relogfiles .

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\DUMMY\REDO0101.LOG'

Solution

Use the log_file_name_convert option in RMAN duplicate command.

Ex:

RMAN>run

{

duplicate target database for standby from active database

spfile

set db_unique_name='dummy'

set control_files='M:\oracle\oradata\DUMMY\CONTROL01.CTL'

set log_file_name_convert='M:\oracle\oradata\DUMMY\',''M:\oracle\oradata\DUMMY\'

set instance_number='1'

nofilenamecheck;

}

Note: If you set the db_recovery_file_dest parameter RMAN will not give give above Error, By default online redo log files will be generated on db_recovery_file_dest parameter folder location .

ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

Cause: When ever using keep option in Rman Backup Command with FRA (Flashback Recovery Area) as backup location above error will occur.

Solution: Either Remove the Keep option from RMAN Backup Command or Change the Backup location to other than FRA (While Restoring Register the backup sets).