- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
how to list archivelogs that need backup
Can someone help me with RMAN command. I would like to rman command syntax only for the following scenarios.
I have archivelogs the disk , sequence = 40, 41, 42 , 43
and say, I backed up only sequence 41 file.
next time I want to list (not backup) which archivelogfiles have not been backed up since the last backup (which was sequence 41 was backedup).
I would like to be able to list 40, 42. 43 that needed to be backed up as a list in the RMAN.
I understand that I can look at find from v$archived_log view and I can backup using (backup archivelog all not backed up 1 times to device type disk - i am ok with this).
I need to be able to list the archivelogs that need backup from existing disk-directory of archivelog files from RMAN prompt.
please help me with the command syntax. I appreciate it.