Hello,
I am getting the below errors when attempting to do TSPITR using Oracle 12.1.0.2 at Windows 2012 R2 server.
RMAN-04006: error from auxiliary database: ORA-28056: Writing audit records to Windows Event Log failed
ORA-28056: Writing audit records to Windows Event Log failed
I cleared the Windows event logs, increased their space and also checked all the permissions of the windows folders. Also tried setting audit_trail to off. They all did not help. Below is the RAMAN log of the restore run. Anyone has any suggestion how to resolve this. Thanks.
D:\>rman nocatalog target /
Recovery Manager: Release 12.1.0.2.0 - Production on Tue Feb 12 10:07:12 2019
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTDB (DBID=1448117878)
using target database control file instead of recovery catalog
RMAN>
RMAN> run
2> {
3> allocate CHANNEL ch1 DEVICE TYPE disk;
4> recover tablespace 'test_reco_ts' until time = "TO_DATE('02/05/2019 09:49:16','MM/DD/YYYY HH24:MI:SS')" auxiliary destination='H:\app\oracle\FRA';
5> }
allocated channel: ch1
channel ch1: SID=2430 device type=DISK
Starting recover at 12-FEB-19
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Creating automatic instance, with SID='htec'
initialization parameters used for automatic instance:
db_name=TESTDB
db_unique_name=htec_pitr_TESTDB
compatible=12.1.0.0.0
db_block_size=16384
db_files=200
diagnostic_dest=D:\APP\ORACLE
_system_trig_enabled=FALSE
sga_target=2560M
processes=200
db_create_file_dest=H:\app\oracle\FRA
log_archive_dest_1='location=H:\app\oracle\FRA'
#No auxiliary parameter file used
starting up automatic instance TESTDB
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/12/2019 10:09:06
RMAN-04006: error from auxiliary database: ORA-28056: Writing audit records to Windows Event Log failed
ORA-28056: Writing audit records to Windows Event Log failed
RMAN>
RMAN>