oracle的备份与恢复的批处理

最新推荐文章于 2025-08-18 16:41:53 发布

转载最新推荐文章于 2025-08-18 16:41:53 发布 · 892 阅读

文章标签：

#oracle #disk #database #archive #sql #system

本文介绍了一种使用 Oracle RMAN 进行数据库备份及恢复的方法，包括配置多通道并行备份、指定备份文件格式及路径、执行全库备份及归档日志备份等操作，并详细记录了恢复过程中的控制文件恢复步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

================备份=================================
rman target / cmdfile=/oracle/shell/cfg/bakDB.rcv trace /oracle/shell/logs/bakfull.log &

CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/rman01/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/rman02/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT   '/rman03/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT   '/rman04/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 5 DEVICE TYPE DISK FORMAT   '/rman05/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT   '/rman06/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 7 DEVICE TYPE DISK FORMAT   '/rman07/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 8 DEVICE TYPE DISK FORMAT   '/rman08/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
run
{
sql "Alter System Archive Log Current";
BACKUP FILESPERSET=32 DATABASE plus archivelog format '/rman02/arch_%d_%T_%s';
sql "alter database backup controlfile to ''/rman01/controlfile/copy_current_controlfile'' reuse";
}
=================恢复================================
rman target / nocatalog cmdfile=./restoreDB.rcv trace ./restoreDB.log &

------------------restoreDB.rcv----------------------------------------------
STARTUP NOMOUNT;
SET DBID 3658411712;    # required when restoring control file in NOCATALOG mode
run
{
CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/rman01/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/rman02/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT   '/rman03/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT   '/rman04/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 5 DEVICE TYPE DISK FORMAT   '/rman05/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT   '/rman06/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 7 DEVICE TYPE DISK FORMAT   '/rman07/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
CONFIGURE CHANNEL 8 DEVICE TYPE DISK FORMAT   '/rman08/bak_ful/dbf_%T_%s_%p' MAXPIECESIZE 8 G;
restore controlfile from '/rman01/controlfile/copy_current_controlfile';
alter database mount;
RESTORE DATABASE;
recover database until cancel;
}