Database - RAC/Scalability (MOSC)

MOSC Banner

v$archived_log view issue

edited Sep 18, 2020 3:49AM in Database - RAC/Scalability (MOSC) 7 commentsAnswered

Hi All

I have restored database using rman backup and it open using 'alter database open resetlogs'.After the successful restoration below commands show different sequence no.What is the reason of that and how solve that issue

Note-OS oracle linux 6.9

database version enterprise edition  12.2.0.1.0

SQL> select max(SEQUENCE#),THREAD# from v$archived_log group by THREAD#;

MAX(SEQUENCE#)    THREAD#

-------------- ----------

         13234          1

         10484          2

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     95

Next log sequence to archive   96

Current log sequence           96

SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center