OCP 11gR2: Administration II 練習筆記 (二)

Lession 02:
===========================================================
1. Create recovery catalog instance
create "rcat" instance by dbca or slient mode

require
- no archivelog mode
- no sample
- SGA 500MB


silent mode:
1.1 Set and check OS variables
export DISPLAY=IPADDR:0.0
export ORACLE_SID=rcat
echo $ORACLE_SID
echo $ORACLE_BASE
echo $ORACLE_HOME

1.2 Create a response file dbca_createDB.rsp
------------------------------------------
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]
GDBNAME = "rcat"
SID = "rcat"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "password"
SYSTEMPASSWORD = "password"
SYSMANPASSWORD = "password"
DBSNMPPASSWORD = "password"
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "UTF8"

1.3 Run dbca in slient mode
dbca -silent -responseFile dbca_createDB.rsp
tail the log file "/u01/app/oracle/cfgtoollogs/dbca/rcat/rcat0.log" for details.


2. Create recovery catalog owner
- create tablespace rcat_ts datafile 'location' size 500M;
- create user rcowner identitied by rcpass temporary 
  tablespace temp default tablespace rcat_ts quota unlimited on rcat_ts;
- grant recovery_catalog_owner to rcowner;

also check recovery_catalog_owner privilege



3. create recovery catalog
RMAN> create recovery catalog;
RMAN> register database;
select * from dbinc;



4. Manuel Resync concept
- After the recovery catalog was unavailable for RMAN
- Infrequent backup target database
- Making change structure of target database (like add/modify datafile)


5. Stored script
RMAN> create global script backup_db
2> {
3> crosscheck backup;
4> delete force noprompt backup;
5> backup as compressed backupset database current controlfile plus archivelog;
6> sql 'alter system archive log current';
7> }

- run script
run {execute script backup_db;}

list script names;
print global script backup_db;
delete global script backup_db;

6. backup recovery catalog
you can backup recovery catalog by controlfile base or use data pump

- use data pump
on target :
SQL> create or replace directory tempdir as '/tmp';
SQL> grant read,write on directory tempdir to rcowner;
# expdp rcowner/rcpass@rcat directory=tempdir dumpfile=rcowner.dmp logfile=exp.log schemas=rcowner
on destination:
SQL> create or replace directory tempdir as '/tmp';
SQL> grant read,write on directory tempdir to rcowner;
# impdp rcowner/rcpass@rcat directory=tempdir dumpfile=rcowner.dmp logfile=imp.log schemas=rcowner


7. Convert base recovery catalog to virtual private catalog (VPC based on base catalog)
- unregister database from base catalog
- create user vpcowner and grant recovery catalog role to vpcowner
- connect base catalog with rcowner
- grant register database to vpcowner in RMAN
- connect base catalog with vpcowner
- create virtual catalog
- connect target and catalog by vpcowner & register database
.
VPC information can query by
select * from rcowner.vpc_users;
select * from rcowner.vpc_databases;


8. config backup parameter
enable controlfile autobackup
config controlfile backup to other location
config device type disk|sbt  -- SBT = system backup to tape
config duplex backupset(datafile, archivelog)
config backup optimization


9. abort backup optimization
- RMAN中的備份優化(Backup Optimization)是指在備份過程中，如果滿足特定條件，RMAN將自動跳過某些文件而不將它們包含在備份集中以節省時間和空間。說的直白些就是能不備的它就不備了，不像原來甭管文件有沒有備份過統統再備一遍。

通常必須滿足如下幾個條件的情況下，才能夠啟用備份優化的功能：
CONFIGURE BACKUP OPTIMIZATION參數置為on；
執行的BACKUP DATABASE或BACKUP ARCHIVELOG命令中帶有ALL或LIKE參數。
分配的通道僅使用了一種設備類型，也就是沒有同時分配使用sbt與disk的多個通道。
那麼在進行備份優化時，RMAN是如何判斷要備份的文件是否需要被優化呢，這個算法就相當複雜了，而且可能影響優化算法的因素也非常多，假如某庫在上午9點被執行過一次全庫備份，等下午3點再次執行全庫備份時，備份的文件沒有變動而且也已經被備份過時，才會跳過這部分文件。所以理論上備份優化僅對於只讀表空間或offline表空間起作用。當然對於已經備份過的archivelog文件它也會跳過。

- The retention policy has an effect on which files backup optimization skips.

- BACKUP DEVICE TYPE sbt BACKUPSET ALL FORCE;
  can override backup optimization and back up all files whether or not they have changed

10. encrypt backup
about encrypt backup, OCP material not mention too much, refer to below URL for details.
Transparent Data Encryption


11. Oracle advance compression
about the OAC, OCP material also not mention too much, refer to below URL for details.
Oracle Advanced Compression



OCP 11gR2: Administration II 練習筆記 (三)
OCP 11gR2: Administration II 練習筆記 (一)