Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

archive error

RobeenDec 31 2018 — edited Dec 31 2018

Oracle Database 12.2.0

RHEL 7.4

Hi Team,

I would like to know why I am unable to load data using sqlloader despite no archivelog in the system

RMAN> delete archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=503 device type=DISK
specification does not match any archived log in the repository

[oracle@RH-DATWHSE-DEV data]$ sh load_posdata.sh
dbs_data_rep_20181229.dat

SQL*Loader: Release 12.2.0.1.0 - Production on Mon Dec 31 11:18:45 2018

SQL*Loader-128: unable to begin a session
ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

Please advise.

Thanks,

Joe

Added on Dec 31 2018

#general-database-discussions

13 comments

4,239 views