rman target /
run {
backup database plus archivelog;
}
crontab -e添加定時任務，例如每天凌晨1點執行備份腳本：0 1 * * * /path/to/backup_script.sh
sqlplus / as sysdba
SHUTDOWN IMMEDIATE;
rman target /
run {
restore controlfile from '/path/to/backup/controlfile.ctl';
alter database mount;
}
run {
restore database;
recover database;
}
recover database until scn 1234567890; # 替換為實際SCN
ALTER DATABASE OPEN;
set newname命令重定向文件路徑。$ORACLE_HOME/rdbms/log）排查錯誤。參考來源：
