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

Dameng database backup mode: physical backup, logical backup

Physical backup

Cold backup: (database is closed when dmap service is open)

Hot backup: (dmap service must be open, database must be open, database should be archived) logical backup

Import and export: dexp dimp

Cluster: data guardian (dw), DSC (RAC)

Dameng supports third-party backup tools: for example, third-party backup all-in-one backup must first be archived.

SQL > alter database mount; # mount status

SQL > alter database add archivelog 'type=local,dest=/dm7/arch,file_size=64,space_limit=0'; # set the archive path

SQL > alter database archivelog; # start archiving

Related commands for viewing

SQL > alter database open; # open status

SQL > select name,status$,ARCH_MODE from vault database; # check the status of the database

SQL > select * from vaulted archetype; # check the archiving parameters. Also open business and use tools to open archives.

Backup

Make backups through dmrman

Dmap needs to be enabled and the database instance is closed.

Complete and incremental standby in command line mode

SQL > backup database full backupset'/ dm7/backup/full_bak'

SQL > select checkpoint (0)

SQL > backup database increment backupset'/ dm7/backup/incr_bak'

Backup database increment backupset'/ dm7/backup/incr_bak'; uses management tools for hot standby

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.