RMAN-05533: LIST FAILURE is not supported on RAC database

i’m trying to recover a datafile with our production database. 3 node cluster database so i tried to use the new feature of RMAN repair command.

unfortunately encountered an error : “…is not supported on RAC database

for the example below i’m using my test environment.

[oracle@lnxrac01 bin]$ ./srvctl status database -d bairac1
Instance bairac11 is running on node lnxrac01
Instance bairac12 is running on node lnxrac02

 

SQL> set lines 150;
SQL> select file_name, file_id, online_status from dba_data_files;

FILE_NAME                               FILE_ID         ONLINE_
———————————————————————————————————————————-
+DATA01/bairac1/datafile/system.274.726941717         1             SYSTEM
+DATA01/bairac1/datafile/sysaux.275.726941737         2            RECOVER
+DATA01/bairac1/datafile/undotbs1.276.726941773     3             ONLINE
+DATA01/bairac1/datafile/undotbs2.278.726941805     4             ONLINE
+DATA01/bairac1/datafile/users.279.726941825        5             ONLINE

Recovery Manager complete.
[oracle@lnxrac01 bin]$ ./rman target /

Recovery Manager: Release 11.2.0.1.0 – Production on Tue Jul 26 02:05:50 2011

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

connected to target database: BAIRAC1 (DBID=749250110)

RMAN> list failure;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 07/26/2011 02:05:57
RMAN-05533: LIST FAILURE is not supported on RAC database

RMAN> exit

with the above error means we cannot use the new features of RMAN. so we need to do the old fashion way.


[oracle@lnxrac01 bin]$ ./rman target /

Recovery Manager: Release 11.2.0.1.0 – Production on Tue Jul 26 02:15:32 2011

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

connected to target database: BAIRAC1 (DBID=749250110)

RMAN> restore datafile 2;

Starting restore at 26-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 instance=bairac11 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to +DATA01/bairac1/datafile/sysaux.275.726941737
channel ORA_DISK_1: reading from backup piece /backup/backup_BAIRAC1_S_4_P_1_T_757476175
channel ORA_DISK_1: piece handle=/backup/backup_BAIRAC1_S_4_P_1_T_757476175 tag=TAG20110726T020255
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
Finished restore at 26-JUL-11

RMAN> recover datafile 2;

Starting recover at 26-JUL-11
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:04

Finished recover at 26-JUL-11

RMAN> sql ‘alter database datafile 2 online’;

sql statement: alter database datafile 2 online

RMAN> exit

check the new status of datafile.

SQL> set lines 150;
SQL> select file_name, file_id, online_status from dba_data_files;

FILE_NAME                               FILE_ID         ONLINE_
———————————————————————————————————————————-
+DATA01/bairac1/datafile/system.274.726941717         1             SYSTEM
+DATA01/bairac1/datafile/sysaux.275.726941737         2            ONLINE
+DATA01/bairac1/datafile/undotbs1.276.726941773     3             ONLINE
+DATA01/bairac1/datafile/undotbs2.278.726941805     4             ONLINE
+DATA01/bairac1/datafile/users.279.726941825        5             ONLINE

Thanks!

bai

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s