EMREP库

1.创建表空间

create tablespace rc_data datafile '/u01/app/oracle/oradata/EMREP/rc_data01.dbf'  size 100m reuse;

select file_id,file_name,tablespace_name,bytes/1024/1024 m from dba_data_files;

   FILE_ID FILE_NAME                                                                TABLESPACE                    M

---------- -------------------------------------------------- ---------- ----------

 4 /u01/app/oracle/oradata/EMREP/users01.dbf                    USERS                                 5

 3 /u01/app/oracle/oradata/EMREP/undotbs01.dbf                    UNDOTBS1                 75

 2 /u01/app/oracle/oradata/EMREP/sysaux01.dbf                    SYSAUX                470

 1 /u01/app/oracle/oradata/EMREP/system01.dbf                    SYSTEM                690

 5 /u01/app/oracle/oradata/EMREP/rc_data01.dbf                    RC_DATA                100

2.创建用户，赋予权限        

create user rc_admin identified by rc_admin;

alter user rc_admin default tablespace rc_data;

grant connect,resource to rc_admin;

SQL> select grantee,privilege from dba_sys_privs where grantee='RESOURCE' order by privilege;

GRANTEE                        PRIVILEGE

-------------------------- ----------------------------------------

RESOURCE                       CREATE CLUSTER

RESOURCE                       CREATE INDEXTYPE

RESOURCE                       CREATE OPERATOR

RESOURCE                       CREATE PROCEDURE

RESOURCE                       CREATE SEQUENCE

RESOURCE                       CREATE TABLE

RESOURCE                       CREATE TRIGGER

RESOURCE                       CREATE TYPE

8 rows selected.

SQL> select grantee,privilege from dba_sys_privs where grantee='CONNECT' order by privilege;

GRANTEE                        PRIVILEGE

-------------------------- ----------------------------------------

CONNECT                        CREATE SESSION

grant RECOVERY_CATALOG_OWNER to rc_admin;这个角色管理catalog库

select * from dba_roles where role like '%RECOVERY%';

ROLE                               PASSWORD AUTHENTICAT

------------------------------ -------- -----------

RECOVERY_CATALOG_OWNER               NO        NONE

3.创建密码文件

alter user sys identified by oracle;

orapwd file=orapwEMREP password=oracle entries=3 force=y      dbs目录下！

4.启动监听测试是否可以连通

rman target sys/oracle@prod as sysdba

rman target sys/oracle@emrep as sysdba

rman catalog rc_admin/rc_admin@emrep

5.创建CATALOG

rman catalog rc_admin/rc_admin@emrep

Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 31 22:34:23 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog;

这个过程创建了142长表,可以登录rc_admin查看

select count(*) from tab;

  COUNT(*)

----------

   142

6.注册CATALOG

rman target sys/oracle@prod catalog rc_admin/rc_admin@emrep

Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 31 22:39:45 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=239015079)

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

select * from rc_database;

DB_KEY  DBINC_KEY            DBID NAME          RESETLOGS_CHANGE# RESETLOGS

---------- ---------- ---------- -------- ----------------- ---------

 2            4  239015079 PROD                     359851 27-MAR-14

DBID是prod库的

select file#,name from rc_datafile;

 FILE# NAME

---------- -------------------------------------------------------

 1 /u01/app/oracle/oradata/PROD/disk3/system01.dbf

 2 /u01/app/oracle/oradata/PROD/disk4/sysaux01.dbf

 3 /u01/app/oracle/oradata/PROD/disk5/undotbs01.dbf

 4 /u01/app/oracle/oradata/PROD/disk3/users01.dbf

 5 /u01/app/oracle/oradata/PROD/disk4/lxtb01.dbf

 6 /u01/app/oracle/oradata/PROD/disk5/tool01.dbf

 7 /u01/app/oracle/oradata/PROD/disk3/system02.dbf        

 可以查询prod库的数据文件，这些是从控制文件中读出的

desc rc_backup_set

desc rc_stored_script

----------建立脚本

rman target sys/oracle@prod catalog rc_admin/rc_admin@emrep

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jun 1 00:48:45 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=239015079)

connected to recovery catalog database

RMAN>  create script recover_database{

2> allocate channel c1 type disk;

3> allocate channel c2 type disk;

4> restore database;

5> recover database;

6> }

create script recover_database{

allocate channel c1 type disk;

allocate channel c2 type disk;

restore database;

recover database;

}

starting full resync of recovery catalog

full resync complete

created script recover_database

----------查看脚本内容        

RMAN> print script recover_database;

printing stored script: recover_database

{

allocate channel c1 type disk;

allocate channel c2 type disk;

restore database;

recover database;

}

----------运行脚本

RMAN> run{execute script recover_database;}

----------修改脚本

RMAN> replace script recover_database{    

2> restore database;

3> recover database;

4> }

replaced script recover_database

RMAN> print script recover_database;

printing stored script: recover_database

{

restore database;

recover database;

}

----------删除脚本        

RMAN> delete script recover_database;