在CentOS上使用SQL*Plus備份與恢復Oracle數據庫的方法如下：
sqlplus / as sysdba。exp userid=username/password@database file=/path/backup.dmp log=/path/backup.log full=y，將數據庫完整備份到指定路徑。sqlplus / as sysdba。CREATE DIRECTORY backup_dir AS '/path/to/backup/directory'。expdp username/password@database DIRECTORY=backup_dir DUMPFILE=backup_name.dmp LOGFILE=backup_name.log FULL=y。sqlplus / as sysdba。imp userid=username/password@database file=/path/backup.dmp full=y ignore=y，將備份文件恢復到數據庫。sqlplus / as sysdba。CREATE DIRECTORY restore_dir AS '/path/to/restore/directory'。impdp username/password@database DIRECTORY=restore_dir DUMPFILE=backup_name.dmp LOGFILE=restore_name.log FULL=y。
