Logic Backup Use Oracle's logical backup tool EXP to logically backup, this backup method The user data volume is less than 2G, such as a table that can be backed up separately; example: c: c: /> exp Name / mima @ SID Owner = name compress = y file = d: /orcl.dmplog=d: /orclog.log buffer = 900000 or c: /> exp Name / mima @ sidcompress = y file = d: /exp.dmp compress = y tables = (Table1, Table2);
Cold backup 1, stop listening; 2. Close the database [Note] Cannot be closed in an Abort mode 3, using the CP, RCP, or TAR and other operating system commands, copy / ORADATA directory all files to backup directories or tapes; for example: CP ( Copy command) CP / ORADATA / ORABACKUPRCP (Remote Copy Command, Requires Trust Relationship) On another trusted host RCP SUNDB: / ORADATE / ORABACKUPTAR (Archive Command) CD / ORADATTAR-CVF ./ / ORABACKUP / 20031206. TAR4, launch database; 5, start listening; cmd exporting EXP user / password @ service name full = c: /test.dmp (full-all warehouse / Tables (TABLENAME) - Table)
Import IMP User / Password @ service name file = c: /test.dmp batch task plan, implement periodic backups such as writing the EXP backup command to XX.BAT then join the Windows scheduled task header name multi-table backup, Such as XX_A, XX_B can be used for both
