RMAN>STARTUP NOMOUNT d.Restore a control file from the old incarnation. If you have a control file tagged, then specify the tag. Otherwise, you can run the SET UNTIL command, as in this example: RMAN>RUN { SET UNTIL 'SYSDATE-45'; RESTORE CONTROLFILE; # only if current control file i...
RMAN-03002: failure of restore command at 09/21/2013 00:46:57 RMAN-06509:only SPFILE or control file can be restored from AUTOBACKUP --看提示是说oracle不能这样恢复数据库。 那如何使用这个备份集恢复呢? 10.需要先将备份集catalog到RMAN备份记录中去。 RMAN> catalog start with '/u01/app/oracle/...
RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP 1. 1. --看提示是说oracle不能这样恢复数据库。 1. 1. 那如何使用这个备份集恢复呢? 1. 1. 10. 需要先将备份集catalog到RMAN备份记录中去。 1. 1. RMAN> catalog start with '/u01/app/oracle/flash_recovery_area/august/A...
337.You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape. What command would you use to get those backup set pie...
catalogstart with 337.You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have anautomated cross-check script that also does a delete expired backupset command. You have restor catalog start with 原创 ...
RMAN metadata can be additionally be stored in a recovery catalog. The recovery catalog is a dedicated schema, usually in a separate database. The RMAN recovery catalog is created by the RMAN client running the CREATE CATALOG command.
RMAN中可以备份metadata到control文件,也可以备份metadata到数据库中,此数据库称为catalog database。 使用机器: 机器1:target 机 o_target.loc 192.168.10.111 要备份的数据库。 机器2:catalog 机 o_catalog.loc 192.168.10.112 RMAN catalog metadata 所保存的位置。
Starting with Oracle Database 12c Release 1 (12.1.0.2), virtual private catalogs can be created only when using Oracle Database Enterprise Edition. If you are creating a virtual private catalog, then the base recovery catalog owner must have used the RMAN GRANT command to grant either the ...
rman nocatalog恢复: 1)建立oracle运行环境(包括init或sp文件) 2)文件方式恢复controlfile到init文件指定的位置 3) startup mount 4) rman,恢复datafile 5) alter database open resetlogs rman catalog恢复: 1)建立oracle运行环境(包括init或sp文件) 2) rman,restore controfile ...
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the ...