[20140627]rman下catalog的使用.txt

前几天有人问rman的catalog的使用问题,主要是后面的/.自己做一些记录:

--我建立一个目录testtes

# ls -l | grep testtes
drwxr-x---  2 root      root      4096 2014-06-26 02:14:28 testtes
drwxr-xr-x  3 oracle11g oinstall 20480 2014-06-26 02:04:51 testtest

RMAN> catalog start with '/data/testtes/';

searching for all files that match the pattern /data/testtes/
no files found to be unknown to the database

--因为没有权限,没有文件发现.

# chmod 755 testtes
# cp /etc/passwd testtes
# chmod 640 testtes/passwd
# ls -l testtes
total 4
-rw-r-----  1 root root 2874 2014-06-26 02:19:55 passwd

RMAN> catalog start with '/data/testtes/';

searching for all files that match the pattern /data/testtes/
no files found to be unknown to the database

--这个时候是文件passwd没有读权限.

# chmod 644 testtes/passwd
RMAN> catalog start with '/data/testtes/';

searching for all files that match the pattern /data/testtes/

List of Files Unknown to the Database
=====================================
File Name: /data/testtes/passwd

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
no files cataloged

List of Files Which Where Not Cataloged
=======================================
File Name: /data/testtes/passwd
  RMAN-07517: Reason: The file header is corrupted

--我感觉奇怪的是passwd文件根本不是rman能管理的文件,难道在catalog前不检查吗?仅仅在开始catalog时才检查.

--尝试不使用后面的斜线/

RMAN> catalog start with '/data/testtes';

searching for all files that match the pattern /data/testtes

List of Files Unknown to the Database
=====================================
File Name: /data/testtes/passwd
File Name: /data/testtest/test/sysaux01.dbf
File Name: /data/testtest/test/system01.dbf
File Name: /data/testtest/test/redo03.log
File Name: /data/testtest/test/users01.dbf
File Name: /data/testtest/test/redostb01.log
File Name: /data/testtest/test/redostb04.log
File Name: /data/testtest/test/tools01.dbf
File Name: /data/testtest/test/redo02.log
File Name: /data/testtest/test/testmssm01.dbf
File Name: /data/testtest/test/redostb03.log
File Name: /data/testtest/test/redo01.log
File Name: /data/testtest/test/test01.dbf
File Name: /data/testtest/test/rman01.dbf
File Name: /data/testtest/test/temp01.dbf
File Name: /data/testtest/test/redostb02.log
File Name: /data/testtest/test/example01.dbf
File Name: /data/testtest/test/undotbs02.dbf
File Name: /data/testtest/test/control01.ctl
File Name: /data/testtest/test/control02.ctl
File Name: /data/testtest/test/undotbs01.dbf
File Name: /data/testtest/test.tgz
File Name: /data/testtest/test01.dbf
File Name: /data/testtest/test01.dbf_2
File Name: /data/testtest/users01.dbf

Do you really want to catalog the above files (enter YES or NO)? no

--可以发现执行catalog start with '/data/testtes';实际上找匹配"/data/testtes*"的文件.
--自己做一个记录,加强理解这个问题.