RMAN: Basic RMAN Commands (2024)

5) Toforce RMANto back up a file regardless of whether it’s identical to a previously backed up file by specifyingthe force option

6) To backup complete database

RMAN> backup database;

7) To backup database plus archivelogs

1) To find out which backups you needto make in order to conform to the retention policy you put in place

RMAN> report need backup;

2) Toget a report about all the datafiles in a database

RMAN> report schema;

RMAN> report schema at time ‘sysdate-1′;(from a pastpoint in time)

3) Toreports on any obsolete backups

Always run the crosscheckcommand first in order to update the status of the backups in the RMAN repository to that ondisk and tape.

**LIST COMMAND**

1) To review RMAN backups of datafiles, archived redo logs, and controlfiles.

RMAN> list backup;

2) List the backups by just the backup files

3) Lists only backup sets and proxy copies but not image copies

5) Lists backups by tag:

6) Tolist the backups of all datafiles and archivelogs of the target database:

10) Which of the backups of the target database havean expired status in the repository.

**CROSSCHECK COMMAND**

RMAN> crosscheck backup;

The crosscheck command checks whether the backups still exist. The command checksbackup sets, proxy copies, and image copies.

RMAN> delete backup;

RMAN always prompts you for confirmation before going ahead and deleting the backupfiles. You can issue the delete noprompt command to suppress the confirmationprompt. This will also remove the physical file from the backup media

2) To remove all image copies

RMAN> delete copy;

3) To delete specfic backuppiece

RMAN> delete backuppiece 9;

4) To delete copy of controlfile under /backups

RMAN> delete copy of controlfile like ‘/backups/%’;

5) To delete backups with specific tag

RMAN> delete backup tag=’double_bkp_prod’;

6) To delete bakups of specific tablespace

RMAN> delete backup of tablespace sysaux device type sbt;

******************

You can also use force, expired, obsolete keyword with delete commad:

delete force..: Deletes the specified files whether they actually exist on media or not andremoves their records from the RMAN repository as well

delete expired..: Deletes only those files marked asexpired as per crosscheck command.

delete obsolete..: Deletes datafile backups and copies and the archived redo logs and logbackups that are recorded asobsoletein the RMAN repository

The delete obsolete command relies only on the backup retention policy in force.

******************

7) To delete all archived redo logs

RMAN> delete archivelog all;

8) Todelete already backed up archived redo logs

RMAN> delete archivelog allbacked up 2 times to sbt;

9) To delete specific archived redo logs

RMAN> backup device type sbtarchivelog alldelete all input;

11) Delete stored script

RMAN>delete scriptfull_disk_db;

If you have two scripts—one local and one global—in the same name, then the deletescript command drops the local one, not the global one. If you want to drop the global script,you must use the keyword global in the command, as shown here:

RMAN> delete global scriptfull_disk_db;

**CHANGE COMMAND**

RMAN> change backupset 6 unavailable;

You usually do it when youdon’t want to delete the backup/copy but you alsodon’t want to delete that backup/copy (probably it is not available physically on disk)

Once you mark a backup file unavailable, RMAN won’t use that file in a restore or recoveroperation.

2) Change the status of abackup set to available again

RMAN> change backupset 6 available;

Forexample, say you performed a backup using an NFS-mounted disk and that disk subsequentlybecomes inaccessible for some reasons, justissue the change command to set the status of the backup as unavailable. Later, oncethe disk becomes accessible again, you can change its status back to available.

3) To modify a regular consistent database backup into anarchival backup:

RMAN> change backup tag ‘initial_db_bkup’keep forever;

When you make an archival backup with the keep … forever option, RMAN disregardsthe backup retention time for these backups.

4) To change the archival backup to a normal database backup

RMAN> change backup tag ‘inital_db_backup’ nokeep;

When you run the change … nokeep command,the backup set with the tag inital_db_backup, which was previously designated as a long termarchival backup, will once again come under the purview of your configured retentionpolicy.

5) To modify the time period for which you want to retain the archival backups

RMAN> change backupset 12 keep until time ‘sysdate+60′;

3) To validate a single backup set

RMAN> validate backupset 5;

4) To validate all datafiles at once

The validate command always skips all the data blocks that were never used, in each ofthe datafile it validates.

5) To validate recovery area

RMAN>validate recovery area;

6) To validate all the recovery related files

RMAN>validate recovery files;

7) To validate the spfile

RMAN>validate spfile;

8) To validate specific tablespace

RMAN>validate tablespace <tablespace_name>;

9) Tovalidate specific control file copy

RMAN>validate controlfilecopy <filename>;

10) To validate specific backupset

RMAN>validate backupset <primary_key>;