================备份=================================
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;
}
oracle的备份与恢复的批处理
转载上一篇:聚集索引和非聚集索引的区别
下一篇:无文件动态承载WCF服务
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Oracle用户管理的备份与恢复
用户管理的备份与恢复也称OS物理备份,是指通过数据库命令设置数据库为备份状态,然后用操作系统命令,
oracle 备份 sql 数据库 -
【oracle备份恢复】oracle数据库备份恢复之逻辑备份与恢复
oracle数据库备份恢复之逻辑备份与恢复
oracle oracle备份与恢复 -
Oracle 数据备份与恢复
Oracle 数据备份与恢复
Oracle 数据备份与恢复 -
Android的系统给提供的图在哪
一、Android平台架构及特征 Android系统建立在Linux系统之上,分为4层:操作系统内核、中间件、用户界面、应用软件。 可以看到,这4层架构主要由5部分组成:用户程序、用户程序框架、C/C++函数库、Android运行时、Linux内核。 &nbs
Android的系统给提供的图在哪 android Android xml文件