2020-10-13

2020-10-12 自學

[Oracle 11g](https://www.bilibili.com/video/BV15b411s7sW?p=66&t=917)
事務
    https://blog.csdn.net/sun8112133/article/details/89839573
    https://blog.csdn.net/sun8112133/article/details/89839573
    https://www.cnblogs.com/jyroy/p/11106609.html
鎖
索引
同義詞
ROWNUM ROWID
    https://www.cnblogs.com/aspirant/p/9214645.html
    https://blog.csdn.net/yu102655/article/details/52370542
約束
閃回
動態效能檢視 | 檢視 | 資料字典

上午

預習

curriculum context 課程背景
RAC 
Data Guard
complement 補足
encrypted 加密

day01
Unit I: Introduction and Configuration
1. Introduction
2. Getting Started
3. Configuring for Recoverability
4. Using the RMAN Recovery Catalog

day02
Unit II: Backup
5. Backup Strategies and Terminology
6. Performing Backups
7. Improving Your Backups
8. Creating RMAN-Encrypted Backups
Unit III: Recovery
9. Diagnosing Failures
10. Restore and Recovery Concepts

day03
11. Performing Recovery, Part 1
12. Performing Recovery, Part 2
Unit IV: Additional Technologies
13. RMAN and Oracle Secure Backup
14. Using Flashback Technologies

day04
15. Flashback Database
16. Transporting Data
17. Performing Point-in-Time Recovery
18. Duplicating a Database
19. RMAN Troubleshooting & Tuning

day05
Unit V: Real-Life Hands-on
20. Backup and Recovery Workshop

criticality 
granularity 
down time 
disasters
outages
failures
corruptions
pieces 件

Lesson 01. Using Database Resource Manager

assess 評估
Oracle Secure Backup
Oracle Data Guard
Oracle Maximum Availability Architecture
Curriculum Context
disk tape 磁碟 磁帶
資料恢復 前滾 回退
Flashback Technologies
data duplication 
recoverability 可恢復性
Wallet 128
transpoting
point-in-time 時間點
troubleshooting 故障排除
extreme availability
[ADO](https://www.oracle.com/lad/technical-resources/articles/database-performance/automatic-data-optimization.html)
consolidation 鞏固
prioritize
critical
RPO RTO
down time 宕機時間
tiered 分層
granularity 粒度
保留策略
on-site
off-site 站點外
故障分類
    開發人員
    POMN
    網管
    管理員
    管理員
    管理員
offline 離線
checksum  
DBC
exceeded 過度的
成本 錢
disaster
dashboard
OSB Oracle Secure Backup 單獨安裝
RMAN Oracle Recovery Manager
Amazon 
intrinsic 內在的
leveraging 槓桿作用
heterogeneous 各種各樣的
centralized
[Oracle 雲服務](https://www.oracle.com/cn/index.html)
DG
容災系統
重做流
Real Application Clusters(RAC)  Data Guard  GoldenGate
塊媒介恢復
零宕機應用
up-to-date
out-of-date
異地備庫
revenue 收入
productivity

實驗環境
    orcl
    emrep em12rep
    rcat 

    vi /etc/oratab
    rcat Y

Lesson 02. Getting Started

prerequisite 前提
dirty
incremental 增量檢查點
10W資料 4W寫入 故障 
PMON 當使用者程序失敗時執行程序恢復
ARCn 複製redo紀錄檔檔案以指定儲存裝置
（非）歸檔模式
ASM
Oracle Automatic Storage Management
notification 通知
19c
facilitating 促進
dependency
crsctl
srvctl
    srvctl stop database -d orcl -o abort
asmcmd
wizards
obtool

explicitly 明確的
rman target "'/ as sysbackup'"
範例恢復和歸檔紀錄檔沒有關係
還原 恢復

下午

預習

Security Credentials 


Lesson 1: Introduction
1-1 Exploring the Course Environment
pgrep -lf pmon
lsnrctl status
select name,log_mode,db_unique_name from v$database;
select user from dual;


Lesson 2: Getting Started
2-1 Backing Up in NOARCHIVELOG Mode
rman target "'/ as sysbackup'"
select name,dbid,log_mode from v$database;
select user from dual;
show all;
backup database;
shutdown immidate;
startup mount;
backup database;
alter database open;
list backup;
delete obsolete;

2-2 Creating a Test Case for Recovery
select * from bar22.barcopy;
archive log list;
shutdown abort;
pgrep -lf pmon
rm /u01/backup/orcl/bar22tbs01.dbf

2-3 Recovering in NOARCHIVELOG Mode
rman target "'/ as sysbackup'"
list backup;
recover database;
alter database datafile '/u01/backup/orcl/bar22tbs01.dbf' offline for drop;
alter database open;
drop tablespace bar22tbs including contents and datafiles;
con file_name format a44
col tablespace_name format a10
select file_name, tablespace_name from dba-data_files;
drop user bar22 cascade;


Lesson 3: Configuring for Recoverability
3-1 Configuring the Default Backup Destination and ARCHIVELOG Mode
show paramter db_recoery_file_dest
shutdown immediate;
statup mount;
alter database archivelog;
alter database open;
rman target "'/ as sysbackup'"
backup database;

3-2 Setting the Date and Time Format for RMAN
export NLS_LANG=american_america.al32utf8
export NLS_DATE_FORMAT="yyyy-mm-dd:hh24:mi:ss"
rman target "'/ as sysbackup'"
list backup
spool log to /tmp/test.log
list backup
cat /tmp/test.log

3-3 Configuring RMAN Settings
show controlfile autobackup;
configure controlfile autobackup on;
show retention policy;
configure retention policy to redundancy 1;
show retention policy;
delete obsolete;
report schema;
backup tablespace users;

3-4 Configuring Control Files
hostname --long
show paramter control_files

3-5 Recovery Settings in Cloud Control

3-6 Configuring Redo Log Files

Lesson 03. Configuring for Recoverability

subcommands
braces
作業命令
ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT "/disk2/%U";
obsolete
效率
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
保留策略
歸檔

晚上

實驗

注意細節

rman target "'/ as sysbackup'"
RMAN>SPOOL LOG TO /tmp/test.log
RMAN>list backup
RMAN>cat /tmp/test.log

為什麼不用sysbackup

sysbackup是非方案使用者

表空間
    https://blog.csdn.net/hezuijiudexiaobai/article/details/108740527#2__8
    http://blog.itpub.net/30126024/viewspace-2094756/
    https://www.cnblogs.com/chenzhaoren/p/9969712.html
    https://www.lanqiao.cn/courses/1048/learning/?id=5256