web analytics

How to Configure RMAN

Use the following Steps to Configure RMAN

1.export ORACLE_SID= ‘rmandb’
2.dbca
3.netmgr
4.we have 2 database
5. start lsnrctl orcl em rmandb shut em orcl rmandb lsnrctl
6.startup nomount
7. alter system set sga_target=512M scope=spfile;
8. shutdown immediate;
9.conn to Rmandb
10. alter system set sga_target=512M scope=spfile;
11 emctl stop dbconsole
12. export ORACLE_SID=’rmandb’ emctl stop dbconsole
13.sys/oracle@rmandb as sysdba
14.create tablespace rman_tbs datafile ‘/u01/app/oracle/oradata/rmandb/rman_tbs01.dbf’ size 100M;

15. create user rman1 identified by rman1
15.1 grant connect ,resource,dba to rman1

16 grant recovery_catalog_owner to rman1

17 alter user rman1 default tablespace rman_tbs
18.
conn rman1/rman1@rmandb select * from cat;

19. rman catalog rman1/rman1@rmandb  create catalog tablespace rman_tbs

Open new terminal

20. rman target sys/oracle@orcl catalog rman1/rman1@rmandb

21. register database;

22. EM recovery catalog setting

23. preferred credentials

24  RMAN show all

Detail Steps are as under:

1. orcl (Target database)
2. create rmandb (catalog database)
3. To create catalog database perform the following steps
3.1.export ORACLE_SID= ‘rmandb’
3.2.dbca
3.2.1.netmgr (register your newly created database with lisner
4.start listner and verify that both db instance are registered
(start em Target database and stop em of catalog database)
4.1 lsnrctl start
4.2 Open new terminal and start both databases using command
4.3 startup nomount (alter database open)
4.4 alter system set sga_target=512M scope=spfile;
4.4 export ORACLE_SID= ‘rmandb’
4.4.1 startup nomount (this will startup rmandb database in nomount state)
4.4.2 alter system set sga_target=512M scope=spfile;

5
Now Start both databases to open state

To mount database use command –>alter database mount;
To open database use command –>alter database open
To shutdown database –>alter database immediate;
starup data base –>startup

5.2 on rmandb terminal
5.2.1 startup
5.2.2 sys/oracle@rmandb as sysdba

6. Create database in rmandb
6.1 create tablespace rman_tbs datafile ‘/u01/app/oracle/oradata/rmandb/rman_tbs01.dbf’ size 100M;
6.2 create user rman1 identified by rman1  grant connect ,resource,dba to rman1
6.3 grant recovery_catalog_owner to rman1
6.4 alter user rman1 default tablespace rman_tbs
6.5 connect via user rman1
6.5.1 conn rman1/rman1@rmandb
6.5.2 select * from cat;

in new terminal
7. rman catalog rman1/rman1@rmandb
7.1  create catalog tablespace rman_tbs
Open new terminal

8 rman target sys/oracle@orcl catalog rman1/rman1@rmandb

Recovery Manager: Release 10.2.0.1.0 – Production on Sat Jan 28 23:01:23 2017
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: ORCL (DBID=1300214037)
connected to recovery catalog database

8.2 RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!