最好有详细的步骤
解决方案 »
- Oracle 数据重复问题
- 求SQL 语句
- 更改视图,会影响到表吗?
- 执行一个存储过程得到一个结果集,怎样对这个结果集进行再次筛选?
- 求助:两表之间更新备份,更新多个字段,uodate触发器应该怎么写,具体见内,ths。
- 各位老大,这种语句怎么写
- 请问怎样向clob类型的字段里插入数据,在线等!
- ORA-09817: Write to audit file failed.错误
- 这个视图如何建立?
- 我用的是ORALCE9的WINDOWS版本, 我想问一下在哪能查到一个例程启动和关闭的日志.
- ALTER TABLESPACE users OFFLINE NORMAL;
- oracle中clob与分组的冲突
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.
下面是详细步骤
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.fIn 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 s the start of an online backup for the tablespace USERS: ALTER TABLESPACE users BEGIN BACKUP;
--------------------------------------------------------------------------------
WARNING:
If you forget to 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.backupAfter 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;