1)
The number of Oracle redo threads (4) is not the same as the number of
checkpoint threads (1). EXTRACT groups on RAC systems should be created
with the THREADS parameter
Нужно добавить опцию threads
- Delete the extract
delete extract testext
- Recreate the extract
add extract testext, tranlog, threads 2, begin now
add <exttrail/rmttrail> <path>, extract testext
- Start the extract
start extract testext
WARNING OGG-01423 No valid default archive log destination directory found for thread 4.
WARNING OGG-01423 No valid default archive log destination directory found for thread 3.
Нужно удалить лишние потоки в active redo log
alter database disable thread 3;
alter database disable thread 4;
ALTER DATABASE DROP LOGFILE GROUP 7;
ALTER DATABASE DROP LOGFILE GROUP 8;
ALTER DATABASE DROP LOGFILE GROUP 5;
ALTER DATABASE DROP LOGFILE GROUP 6;
3) Создание пользователя в ASM инстансе:
CREATE USER asm_user IDENTIFIED by XXX;
GRANT SYSASM TO asm_user;
GRANT sysdba TO asm_user;
Проверка:
sqlplus asm_user@ORCL_ASM as sysasm
Добавляем в файл параметров
TranLogOptions ASMUser asm_user@ORCL_ASM, asmpassword XXX