RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
Cause: RESTORE CONTROLFILE or RESTORE SPFILE was specified without the FROM AUTOBACKUP option when RMAN is not connected to the recovery catalog.
Action: If the recovery catalog is available, connect to the recovery catalog and retry the restore. If the recovery catalog in not available, following is the procedure to restore control file or SPFILE:
1. Specify the DBID of the database with the SET DBID command.

2. If the AUTOBACKUP was created with non-default AUTOBACKUP format, then specify the AUTOBACKUP format using the SET CONTROLFILE AUTOBACKUP FORMAT command.

3. If the backup was created with SBT device, then allocate an SBT channel using the ALLOCATE CHANNEL command.

4. Restore control file or SPFILE by starting the RESTORE ... FROM AUTOBACKUP command.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:07

RMAN-06563：必须使用FROM AUTOBACKUP恢复控制文件或SPFILE,
.原因：当RMAN未连接到恢复目录时，未指定FROM AUTOBACKUP选项时指定了RESTORE CONTROLFILE或RESTORE SPFILE。,
.操作：如果恢复目录可用，请连接到恢复目录并重试恢复。如果恢复目录不可用，以下是恢复控制文件或SPFILE的过程：,
.1.使用SET DBID命令指定数据库的DBID。,
.,
.2.如果AUTOBACKUP使用非缺省AUTOBACKUP格式创建，则使用SET CONTROLFILE AUTOBACKUP FORMAT命令指定AUTOBACKUP格式。,
.,
.3.如果使用SBT设备创建备份，则使用ALLOCATE CHANNEL命令分配SBT通道。,
.,
.4.通过启动RESTORE ... FROM AUTOBACKUP命令恢复控制文件或SPFILE。,
.,
.

aiaiDBA

13718043309

010-86462881

RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

1 个回答

相似问题