Oracle OCP 1Z0 053 Q608(User-managed Backup)

608.You are managing a 24*7 database. The backup strategy for the database is to perform
user-managed backups.
Identify two prerequisites to perform the backups. (Choose two.)
A. The database must be opened in restricted mode.
B. The database must be configured to run in ARCHIVELOG mode.
C. The tablespaces are required to be in backup mode before taking the backup.
D. The tablespaces are required to be in read-only mode before taking the backup
Answer: BC


參考：http://blog.csdn.net/rlhua/article/details/11850629
        https://docs.oracle.com/cd/B10501_01/server.920/a96572/osbackups.htm#10014


使用者管理備份：備份表空間步驟：
1. 將表空間置於備份模式
   

SQL> ALTER TABLESPACE users BEGIN BACKUP;

 
2. 拷貝資料檔案

% cp /oracle/dbs/tbs_21.f /oracle/backup/tbs_21.backup

3. 結束表空間備份模式

SQL> ALTER TABLESPACE users END BACKUP;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2073506/，如需轉載，請註明出處，否則將追究法律責任。