Home » RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file during creation of physical standby using RMAN

RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file during creation of physical standby using RMAN

by tuanlp

RMAN> connect target sys

target database Password:

connected to target database: TESTDB1 (DBID=693279980)

RMAN> connect auxiliary sys@testdb2

auxiliary database Password:

connected to auxiliary database: TESTDB2 (not mounted)

RMAN>

run{

allocate channel prmy1 type disk;

allocate channel prmy2 type disk;

allocate auxiliary channel stby type disk;

duplicate target database for standby from active database

spfile

parameter_value_convert ‘testdb1′,’testdb2’

set db_name=‘testdb1’

set db_unique_name=‘testdb2’

set db_file_name_convert=‘/testdb1/’,’/testdb2/’

set log_file_name_convert=‘/testdb1/’,’/testdb2/’

set control_files=‘+DATA/testdb2/CONTROLFILE/testdb201.ctl’

set log_archive_max_processes=‘4’

set standby_archive_dest = ‘/holding/testdb2/standby_logs’

set log_archive_dest_1 = ‘LOCATION=/holding/testdb2/archive_logs valid_for=(online_logfile, all_roles)’

set log_archive_dest_2 = ‘LOCATION=/holding/testdb2/standby_logs valid_for=(standby_logfile, standby_role)’

set standby_file_management=‘AUTO’

set log_archive_config=‘dg_config=(testdb1,testdb2)’

;

}

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 04/19/2017 14:25:40

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 9925

RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

Solution:

In that scenario testdb1 is primary database server and testdb2 is standby database server

In Primary database:

SQL> show parameter audit_file_dest

NAME TYPE VALUE

———————————— ——————————— ——————————

audit_file_dest string /opt/oracle/admin/testdb1/adump

Create the folder in standby.

[oracle@testdb2 ~]$ mkdir -p /opt/oracle/admin/testdb2/adump/

You may also like