I face this error while i try to move my archivelogs from one mount point to other and register my archivelogs to Oracle 11gR1 database(11.1.0.7.0) on OEL 5.5 x-86-64 bit operating systemI had some space problem and i need to move my archive logs from mount point /u01 to /u02. After copy my archivelogs manualy from /u01 to /u02 i try to register them to my Oracle11gR1 database (11.1.0.7.0) as follow:

$sqlplus  “/as sysdba”

SQL> alter database register logfile ‘/xx/archivlog1_973_705508708.dbf’;

This command returns me below error:

alter database register logfile ‘/xx/archivlog1_973_705508708.dbf’;

ERROR at line 1:
ORA-16225: Missing LogMiner session name for Streams

This error’s solution is, using below syntax for register archivelogs to database:

ALTER DATABASE REGISTER PHYSICAL LOGFILE ‘/xx/archivlog1_973_705508708.dbf’;

Reference:

ORA-00604 During Alter Database Register Logfile [ID 469345.1]

Advertisements