How do I back up files and archive log files?

How do I back up files and archive log files?

To backup all archived redo log files in the database, use this command:

1. RMAN> backup archivelog all; Additionally, backup of archived redo log files may be done after every backup command.
2. SQL> select.
3. RMAN> backup tablespace users plus archivelog; Starting backup at 17-AUG-09.

How do I list obsolete backup in RMAN?

To report obsolete backups:

1. Start RMAN and connect to a target database and recovery catalog (if used).
2. Execute the CROSSCHECK command to update the status of backups in the repository compared to their status on disk.

How do I list only full backups in RMAN?

By using “RMAN> LIST BACKUP;” command we are listing all the backups taken by RMAN. But we can see only FULL backup only and no INCREMENTAL backup. We were assuming if there is any RMAN configuration set to list only FULL backup and also checked the same using “RMAN> SHOW ALL;” command but did not find such setting.

What is crosscheck Archivelog all in RMAN?

2) crosscheck archive log all; The first form is used to delete entries from the rman catalog when the backup media is no longer available for restores. In this case records for the particular backup do not exist in the ARCserve database, but still have records in the rman catalog.

How do I use archive log on Old complete backup?

Apply Archive Logs to Cold Backup

1. Keep a note of locations of datafiles, control files and redo log files.
2. Check if database is in archive log mode or not.
3. Enter the desired location for archive logs and place the database in archive log mode.
4. Shut down the database to take cold backup.

What is archive log backup in Oracle?

You can use archive log backups to recover database transactions that have been lost due to an operating system or disk failure. Apply the archive logs to an online backup to recover a database. By default, full backups include both data and archive logs, but you can also perform separate archive log backups.

How do I delete old archive logs in RMAN?

Delete old archive logs using RMAN

1. Delete one day old archive logs RMAN > DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-1’;
2. Delete 30 day old archive logs RMAN > DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-30’;

How do I crosscheck backup in RMAN?

To crosscheck specified backups:

1. Identify the desired backups that you want to check by issuing a LIST command. For example, issue: LIST BACKUP; # lists all backup sets, proxy copies, and image copies.
2. Check whether the specified backups still exist.