Hello,
I think I forget to touch the directory topic regarding DUPLICATE DATABASE FROM ACTIVE DATABASE RMAN COMMAND.. and hence, I got the following error at the end of the command:
- - -
sql statement: alter system set DB_RECOVERY_FILE_DEST_SIZE = 35000M comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/10/2013 14:11:10
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> exit
After connecting to SQL*Plus I get the same above error while connecting to Physcial Standby db:
SQL> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 15:31:09 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
Enter user-name:
/oracle/app/base/diag/rdbms/john/john/trace --background_dump_dest , user_dump_dest
/oracle/app/base/diag/rdbms/john/john/cdump --core_dump_dest
/oracle/app/base/admin/john/adump ---audit_file_dest
Thanks a lot for the help.
Best Regards,