[Backup and recovery] for Oracle databases]

Rman features are powerful and operations are relatively complicated. For common developers, it is generally not required for daily work. interested colleagues can view Oracle-related resources.

Rman features are powerful and operations are relatively complicated. For common developers, it is generally not required for daily work. interested colleagues can view Oracle-related resources.

I. Physical backup tool rman (Recovery Manager)

Rman features are powerful and operations are relatively complicated. For common developers, it is generally not required for daily work. interested colleagues can view Oracle-related information for details.

Ii. Logical backup tool exp & imp

Exp & imp tool programs are easy to use and are generally used by database-related developers. This course mainly introduces exp & imp.

Iii. Data Loading tool SQL Loader

SQL Loader is mainly used to load text files to the database.

Next we will focus on exp & imp
1. Precautions for using exp & imp
To use exp and imp, you must ensure that the character set of the server and client is consistent. When exporting through exp, the Client Version is best consistent with that of the server, the database version recovered through imp cannot be lower than the original database version.

-- 2. Back up the specified table

-- 3. Backup by user

-- 4. Full-Database Backup

-- 5. Back up the specified tablespace

-- 6. Export based on conditions

-- 7. Restore the data of the specified table from the backup file

-- 8. Restore the entire backup file

The following describes the data loading tool SQL Loader.
1. Basic Steps
Data migration using SQL Loader is generally divided into three steps:
1. Generate a text file.
2. Write control files.
Third, the import command.
2. Write Control Files
Load data infile "D: \ t_card_bill.txt"
Append into table t_Card_bill fields terminated ','
Optionally enclosed '"'
(Uaccountno, billtype, clerk, serviceno, fee_date 'yyyy-MM-DD HH24: MI: ss ',
Fee_enddate date 'yyyy-MM-DD HH24: MI: ss', caller_number, called_number, duration)
3. Import commands
Sqlldr username/password @ database control = control file path \ control File Name
Readsize = 5000000 bindsize = 5000000 rows = 1000