Oralce backup and recovery!

Oracle database backup and recovery

Backup
1. Conn sys/*** as sysdba
2. Select dbid, name, log_mode, current_scn from V $ database; -- Note that if log_mode is noarchivelog, perform the following operations.
3. Select name from V $ datafile Union select name from V $ controlfile; -- searches all data files and control files.
4. Shutdown immediate
5. Host copy
6. startup

Restore
1. Conn sys/*** as sysdba
2. Shutdown immediate
3. Host copy
4. startup Mount
5. revover database until cancel
6. Alter database open resetlogs

Logical backup and recovery
1. create directory dump dir as 'd: Dump ';
Grant read, wirte on directory dump_dir to Scott;

2. Run in DOS environment
3. D: oracleproduct10.1.0db _ 1bin> expdp zzh48182/z86589947 tables = ttextperson directory = test_dir dumpfile = ttextperson. dmp

4. D: oracleproduct10.1.0db _ 1bin> impdp zzh48182/z86589947 directory = test_dir dumpfile = ttextperson. dmp tables = ttextperson remap_schema = zzh48182: rhx