HOW TO BACKUP INTERNAL TABLES OF SYSTEM AND SYSAUX TABLESPACES
It is not always expected that the system or sysaux objects can be back up at any specific time in the life of every DBA career. But, it is mandatory to take backup during sysaux housekeeping and system tables cleanup as a workaround for another major issue.
EXP utility is an underrated one which is very light and simple in this situation to take backup of system and sysaux related objects in an efficient way.
Use the below command and the internal tables are packed up in a dump file.
[oracle@staxhost ~]$ exp sys/password FILE=expstat.dmp TABLES=tab$,ind$,ts$,hist_head$,aud$,exp_stat$,exp_obj$,exp_head$
Export: Release 19.0.0.0.0 - Production on Thu Jan 19 17:18:09 2023
Version 19.16.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
EXP-00056: ORACLE error 28009 encountered
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Username: sys as sysdba
Password:
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table TAB$ 2284 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table IND$ 2934 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table TS$ 7 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00064: HIST_HEAD$ is an inner nested table and cannot be exported.
. . exporting table AUD$ 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table EXP_STAT$ 74 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EXP_OBJ$ 22 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EXP_HEAD$ 266 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.