DIA-49803: Purge not possible due to incompatible schema version.

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 留言