linux ora09925,ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error

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?

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值