Problem:
# su - oracle -c 'adrci exec="set homepath diag/asmcmd/user_oracle/dgdb1;purge -age 10 -type incident"' DIA-49803: Purge not possible due to incompatible schema version.
Solution: using command migrate schema
$ adrci ADRCI: Release 19.0.0.0.0 - Production on Thu Jun 2 16:11:20 2022 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> set homepath diag/asmcmd/user_oracle/dgdb1 adrci> show version schema Schema version (on-disk): 0 Schema version (library): 110 adrci> migrate schema Schema migrated. adrci> show version schema Schema version (on-disk): 110 Schema version (library): 110 adrci> purge -age 10 -type incident adrci> exit
0 留言