oracle數(shù)據(jù)庫(kù)恢復(fù)

恢復(fù)背景

使用RMAN做了數(shù)據(jù)庫(kù)的完全備份、參數(shù)文件、控制文件的備份，所有數(shù)據(jù)文件\ 在線(xiàn)重做日志文件、控制文件和spfile參數(shù)文件全部丟失

恢復(fù)步驟

1.關(guān)閉數(shù)據(jù)庫(kù)

RMAN> shutdown immediate;

Oracle instance shut down

2.設(shè)置DBID

RMAN> set dbid 663499696

(可以在備份集的名稱(chēng)上得到DBID)

executing command: SET DBID

3.強(qiáng)行啟動(dòng)實(shí)例

RMAN> startup force nomount;

startup failed: ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/opt/app/oracle/product/10.2.0/db_1/dbs/initora10.ora'

starting Oracle instance without parameter file for retrival of spfile

Oracle instance started

Total System Global Area???? 159383552 bytes

Fixed Size???????????????????? 1218268 bytes

Variable Size???????????????? 54528292 bytes

Database Buffers???????????? 100663296 bytes

Redo Buffers?????????????????? 2973696 bytes

4.恢復(fù)spfile參數(shù)文件(AUTOBACK已經(jīng)不可用)

RMAN> restore spfile from '/orabak/ctl_c-663499696-20090319-00';

Starting restore at 19-MAR-09

using channel ORA_DISK_1

channel ORA_DISK_1: autobackup found: /orabak/ctl_c-663499696-20090319-00

channel ORA_DISK_1: SPFILE restore from autobackup complete

Finished restore at 19-MAR-09

5.恢復(fù)控制文件(AUTOBACK已經(jīng)不可用)

RMAN> restore controlfile from '/orabak/ctl_c-663499696-20090319-00';

re

Starting restore at 19-MAR-09

using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

output filename=/opt/app/oracle/product/10.2.0/db_1/dbs/cntrlora10.dbf(注意：控制文件不在原來(lái)數(shù)據(jù)文件的位置)

Finished restore at 19-MAR-09

7. 關(guān)閉數(shù)據(jù)庫(kù)

RMAN> shutdown immediate;

using target database control file instead of recovery catalog

Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)

Oracle instance started

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

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

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

RMAN-03002: failure of startup command at 03/19/2009 13:55:37

ORA-00205: error in identifying control file, check alert log for more info

8.恢復(fù)控制文件(AUTOBACK已經(jīng)不可用)

RMAN> restore controlfile from '/orabak/ctl_c-663499696-20090319-00';

Starting restore at 19-MAR-09

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03

output filename=/opt/app/oracle/oradata/ora10/control01.ctl

output filename=/opt/app/oracle/oradata/ora10/control02.ctl

output filename=/opt/app/oracle/oradata/ora10/control03.ctl(注意：控制文件已經(jīng)恢復(fù)到原來(lái)數(shù)據(jù)文件的位置)

Finished restore at 19-MAR-09

9.裝載數(shù)據(jù)庫(kù)

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

10.還原數(shù)據(jù)庫(kù)

RMAN> restore database;

Starting restore at 19-MAR-09

Starting implicit crosscheck backup at 19-MAR-09

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

Crosschecked 1 objects

Finished implicit crosscheck backup at 19-MAR-09

Starting implicit crosscheck copy at 19-MAR-09

using channel ORA_DISK_1

Finished implicit crosscheck copy at 19-MAR-09

searching for all files in the recovery area

cataloging files...

no files cataloged

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 /opt/app/oracle/oradata/ora10/system01.dbf

restoring datafile 00002 to /opt/app/oracle/oradata/ora10/undotbs01.dbf

restoring datafile 00003 to /opt/app/oracle/oradata/ora10/sysaux01.dbf

restoring datafile 00004 to /opt/app/oracle/oradata/ora10/users01.dbf

restoring datafile 00005 to /opt/app/oracle/oradata/ora10/user_data.dbf

channel ORA_DISK_1: reading from backup piece /orabak/arch/20090319_0kkaa72a_1_1.bak

channel ORA_DISK_1: restored backup piece 1

piece handle=/orabak/arch/20090319_0kkaa72a_1_1.bak tag=TAG20090319T111522

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

Finished restore at 19-MAR-09

11.恢復(fù)數(shù)據(jù)庫(kù)

RMAN> recover database;

Starting recover at 19-MAR-09

using channel ORA_DISK_1

la

starting media recovery

unable to find archive log

archive log thread=1 sequence=3

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

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

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

RMAN-03002: failure of recover command at 03/19/2009 14:03:07

RMAN-06054: media recovery requesting unknown log: thread 1 seq 3 lowscn 522697

12.重置onlineredolog日志序號(hào)

RMAN> alter database open resetlogs;

database opened

RMAN>

數(shù)據(jù)庫(kù)恢復(fù)完成！

總結(jié)

以上是生活随笔為你收集整理的oracle 强制恢复,oracle数据库恢复的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。