OCM(六)

以此记录每一次OCM练习的过程，发现其中缺少的部分并补完。

现在开始备份恢复章节：

1.开启归档

mkdir -p /u01/app/oracle/bak/arch1
mkdir -p /u01/app/oracle/bak/arch2

alter system set log_archive_dest_1='location=/u01/app/oracle/bak/arch1';
alter system set log_archive_dest_2='location=/u01/app/oracle/bak/arch2';

shutdown immediate
startup mount
alter database archivelog;
alter database open;

2.建立PROD4并创建表空间

export DISPLAY=192.168.56.1:0.0
dbca
--注册监听
lsnrctl start
. oraenv
prod4
sqlplus / as sysdba
select * from v$instance;
alter system set db_domain='oracle.com' scope=spfile;
startup force
alter system register;
--创建表空间
create tablespace RCVCAT datafile '/u01/app/oracle/oradata/prod4/rcvcat01.dbf' size 200m autoextend on maxsize 2G extent management local autoallocate segment space management auto;

3.创建用户并赋予权限

create user rc_admin identified by oracle default tablespace RCVCAT;
alter user rc_admin quota unlimited on RCVCAT;
grant connect,recovery_catalog_owner to rc_admin;

4.创建recovery catalog

rman catalog rc_admin/oracle@prod4
create catalog;

5.将PROD1注册到catalog

--管理机上
vi $ORACLE_HOME/network/admin/tnsnames.ora
PROD1=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=odd.oracle.com)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVICE_NAME=PROD1.oracle.com)
      (server=dedicated)
    )
  )

rman target sys/oracle@prod1 catalog rc_admin/oracle@prod4
upgrade catalog;
upgrade catalog;
exit;
rman target sys/oracle@prod1 catalog rc_admin/oracle@prod4
register database;

6.修改PROD1的RMAN参数

mkdir -p /home/oracle/files/bak
rman target sys/oracle@prod1
configure channel device type disk format '/home/oracle/files/bak/%U';
configure device type disk parallelism 4;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/files/bak/%F'
configure retention policy to redundancy 5;
configure retention policy to recovery window of 7days;
configure backup optimization on;

7.备份system表空间

rman target sys/oracle@prod1
backup tablespace system section size 200m;