Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

cannot recover copy of database

248 views
Skip to first unread message

helter skelter

unread,
Jan 13, 2009, 2:40:49 PM1/13/09
to
hi,

I've got simple rman backup script:

allocate channel c1 device type disk;
backup incremental level 1 for recover of copy with tag='DB' database;
recover copy of database with tag='DB';
release channel c1;
...

Everything works fine until I've started doing some other backups to the
tape. Now when I run this script I got error:

RMAN-05019: WARNING: no channel of required type allocated to recover
copy of datafile [all_datafile_copies]

I've run crosscheck backup/copy, delete expired, delete obsolete - on
device type disk and tape too.

When I list copy of database, everything looks fine, copy is on device
type DISK, available etc. Also backup made for recover of this copy is
fine and it's on device type disk.

What's wrong?

thanks

===

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #
default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

oracle 10.2.0.3, rhel5

joel garry

unread,
Jan 13, 2009, 6:15:23 PM1/13/09
to

This sounds like not-a-bug-with-no-explanation 5405227

The workaround is to allocate both tape and disk channels to allow
rman to think they are checking them.

This sounds bogus to me, you should open a support call and get a
better answer.

jg
--
@home.com is bogus.
http://it.slashdot.org/article.pl?no_d2=1&sid=09/01/13/2055211

helter skelter

unread,
Jan 14, 2009, 3:31:46 AM1/14/09
to
joel garry pisze:

>>
>> oracle 10.2.0.3, rhel5
>
> This sounds like not-a-bug-with-no-explanation 5405227
>
> The workaround is to allocate both tape and disk channels to allow
> rman to think they are checking them.
>
> This sounds bogus to me, you should open a support call and get a
> better answer.
>
> jg
> --
> @home.com is bogus.
> http://it.slashdot.org/article.pl?no_d2=1&sid=09/01/13/2055211

Thanks, it works.
I have also found another workaround:

recover datafilecopy 'file_name';

but allocating additional channel is more economical then specyfing all
datafilecopy names :)

cheers

0 new messages