List Command :
1)RMAN> list backup;
List all your backup sets.
2)RMAN>LIST BACKUPSET;
Lists only backup sets and proxy copies.
3)RMAN>LIST COPY;
Lists of Image copies and Archive Logs.
4)RMAN>LIST EXPIRED BACKUP;
Backups did not found after crosscheck. That is backup is manually moved or deleted from OS.
5)RMAN>LIST BACKUP BY FILE;
List backup by Datafile, controlfile, spfile.
6)RMAN>LIST BACKUP SUMMARY;
Lists backup sets, proxy copies, and disk copies.
7)RMAN>LIST BACKUP OF DATABASE;
LIST BACKUP LIKE ‘/tmp/%’; list backup of datafile 1; LIST ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;LIST COPY OF DATAFILE 2 COMPLETED BETWEEN ’17-MAR-2008′ AND ’22-MAR-2008′; are also available.
8) RMAN>LIST INCARNATION;
LIST INCARNATION OF DATABASE; to see the incarnations of your database.
Report Command:
RMAN REPORT command analyzes the available backups and return results about while files need backup which files are obsolete etc.
1)REPORT NEED BACKUP;
Determine which database files need backup under a specific retention policy.
2)REPORT UNRECOVERABLE;
Report which database files require backup because they have been affected by some NOLOGGING operation.
3)REPORT SCHEMA;
Lists and displays information about the database files.
4)REPORT OBSOLETE;
REPORT OBSOLETE displays the backups that are obsolete according to the current retention policy.
5)REPORT NEED BACKUP RECOVERY WINDOW OF 2 DAYS DATABASE SKIP TABLESPACE data01;
If you use Recovery Catalog then past data can be shown.Like, REPORT SCHEMA AT TIME ‘SYSDATE-10’;
Delete Command:
Delete commands is used to delete any backup or backupsets.
1)RMAN> delete backupset all;
Delete all your backup sets
2) RMAN> delete copy all;
Delete all image copies.
3) RMAN>DELETE OBSOLETE;
Delete obsolete Backups.
==========================================================================================================================
Basic Rman (Recovery manager) Guide
Today we are gonna talk about Oracle Rman ( Recovery Manager) This tools from oracle makes backup and restore database looks easily , If you lose you data it will be problem so oracle provide solution for this issue
Rman is Command line tools that gives you lot of benefits for backup
such as backup database, control file , archive log , create scripts … etc
you can connect to the following types of databases.
Target database :
RMAN connects you to the target database with the SYSDBA privilege. If you do not have this privilege, then the connection fails.
Recovery catalog database:
This database is optional, you can also use RMAN with the default NOCATALOG option.
Auxiliary database :
You can connect to a standby database, duplicate database, or auxiliary instance (standby instance or tablespace point-in-time recovery instance.
Connecting to the Target Database
rman target /
Information About your Schema And display datafiles Currently In the target database .
RMAN>REPORT SCHEMA;
To list the backup sets and image copies that you have created, run the list command as follows:
RMAN> LIST BACKUP;
To list image copies, run the following command:
RMAN> LIST COPY;
Show Rman Confurgation :
RMAN>Show all ;
List All the backup has been taken by Rman :
RMAN>list backupset ;
Validate Your backup that has been taken By Rman , to check there’s no corrputed file in it :
RMAN>validate backupset
