- 论坛徽章:
- 0
|
http://docs.oracle.com/cd/E11882 ... backup.htm#BRADV199
chapter 28.
为什么每次最后 oracle 都要加这句话:
- Take the tablespace offline using normal priority if possible, because it guarantees that you can subsequently bring the tablespace online without having to recover it. For example:
- SQL> ALTER TABLESPACE users OFFLINE NORMAL;
- Back up the offline data files. For example:
- % cp /oracle/oradata/trgt/users01.dbf /d2/users01_'date "+%m_%d_%y"'.dbf
- Bring the tablespace online. For example:
- ALTER TABLESPACE users ONLINE;
- Note:
- If you took the tablespace offline using temporary or immediate priority, then you cannot bring the tablespace online unless you perform tablespace recovery.
- Archive the unarchived redo logs so that the redo required to recover the tablespace backup is archived. For example, enter:
- ALTER SYSTEM ARCHIVE LOG CURRENT;
复制代码 ALTER SYSTEM ARCHIVE LOG CURRENT; why 进行这个操作呢? |
|