oracle rman的使用方法

最新推荐文章于 2025-08-17 22:46:01 发布

原创最新推荐文章于 2025-08-17 22:46:01 发布 · 642 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #list #null #disk #c #report

本文介绍了Oracle数据库中备份与恢复的具体操作方法，包括使用标签进行备份集管理、创建多个备份副本的不同方式、配置备份保留策略及通过接口实现数据提取等高级主题。

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

---------------标签tag的使用---------------------------------------------

backup as compressed backupset format 'c:/arc/f4_%u' datafile 4 tag='users_full';
backup as backupset format 'c:/arc/f4_%u' datafile 4;
backup as compressed backupset format 'c:/arc/f6_%u' datafile 6 tag='users full';

list backup of datafile 4 tag='USERS FULL';
list backup tag='USERS FULL';
当同一个文件使用相同的标签进行备份时，LIST的时候只显示最后的一个备份集。

------------------一次备份多个备份集合的三种模式-----------------------------
BACKUP COPIES
SET BACKUP COPIES
CONFIGURE ... BACKUP COPIES

run{
set backup copies=2;
backup datafile 6 format 'c:/arc/f6_%c_%u' tag='users full';
}

backup COPIES 2 datafile 6 format 'c:/arc/f6_%c_%u' tag='users full' ;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
backup as compressed backupset format 'c:/arc/f6_%c_%u' datafile 6 tag='users full';
其中%c为必须指定的

backup as compressed backupset format 'c:/arc/f4_%u.bk' datafile 4;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

-------------------------------CONFIGURE 默认的设置------------------
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
--最少保持两个备份集
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
--7天以外的认为过期了
report OBSOLETE;
delete OBSOLETE;
delete noprompt OBSOLETE;
------------------------------使用接口来获得数据-----------20070105--------------------------------
--提取归档日志
DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype:=sys.dbms_backup_restore.deviceAllocate(type=>'',ident=>'T1');
sys.dbms_backup_restore.restoreSetArchivedLog;
sys.dbms_backup_restore.restoreArchivedLogRange;
sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'f:/bk/04I3FVK6_1_1', params=>null);
sys.dbms_backup_restore.deviceDeallocate;
END;
/

--提取磁带库中的控制文件----------------------------------------------------------------
SQL>
DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype:=sys.dbms_backup_restore.deviceAllocate(type=>'sbt_tape',
ident=>'T1',params=>'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=oratest,OB2BARLIST=test2oratest)');
sys.dbms_backup_restore.restoreSetDatafile;
sys.dbms_backup_restore.restoreControlfileTo(cfname=>'/backup/test/Control01.ctl');
sys.dbms_backup_restore.restoreBackupPiece(done=>done,
handle=>'test2oratest<oratest_2:539001979:1>.dbf', params=>null);
sys.dbms_backup_restore.deviceDeallocate;
END;
/

--提取数据文件和控制文件
DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype:=sys.dbms_backup_restore.deviceAllocate(type=>'',ident=>'T1');
sys.dbms_backup_restore.restoreSetDatafile;
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>4,toname=>'F:/oradata/users01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>6,toname=>'F:/oradata/DEMO01.DBF');
--sys.dbms_backup_restore.restoreControlfileTo(cfname=>'d:/oracle/Control01.ctl');
sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'f:/bk/04I3FVK6_1_1', params=>null);
sys.dbms_backup_restore.deviceDeallocate;
END;
/