Hi,
This error occurs at the time of database restoration
-------------------------------------------------------------
steps i did:
1. Shutdown the database.
2. delete control file , Datafile, redo directories from corresponding DB directory using ASMCMD command prompt.
3. Target pfile contents: (backup old spfile or pfile if needed)
vi initTEST.ora
*.db_name='TEST'
*.db_unique_name='TEST'
3. SQLPLUS "as sysdba"
4. SQL> startup nomount.
5. rman auxiliary /
6. RMAN>
run
{
allocate auxiliary CHANNEL c1 device type disk;
allocate auxiliary CHANNEL c2 device type disk;
allocate auxiliary CHANNEL c3 device type disk;
allocate auxiliary CHANNEL c4 device type disk;
set newname for tempfile 1 to '+DATA_P/TEST/DATAFILE/temp06.dbf';
set newname for tempfile 2 to '+DATA_P/TEST/DATAFILE/temp07.dbf';
set newname for tempfile 3 to '+DATA_P/TEST/DATAFILE/temp08.dbf';
set newname for tempfile 4 to '+DATA_P/TEST/DATAFILE/temp09.dbf';
set newname for tempfile 5 to '+DATA_P/TEST/DATAFILE/temp10.dbf';
duplicate database to "TEST" backup location '/u02/PROD_BKP_07Aug2016/'
SPFILE
set db_name='TEST'
set db_unique_name='TEST'
set cluster_database='false'
set use_large_pages='false'
set remote_listener=''
set local_listener=''
set listener_networks=''
set control_files='+DATA_P/TEST/controlfile_TEST.ctl'
set db_file_name_convert '+DATA_P/PROD/DATAFILE','+DATA_P/TEST/DATAFILE'
set log_file_name_convert '+DATA_P/PROD/ONLINELOG','+DATA_P/TEST/DATAFILE','+RECO_P/PROD/ONLINELOG','+DATA_P/TEST/DATAFILE';
switch tempfile all;
}
====================================================================
After this got following error:
---------------------------------------------
connected to auxiliary database (not started)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/11/2016 14:16:44
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: 13: Permission denied
Additional information: 9925
______________________________
Detailed log has attached.
=================
next time when i try to login:
$ sqlplus "/ as sysdba"
showing the error:
------------------------------------
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
ORA-01075: you are currently logged on
----------------------------------
Please support in this issue?
=================