RMAN學(xué)習(xí)筆記01——登錄
?
?
??? 從今天開(kāi)始學(xué)習(xí)一下RMAN的使用。RMAN在Oracle中的重要性就不用多說(shuō)了，反正要備份數(shù)據(jù)庫(kù)不用RMAN是不可想象的。所以明確一下 RMAN的細(xì)節(jié)用法是非常必要的，從今天開(kāi)始花幾天時(shí)間從各個(gè)方面學(xué)習(xí)一下詳細(xì)用法。本文很大程度上參考了junsansi大牛的《一步一步學(xué)RMAN》，另外參考了一些Oracle基礎(chǔ)讀物。下面開(kāi)始，首先是使用RMAN前的一些準(zhǔn)備工作。
?
?
1、使用RMAN時(shí)，需要將數(shù)據(jù)庫(kù)設(shè)置為歸檔模式
?
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> archive log list
Database log mode????????????? Archive Mode
Automatic archival???????????? Enabled
Archive destination??????????? D:\oracle\oradata\dodo\archive
Oldest online log sequence???? 26
Next log sequence to archive?? 28
Current log sequence?????????? 28
?
開(kāi)啟歸檔方法：
a. shutdown immediate
b. startup mount
c. alter database archivelog
d. alter database opne
?
禁止歸檔方法：
a.
shutdown immediate
b. startup mount
c. alter database noarchivelog
d. alter database open
?
?
2、創(chuàng)建備份用戶和表空間：
?
SQL> create tablespace recovery_tbs datafile 'D:\oracle\oradata\dodo\recovery_tbs.ora' size 15M autoextend on next 10M;
?
Tablespace created
?
SQL> create user rman identified by rman default tablespace recovery_tbs;
?
User created
?
SQL> grant connect,resource,recovery_catalog_owner to rman;
?
Grant succeeded
?
SQL> alter user rman quota unlimited on recovery_tbs;
?
User altered
?
?
3、登錄rman：
?
①登錄rman后使用connect target命令登錄：
?
C:\Documents and Settings\wangxiaoqi>set oracle_sid=dodo
?
C:\Documents and Settings\wangxiaoqi>rman
?
Recovery Manager: Release 9.2.0.1.0 - Production
?
Copyright (c) 1995, 2002, Oracle Corporation.? All rights reserved.
?
RMAN> connect target /
?
connected to target database: DODO (DBID=472976704)
?
②直接用rman命令登錄：
?
C:\Documents and Settings\wangxiaoqi>rman target /
?
Recovery Manager: Release 9.2.0.1.0 - Production
?
Copyright (c) 1995, 2002, Oracle Corporation.? All rights reserved.
?
connected to target database: DODO (DBID=472976704)
?
RMAN>
?
③鏈接遠(yuǎn)程數(shù)據(jù)庫(kù)：
?
C:\Documents and Settings\wangxiaoqi>rman target sys/sys as
sysdba @dodo2
?
Recovery Manager: Release 9.2.0.1.0 - Production
?
Copyright (c) 1995, 2002, Oracle Corporation.? All rights reserved.
?
connected to target database: DODO2 (DBID=472976705)
?
RMAN>
?
?
4、創(chuàng)建恢復(fù)目錄：
?
C:\Documents and Settings\wangxiaoqi>rman
?
Recovery Manager: Release 9.2.0.1.0 - Production
?
Copyright (c) 1995, 2002, Oracle Corporation.? All rights reserved.
?
RMAN> connect catalog rman/rman
?
connected to recovery catalog database
recovery catalog is not installed
?
RMAN> create catalog;
?
recovery catalog created
?
若想把恢復(fù)目錄創(chuàng)建到其他表空間，則使用：
RMAN> create catalog tablespace XXX;
?
刪除恢復(fù)目錄：
RMAN> drop catalog;
?
?
5、連接恢復(fù)目錄：
?
在登錄RMAN后連接：
RMAN> connect catalog rman/rman
?
connected to recovery catalog database
?
也可以直接登錄時(shí)就連接：
C:\Documents and Settings\wangxiaoqi>rman target / catalog rman/rman
?
Recovery Manager: Release 9.2.0.1.0 - Production
?
Copyright (c) 1995, 2002, Oracle Corporation.? All rights reserved.
?
connected to target database: DODO (DBID=472976704)
connected to recovery catalog database
?
RMAN>
?
不連接catalog：
C:\Documents and Settings\wangxiaoqi>rman target / nocatalog
?
Recovery Manager: Release 9.2.0.1.0 - Production
?
Copyright (c) 1995, 2002, Oracle Corporation.? All rights reserved.
?
connected to target database: DODO (DBID=472976704)
using target database controlfile instead of recovery catalog
?
?
6、注冊(cè)數(shù)據(jù)庫(kù)：
?
在RMAN中有恢復(fù)目錄的情況下，連接目標(biāo)數(shù)據(jù)后還需要注冊(cè)數(shù)據(jù)庫(kù)
即將目標(biāo)數(shù)據(jù)庫(kù)中的控制文件轉(zhuǎn)到恢復(fù)目錄中
同一個(gè)恢復(fù)目錄中只能注冊(cè)一個(gè)目標(biāo)數(shù)據(jù)庫(kù)。
?
RMAN> register database;
?
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
?
?
7、使用log方式登錄：
?
首先創(chuàng)建一個(gè)用于記錄log信息的文件
然后在登錄時(shí)使用：
?
C:\Documents and Settings\wangxiaoqi>rman target / log D:\oracle\oradata\dodo\logs\rman_log.txt
RMAN>
?
當(dāng)使用了log時(shí)，所有的信息將不在屏幕上打印，而直接存入log文件中
所以一般操作還是不要使用log，當(dāng)執(zhí)行一個(gè)很長(zhǎng)的批處理時(shí)，可能需要在log文件中記錄下操作信息
?
?
?