以下是Linux Oracle备份恢复实战相关内容:
rman target /命令连接数据库,如rman target / nocatalog << EOF RUN { BACKUP DATABASE PLUS ARCHIVELOG; } EOF可实现全库备份,也可通过配置实现增量备份。SQL> CREATE DIRECTORY dp_dir AS '/u01/app/oracle/backup/dp';,然后使用expdp或impdp命令进行导出导入,如expdp sys/密码@SID directory=dp_dir dumpfile=full_db.dmp logfile=expdp_full.log full=y。rman target / RUN { RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN; };不完全恢复则需指定时间点或SCN,如RECOVER DATABASE UNTIL TIME "to_date('2025-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')"。SELECT * FROM V$FLASHBACK_DATABASE_LOG;,确定时间点后用FLASHBACK DATABASE TO TIMESTAMP 'YYYY-MM-DD HH24:MI:SS';恢复,最后ALTER DATABASE OPEN。