rman备份重建数据库.docVIP

RMAN备份　重建数据库 ORACLE 2007-01-19 11:19:10 阅读0 评论0 字号：大中小 利用RMAN备份重建数据库一、准备测试数据 SQL connect scott/xxxxx@jeffSQL insert into test_logminer values 20 ;SQL commit;SQL select * from test_logminer; REC_NO 二、备份测试数据库 C:\Documents and Settings\xxxxx rman target / Recovery Manager: Release 9.2.0.1.0 - Production Copyright c 1995, 2002, OracleCorporation.? All rights reserved. connected to target database: JEFF DBID 1座机电话号码5 RMAN show all; using target database controlfile instead of recoverycatalogRMAN configuration parameters are:CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;CONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TOC:\Oracle\backup\CTL_%F;CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; #defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; #defaultCONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT??C:\Oracle\backup\BKP_%d_%s_%T;CONFIGURE MAXSETSIZE TO 2 G;CONFIGURE SNAPSHOT CONTROLFILE NAME TOC:\ORACLE\BACKUP\CTL_SNAPSHOT; RMAN backup database; Starting backup at 26-JUN-06allocated channel: ORA_DISK_1channel ORA_DISK_1: sid 16 devtype DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile s in backupsetinput datafile fno 00001name C:\ORACLE\ORADATA\JEFF\SYSTEM01.DBFinput datafile fno 00002name C:\ORACLE\ORADATA\JEFF\UNDOTBS01.DBFinput datafile fno 00004name C:\ORACLE\ORADATA\JEFF\EXAMPLE01.DBFinput datafile fno 00009name C:\ORACLE\ORADATA\JEFF\XDB01.DBFinput datafile fno 00005name C:\ORACLE\ORADATA\JEFF\INDX01.DBFinput datafile fno 00008name C:\ORACLE\ORADATA\JEFF\USERS01.DBFinput datafile fno 00003name C:\ORACLE\ORADATA\JEFF\DRSYS01.DBFinput datafile fno 00006name C:\ORACLE\ORADATA\JEFF\ODM01.DBFinput datafile fno 00007name C:\ORACLE\ORADATA\JEFF\TOOLS01.DBFchannel O