USER MANAGED BACKUP AND RECOVERY

NOTE:- USER MANAGED BACKUP(OFFLINE AND ONLINE(COLD|HOT)(CONSISTENT|INCONSISTENT))

#COLD USER MANAGED FULL DATABASE BACKUP STEPS
1.SHUT IMMEDIATE|NORMAN|TRANSACTIONAL
2. COPY ALL DATAFILES AND PASTE ANY LOCATION WHERE U WANT TO PUT YOUR BACKUP.
3.STARTUP

#HOT USER MANAGED FULL DATABASE BACKUP STEPS
1.ALTER DATABASE BEGIN BACKUP;
2. COPY ALL DATAFILES AND PASTE BACKUP LOCATION.
3.ALTER DATABASE END BACKUP;


#COLD TABLESPACE BACKUP USING USER MANAGED BACKUP STEPS.
1. ALTER TABLESPACE ABC OFFLINE;
2. COPY DATAFILE OF PARTICULAR TABLESPACE AND PASTE BACKUP LOCATION.
3. ALTER TABLESPACE ABC ONLINE;

NOTE:-TO CHECK WHICH DATAFILE BELONGS TO WHICH TABLESPACE
SELECT   t.NAME "Tablespace", f.NAME "Datafile"
FROM     V$TABLESPACE t, V$DATAFILE f
WHERE    t.TS# = f.TS#
ORDER BY t.NAME;

#RMAN ONLINE BACKUP FULL DATABASE.
RMAN>BACKUP DATABASE;     - DEFAULT LOCATION FLASHRECOVER AREA.

#RMAN COLD (OFFLINE BACKUP)
1. SHUTDONW IMMEDIATE;
2. STARTUP MOUNT;
RMAN TARGET /
RMAN>-- NOW DATABASE IS IN MOUNT STATE
RMAN>BACKUP DATABASE;     -THIS IS COLD BACKUP THROUGH RMAN.....



#IF YOU LOSE ONE OR MORE DATAFILE AND NOW YOU WANT TO COMPLETE RECOVERY THROUGH USERMANGED. STEPS

1. SHUT IMMEDIATE
2. COPY BACKUP FILE AND PASTE ORIGINAL DATAFILE LOCATION.
3. STARTUP MOUNT;
4. RECOVER DATABASE ;
5. ALTER DATABASE OPEN;


#IF YOU LOSE ONE OR MORE DATAFILE AND NOW U WANT TO COMPLETE RECOVERY THROUGH RMAN BACKUP.

1. SHUT IMMEDAITE;
2. STARTUP MOUNT;
3. CONNECT RMAN PROMPT  (RMAN TARGET /)   -- NOW YOUR DATABASE IN MOUNT STAGE.
4. RESTORE DATABASE;
5. RECOVER DATABASE;
6. ALTER DATABASE OPEN;   -- DATABASE IS NOW RECOVERD....