Recommendations for automatic recovery of Oracle data recover Advisor

Starting with the Oracle 11GR1 release, Oracle provides a recommended solution for database data file fixes to better enable users to choose a recovery approach

This becomes more and more intelligent, and we just need to follow the Fix Advice wizard.

Environment Oracle Linux as 5.5+oracle 11.2 (archive mode)

1, the situation before the backup

Sql> Conn Fmismain/fmismain

Connected.

Sql> Select COUNT (*) from XTDW;

COUNT (*)

----------

29

Sql> Select COUNT (*) from XTDW3;

COUNT (*)

----------

30

Sql>

2. Rman Backup

[Oracle@ora1 ~]$ Rman Target/

Recovery manager:release 11.2.0.1.0-production on Thu June 22 09:13:05 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to target database:ora11g (dbid=4120198168)

Rman> Backup Database format '/soft/bak/%u.full_bak ';

Starting backup at 22-jul-10

Using target database control file instead of recovery catalog

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=47 Device Type=disk

Channel ora_disk_1:starting full DataFile backup set

Channel ora_disk_1:specifying DataFile (s) in backup set

Including current SPFILE in backup set

Including control file in backup set

Input datafile file number=00001 name=+dgdatga/ora11g/datafile/system.260.723998053

Input datafile file number=00002 name=+dgdatga/ora11g/datafile/sysaux.259.723998085

Input datafile file number=00003 name=+dgdatga/ora11g/datafile/undotbs1.258.723998109

Input datafile file number=00005 name=+dgdatga/ora11g/datafile/fmismain.266.724020873

Input datafile file number=00004 name=+dgdatga/ora11g/datafile/users.256.723998149

Channel ora_disk_1:starting piece 1 at 22-jul-10

Channel ora_disk_1:finished piece 1 at 22-jul-10

Piece Handle=/soft/bak/01ljdn3b_1_1.full_bak tag=tag20100722t091419 comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:02:07

Finished backup at 22-jul-10

3. Close the database, mistakenly delete a database of data files

Manually delete the fmismain.266.724020873 file in ASM

3. Start the database times wrong, prompted not to find the fmismain.266.724020873 data file

[Oracle@ora1 ~]$ sqlplus "/as sysdba"

Sql*plus:release 11.2.0.1.0 Production on Thu June 22 09:19:16 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production

With the partitioning, Automatic Storage Management, OLAP, Data Mining

and real Application testing options

sql> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

Sql> Startup

ORACLE instance started.

Total System Global area 481259520 bytes

Fixed Size 1337352 bytes

Variable Size 264243192 bytes

Database buffers 209715200 bytes

Redo buffers 5963776 bytes

Database mounted.

Ora-01157:cannot identify/lock data file 5-see DBWR trace file

Ora-01110:data file 5: ' +dgdatga/ora11g/datafile/fmismain.266.724020873 '

4.advise failure (data recover Advisor)

[Oracle@ora1 ~]$ Rman Target/

Recovery manager:release 11.2.0.1.0-production on Thu June 22 09:39:42 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to target database:ora11g (dbid=4120198168, not open)

Rman> list;

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

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

RMAN-00569: =============== ERROR message STACK follows ===============

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

Rman-00558:error encountered while parsing input commands

Rman-01009:syntax error:found ";": Expecting one of: "All, Archivelog, backed, backuppiece, Backupset, backup, completed , controlfilecopy, copy, datafilecopy, db_unique_name, device, expired, failure, foreign, global, incarnation, like, proxy , recoverable, restore, script, tag "

Rman-01007:at Line 2 column 1 File:standard input

Rman>

rman>;

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

RMAN-00569: =============== ERROR message STACK follows ===============

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

Rman-00558:error encountered while parsing input commands

Rman-01009:syntax error:found ";": Expecting one of: "Advise, allocate, alter, backup, @, catalog, change, configure, CO Nnect, convert, copy, create, Crosscheck, delete, drop, duplicate, exit, flashback, Grant, host, import, list, mount, open , print, quit, recover, register, release, repair, replace, on, reset, restore, Resync, revoke, run, send, set, show, Shutdown, spool, SQL, startup, switch, transport, unregister, upgrade, validate, {, "