RESTORE CONTROLFILE FROM BACKUPPIECEFILE; 如果是自动备份,可以采用如下的方法: RESTORE CONTROLFILE FROM AUTOBACKUP; 但是,如果控制文件全部丢失,需要指定DBID,命令为“SET DBID=?”。自动备份控制文件的默认格式是%F,这个格式的形式为“c-IIIIIIIIII-YYYYMMDD-QQ”,其中IIIIIIIIII就是DBID。可以采用包DBMS_BACKUP_...
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:ORACLEDATABASESNCFPSI2.ORA'; # default 2、退出rman, 关闭,start...
restore controlfile to 'f:\oracle\control01.ctl' from autobackup; 这条命令也可以在数据库open时执行,只要被恢复的路径不是当前数据库控制文件所在路径就行 2,从备份集中恢复 从10g开始,restore直接提供了from backup子句,这样就可以直接从指定备份片段中恢复控制文件(只要确保指定的备份集中包含控制文件),操作方式...
RMAN> restore controlfile from '/u02/backup/ctl_file_07n3ceqb_1_1_20120215'; Starting restore at 15-FEB-12 using channel ORA_DISK_1 channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete,elapsed time: 00:00:03 output filename=/u02/app/oracle/oradata/anqing/...
sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'D:\HISDBRman\DF343_1_714024003', params=>null); 到另一个备份集。 3,看看control文件在不 如果rman备份集里有,就直接: RMAN>restorecontrolfilefrom'F:\tmp\DF344_1_714024149'; ...
While restoring a controlfile from autobackup, the rman command is taking a very long time (more than 1 hour). At the end, it is giving the error below. RMAN...
4> SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_SERVER=XXXX,NSR_CLIENT=XXXXXXX)'; 5> restore until time = "to_date('July 2 2017 13:00:00','Mon DD YYYY HH24:MI:SS')" controlfile to 'N:\RMAN_Backup' from autobackup; 6> } ...
Oracle Database Backup Service - Version N/A and laterInformation in this document applies to any platform. Symptoms You are using "restore controlfile from autobackup", the backup is on tape, you've allocated the tape channels and any necessary media manager (tape) parameters for an alternate...
After the control file is restored from backup, the database is mounted. When a control file restored from backup is used to start the database, you must perform complete recovery of the datafiles, even if none of the datafiles have been restored from backup. The database must be opened...
(4)、restore controlfile 还原控制文件。 (5)、restore archivelog 还原归档日志文件。 2、recover 命令:当数据库需要应用归档日志文件恢复数据文件时,使用recover命令。使用该命令数据库系统会自动应用归档的日志文件。 (1)、recover database 恢复所有的数据文件。 (2)、recover tablespace 恢复特定表空间的数据文件...