Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

archived log status applied is yes and no

DurmicMar 28 2014 — edited Apr 8 2014

Hi,

I'm having problem with my rman backup. The database version is 11.2.0.3

The Rman hangs when he is trying to backup archive logs.

I use

backup as compressed backupset archivelog all delete input;

I wanted to see the status of the archived logs and I get this:

select sequence# from v$archived_log where applied='YES';

SEQUENCE#

----------

19473

19474

19475

19476

19477

19478

19479

19480

19481

19482

19483

SEQUENCE#

----------

19484

19485

19486

19487

19488

19489

19490

19491

1119 rows selected.

SQL>

SQL> select sequence# from v$archived_log where applied='NO';

SEQUENCE#

----------

19473

19474

19475

19476

19477

19478

19479

19480

19481

19482

19483

SEQUENCE#

----------

19484

19485

19486

19487

19488

19489

19490

19491

19492

1121 rows selected.

How is this possible?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2014

Added on Mar 28 2014

#performance-availability, #recovery-manager-rman

13 comments

6,071 views