Shulou(Shulou.com)06/01 Report--

Backup classification: physical backup (database file, log file, control file, etc.), logical backup (backup of database logical components, such as tables, views, stored procedures, etc.); physical backup is more complex

Fault classification: 1 statement fault, automatically handled by oracle server-side program 2. User process failure: server-side process PMON shuts down the corresponding server-side process, users do not need to participate in 3 instance failures: restart server 4. Media failure: need to be handled by the client

Export command: exp, backup database object definitions and data to a binary file; is a client tool, also stored on the client (dmp format file)

Export mode: 1. Table mode, which specifies the table 2. 0 to be exported through the tables parameter. User mode, which exports all the objects of the user, and specifies 3. 0 through the owner parameter. Tablespace schema: export tablespace 4. Database schema, exporting the entire database, specified by the full=y parameter

Import command: imp command with parameters similar to exp

Transferable tablespace: suitable for migrating a large amount of data; you need to check whether the tablespace is self-contained and the tablespace is read-only.

Export pump expdp: more efficient than exp in large quantities

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.