Database Administration (MOSC)

MOSC Banner

V$ARCHIVED_LOG always has only 380 records. but there are more archive logs present on disk.

edited Jan 29, 2019 4:07AM in Database Administration (MOSC) 10 commentsAnswered

Hi Guys,

Its been more than 2 months, since we enabled archive logs on oracle database 12c.

Archive logs are generated at regular interval daily approx 20 archive log files.

On physical database under archive folders I can see 1000+ archive logs since the day we enabled archive logs but when I query on

V$ARCHIVED_LOG table. I am able to see only 380 records.

Also the commands: RMAN> list expired archivelog all; does not show any records from repository.

even when i do RMAN> ALTER SYSTEM SWITCH LOGFILE; an additional log file in next sequence is created. This record is visible on both disk and V$ARCHIVED_LOG. However the table still has 380 records. The oldest record line is deleted from this table.

Tagged:

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center