Sunday, December 28, 2014

How to make backup using RMAN.

How to make backup using RMAN.
At first, go to cmd with “run as administrator” mode.
Ø  SET ORACLE_SID=target_db_name
Go to sqlplus:
Ø  shutdown immediate;
Ø  startup mount;
Ø  alter database archivelog;
Ø  alter database flashback on;
Ø  alter database open;
Ø  select name from v$database;
Ø  select name from v$datafile;
(here shows all datafile file location)
now Again go to CMD with run as administrator” mode.
Ø  SET ORACLE_SID=target_db_name
Ø  rman target /
(by typing this rman is now on)
rman:
Ø  show all;
(all parameter is shows )
Ø  backup as copy datafile ‘data_file_location’;
(data file is now in backup, and by default it is on the flash recovery area/target_db/backupset)
Ø  backup database plus archivelog;
(Full database backup now)
Ø  list backup; (to show all backup)
Ø  list copy of database; (to show image copy of database)
sqlplus:
Ø  show parameter recovery;
(its shows all backup file location with detail)

Can Take Backup of that file:
1.      control file
2.      data file
3.      archivelog file
4.      sp file

5.      password file