RMAN BACKUP BASIC

To enable archive log

shut immediate;
startup mount;
alter database archivelog;
alter databaser open;


-- to check archive log is enable or disables;

archive log list;


how to connect rman
1. open cmd
2. type (rman target /) or (rman target sys/password@dbname)
rman>show all;
(this command show you all rman default configuration)
TO take check is there any backup is available fire this command.
rman>list backup;  (it will show you all available backup with location )
# when take backup without mentioning backup location the default backup location is in flash recovery area( you can check flash recovery area location using command [show parameter db_recovery_file_dest] its show u FRA location then you can check location.
#HOW TO TAKE FULL DATABASE BACKUP IN DEFAULT LOCATION
rman> BACKUP DATABASE;
#HOW TO TAKE PARTICULER DATAFILE BACKUP
NOTE:- CHECK THE DATAFILE NAME AND NUMBER USING THIS COMMAND[SELECT * FROM V$DBFILE;] THEN TAKE ANY DF# NUMBER AND FIRE BACKUP FOR DATAFILE EITHER USING DBFILE NAME OR DBFILE NUMBER.

rman>backup datafile 4;
#you can take multiple datafile backup with one command
rman>backup datafile 4,5,3;

# how to take particuler tablespace backup
NOTE:- first check tablespace name using this command(SELECT * FROM V$TABLESPACE;] THEN TAKE BACKUP.

rman> backup tablespace system;


#how to take backup in specific location using rman FORMAT keyword.
rman> backup format 'd:\nashim\12_Oct_abc.bkp' database;
rman> backup format 'd:\nashim\system_20_oct.bkp' datafile 4;
rman> backup format 'd:\nashim\sysaux_tablespace.bkp' tablespace sysaux;


#how to take backup of archivelog
rman> backup archivelog all;
rman> backup archivelog from sequence 5;

# how to backup of database with archivelog;
rman> backup database plus archivelog;


#how to take controlfile backup
rman> backup current controlfile;
rman> backup format 'd:\nashim\control001.dbf' current controlfile;

NOTE:- you can also enable controlfile autobackup using rman command [CONFIGURE CONTROLFILE AUTOBACKUP ON;]

#TO CHECK LIST OF AVAILABLE BACKUP OF DATABASE OR CONTROLFILE.

RMAN> LIST BACKUP;
RMAN> LIST BACKUP OF DATABASE; [SHOW U ONLY DATABASE BACKUP]
RMAN> LIST BACKUP OF CONTROLFILE;
RMAN> LIST BACKUP OF ARCHIVELOG;
RMAN> LIST BACKUP OF TABLESPACE;


#HOW TO DELETE BACKUP.
RMAN> DELETE BACKUP;  [DELETE ALL AVAILABLE BACKUPS]
RMAN> DELETE BACKUPSET BS#; [BS# bakup set number;]



 
#To check available backup on filesystem .
RMAN> crosscheck backup;
RMAN> delete expired backup.
RMAN>
-- This is for backup validation which that available or not.

#To check obsolete backup on filesystem that is required to recover database.
RMAN> report obsolete backup;
RMAN> delete obsolete backup;