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