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?

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

  • 0
    点赞
  • 0
    收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:1024 设计师:我叫白小胖 返回首页
评论
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值