RMAN – add missing archivelog

3 Jul

Steps to add missing archivelog to RMAN catalog

  1. Start cmd
    • set Oracle_sid=SIDNAME
    • rman log=xx.log (write output to log file – easier to read and manipulate content)
    • connect target /
    • crosscheck archivelog all
    • exit
  2. Check xx.log forvalidation failed on which archivelog
  3. Locate the missing archivelog files
  4. Edit the xx.log files (every lines that have validation fail) to look like below:
    • catalog archivelog ‘path\archivelogfile.xxx’
  5. Run the above lines in rman to add the missing archive files


Useful link













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: