Recover Controlfile[incompelete recover]

最新推荐文章于 2024-06-01 22:37:22 发布

转载最新推荐文章于 2024-06-01 22:37:22 发布 · 276 阅读

文章标签：

#数据库

本文详细记录了使用RMAN工具恢复Oracle数据库的过程，包括设置数据库ID、从自动备份中恢复控制文件、恢复数据库及数据文件等关键步骤，并解决了恢复过程中遇到的问题。

RMAN> set dbid=224143822;

executing command: SET DBID

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of CSET command at 04/15/2013 14:13:20

RMAN-06188: cannot use command when connected to a mounted target database

RMAN> shutdown immediate;

startup nomount;

database closed

database dismounted

Oracle instance shut down

RMAN>

connected to target database (not started)

Oracle instance started

Total System Global Area 205520896 bytes

Fixed Size 1218508 bytes

Variable Size 92276788 bytes

Database Buffers 104857600 bytes

Redo Buffers 7168000 bytes

RMAN> set dbid=224143822;

executing command: SET DBID

RMAN> restore controlfile from autobackup;

Starting restore at 15-APR-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=286 devtype=DISK

recovery area destination: /u01/app/oracle/flash_recovery_area

database name (or database unique name) used for search: PROD

channel ORA_DISK_1: autobackup found in the recovery area

channel ORA_DISK_1: autobackup found: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_15/o1_mf_s_812815879_8pq6j8qc_.bkp

channel ORA_DISK_1: control file restore from autobackup complete

output filename=/oradata/prod/control01.ctl

output filename=/oradata/prod/control02.ctl

output filename=/oradata/prod/control03.ctl

Finished restore at 15-APR-13

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 15-APR-13

Starting implicit crosscheck backup at 15-APR-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=286 devtype=DISK

Crosschecked 5 objects

Finished implicit crosscheck backup at 15-APR-13

Starting implicit crosscheck copy at 15-APR-13

using channel ORA_DISK_1

Finished implicit crosscheck copy at 15-APR-13

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_15/o1_mf_s_812815879_8pq6j8qc_.bkp

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /oradata/prod/system01.dbf

restoring datafile 00002 to /oradata/prod/undotbs01.dbf

restoring datafile 00003 to /oradata/prod/sysaux01.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/backup/PROD_20130415_04o7557t_1_1.bak

^[^Achannel ORA_DISK_1: restored backup piece 1

piece handle=/home/oracle/backup/PROD_20130415_04o7557t_1_1.bak tag=TAG20130415T140653

channel ORA_DISK_1: restore complete, elapsed time: 00:01:36

Finished restore at 15-APR-13

RMAN> recover database;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01006: error signalled during parse

RMAN-02003: unrecognized character:

RMAN>

RMAN> recover database;

Starting recover at 15-APR-13

using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 12 is already on disk as file /oradata/prod/Disk1/redo301.log

archive log thread 1 sequence 13 is already on disk as file /oradata/prod/Disk1/redo101.log

archive log filename=/oradata/prod/Disk1/redo301.log thread=1 sequence=12

archive log filename=/oradata/prod/Disk1/redo101.log thread=1 sequence=13

media recovery complete, elapsed time: 00:00:14

Finished recover at 15-APR-13

RMAN> alter database open resetlogs;

database opened

RMAN>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-758489/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-758489/