RMAN-03002-06571

We are using 11.1.0.7 Database with standby. This issue happend while applying incremental backup to DR site.

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 01/24/2012 19:24:02
RMAN-06571: datafile 104 does not have recoverable copy

When you issue RMAN > report schema command. One of the datafile shows Zero bytes

104 0 USERS *** +DATA/taral/datafile/users.600.7510420000

While this was in alertlog

Managed Standby Recovery not using Real Time Apply
Errors in file /u01/app/oracle/diag/rdbms/taral/taral1/trace/taral1_mrp0_22065.trc:
ORA-01110: data file 104: '+DATA/taral/datafile/users.600.7510420000'
ORA-01157: cannot identify/lock data file 104 - see DBWR trace file
ORA-01110: data file 104: '+DATA/taral/datafile/users.600.7510420000'

To resolve this issue copy that data file through RMAN and ship to remote location

copy datafile '+DATA/primary/datafile/users.600.7510420000' to '/backup/taral/users.600.7510420000';
scp /backup/taral/users.600.7510420000 oracle@remot:/backup/taral

Now in mount mode on DR site issue this commands in RMAN

catalog datafilecopy '/backup/taral/users.600.7510420000';
switch datafile 104 to copy;
backup as copy datafile 104 format '+DATA';
switch datafile 104 to copy;

Now when you run report schema it will report correct size.

Advertisements

About Taral
I am Rookie to Oracle Technology so let's see where it goes

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

%d bloggers like this: