rman学习笔记（1）-转载
时间：2010-12-22 来源：xidian2002
1、使用RMAN时，需要将数据库设置为归档模式
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 开启归档：
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、创建备份用户和表空间： 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> ③链接远程数据库： 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、创建恢复目录： 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 若想把恢复目录创建到其他表空间，则使用： RMAN> create catalog tablespace XXX; 删除恢复目录： RMAN> drop catalog; 5、连接恢复目录： 在登录RMAN后连接： RMAN> connect catalog rman/rman connected to recovery catalog database 也可以直接登录时就连接： 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、注册数据库： 在RMAN中有恢复目录的情况下，连接目标数据后还需要注册数据库 即将目标数据库中的控制文件转到恢复目录中 同一个恢复目录中只能注册一个目标数据库。 RMAN> register database; database registered in recovery catalog
starting full resync of recovery catalog
full resync complete 7、使用log方式登录： 首先创建一个用于记录log信息的文件 然后在登录时使用： C:\Documents and Settings\wangxiaoqi>rman target / log D:\oracle\oradata\dodo\logs\rman_log.txt
RMAN> 当使用了log时，所有的信息将不在屏幕上打印，而直接存入log文件中 所以一般操作还是不要使用log，当执行一个很长的批处理时，可能需要在log文件中记录下操作信息
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 开启归档：
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、创建备份用户和表空间： 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> ③链接远程数据库： 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、创建恢复目录： 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 若想把恢复目录创建到其他表空间，则使用： RMAN> create catalog tablespace XXX; 删除恢复目录： RMAN> drop catalog; 5、连接恢复目录： 在登录RMAN后连接： RMAN> connect catalog rman/rman connected to recovery catalog database 也可以直接登录时就连接： 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、注册数据库： 在RMAN中有恢复目录的情况下，连接目标数据后还需要注册数据库 即将目标数据库中的控制文件转到恢复目录中 同一个恢复目录中只能注册一个目标数据库。 RMAN> register database; database registered in recovery catalog
starting full resync of recovery catalog
full resync complete 7、使用log方式登录： 首先创建一个用于记录log信息的文件 然后在登录时使用： C:\Documents and Settings\wangxiaoqi>rman target / log D:\oracle\oradata\dodo\logs\rman_log.txt
RMAN> 当使用了log时，所有的信息将不在屏幕上打印，而直接存入log文件中 所以一般操作还是不要使用log，当执行一个很长的批处理时，可能需要在log文件中记录下操作信息
相关阅读 更多 +
