 |
| 首页 > 编程 > 数据库 > oracle |
1
1楼 welong 2007-03-19 17:07:45 最好有详细的步骤 2楼 love_2008 2007-03-23 15:30:53 exp/imp吗？？ 还是其他 这个应该差不多吧 3楼 bjt_ 2007-03-24 14:39:07 rman 4楼 hdyd 2007-06-18 14:20:41 Backing Up an ARCHIVELOG Database特别需要注意一点： When you perform this initial whole database backup, make sure that the database is in ARCHIVELOG mode first. Otherwise, the backup control files will contain the NOARCHIVELOG mode setting. 5楼 hdyd 2007-06-19 09:58:00 When you restore a datafile, the header has a record of the most recent datafile checkpoint that occurred before the online tablespace backup, not any that occurred during it. As a result, Oracle asks for the appropriate set of redo log files to apply should recovery be needed.
下面是详细步骤 To back up online read-write tablespaces in an open database: Before beginning a backup of a tablespace, identify all of the tablespace 's datafiles using the DBA_DATA_FILES data dictionary view. For example, assume that you want to back up the USERS tablespace. Enter the following: SELECT tablespace_name, file_name FROM sys.dba_data_files WHERE tablespace_name = 'USERS '; TABLESPACE_NAME FILE_NAME ------------------------------- -------------------- USERS /oracle/dbs/tbs_21.f USERS /oracle/dbs/tbs_22.f In this example, /oracle/dbs/tbs_21.f and /oracle/dbs/tbs_22.f are fully specified filenames corresponding to the datafiles of the USERS tablespace. Mark the beginning of the online tablespace backup. For example, the following statement marks the start of an online backup for the tablespace USERS: ALTER TABLESPACE users BEGIN BACKUP; -------------------------------------------------------------------------------- WARNING: If you forget to mark the beginning of an online tablespace backup, or neglect to assure that the BEGIN BACKUP statement has completed before backing up an online tablespace, then the backup datafiles are not useful for subsequent recovery operations. Attempting to recover such a backup is risky and can return errors that result in inconsistent data. For example, the attempted recovery operation will issue a "fuzzy files " warning, and lead to an inconsistent database that will not open. -------------------------------------------------------------------------------- Back up the online datafiles of the online tablespace using operating system commands. For example, UNIX users might enter: % cp /oracle/dbs/tbs_21.f /oracle/backup/tbs_21.backup % cp /oracle/dbs/tbs_22.f /oracle/backup/tbs_22.backup After backing up the datafiles of the online tablespace, indicate the end of the online backup using the SQL statement ALTER TABLESPACE with the END BACKUP option. For example, the following statement ends the online backup of the tablespace USERS: ALTER TABLESPACE users END BACKUP;
搜索墙@2009 www.pkwall.com all rights reserved QQ:276471788 [京ICP备09111534号]
声明:本站部分数据来源于网络，仅供参考，如有版权问题，请联系我们，我们将及时删除!转载本站请注明来源
| |||||