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

Hot backup when the database is running, the backup behavior is called hot backup; the backup object needs to be set to the hot backup state. Backup mode, also uses the system command (cp,scp) Note: in noarchive mode, the database can not be set to hot standby state, otherwise an error will be reported when performing alter tablespace XXX begin backup operations: table space hot backup in ORA-01123:cannot start online backup;media recovery not enabledonline mode 1. Find the corresponding data file and cp to the backup destination directory. SYS@orcl11g > select tablespace_name File_name from dba_data_files where tablespace_name='TBS01' TABLESPACE_NAME FILE_NAME -TBS01 / u01/app/oracle/oradata/orcl11g/tbs01.dbf 2. Set the tablespace to hot backup state: SYS@orcl11g > alter tablespace tbs01 begin backup; 3.cp. 4. Be sure to end the status of the backup after the backup is complete; SYS@orcl11g > alter tablespace tbs01 end backup; Tablespace altered. 5. To prevent the loss of the log recording the backup status, archive the current log SYS@orcl11g > alter system archive log current; System altered immediately. How to see which tablespaces are placed in hot backup state SYS@orcl11g > alter tablespace tbs01 begin backup; Tablespace altered. SYS@orcl11g > select * from v$backup FILE# STATUS CHANGE# TIME-1 NOT ACTIVE 0 (null) 2 NOT ACTIVE 0 (null) 3 NOT ACTIVE 0 (null) 4 NOT ACTIVE 0 (null) 5 NOT ACTIVE 0 (null) 6 NOT ACTIVE 0 (null) 7 NOT ACTIVE 1758979 2013-06-21 13:52:59 8 ACTIVE 1759231 2013-06-21 13:59:06-active indicates positive and backup status Don't forget to close 9 NOT ACTIVE 0 (null) 9 rows selected. SYS@orcl11g > alter tablespace tbs01 end backup; how to back up read only,offline files these two types of tablespaces can be directly cp data files without setting begin backup, and how to set the whole database to hot backup state SYS > orcl11g > alter database begin backup; SYS@orcl11g > alter database end backup

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.