Oracle Database Discussions

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?

=================