2019-10-31 22:29:21 ERROR OGG-00446 Opening file +ARCH/1_349552_884742128.dbf in DBLOGREADER mode: (308)
ORA-00308: cannot open archived log '+ARCH/1_349552_884742128.
dbf'
ORA-17503: ksfdopn:2 Failed to open file +ARCH/1_349552_884742128.dbf
ORA-15173: entry '1_349552_884742128.dbf' does not exist in directory '/'
Not able to establish initial position for sequence 349552, rba 1040177680.
2019-10-31 22:29:21 ERROR OGG-01668 PROCESS ABENDING.
>show parameter dest_1
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_create_online_log_dest_1 string +DATA1
log_archive_dest_1 string LOCATION=+ARCH VALID_FOR=(ALL
_LOGFILES,ALL_ROLES) DB_UNIQUE
_NAME=
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
>
>alter system set log_archive_dest_1='location=+ARCH';
System altered.
>show parameter dest_1
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_create_online_log_dest_1 string +DATA1
log_archive_dest_1 string location=+ARCH
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
处理过程:
-
更改归档路径后
-
alter 进程 benin now
3.start 进程