rman configuration in oracle step by step
|
|
RMAN Configuration (DEMO)
Target Database Side :
1) check the database in Archive log mode or not.
SQL> archive log list (or) select log_mode from v$database;
2) changing database to archive log mode
SQL>startup mount;
SQL>alter database archivelog;
2)Configure the Listener.ora file in $ORACLE_HOME/network/admin
3) Create the password file in $ORACLE_HOME/dbs
dbs]$ orapwd file=orapw$ORACLE_SID password=orcl force=y
4) create the Rman backup directory structure.
~]$ mkdir -p /u01/oradata/orcl/rmanbkp
Catalog Database Side
1) configure the Tnsnames.ora for target DB in ORACLE_HOME/network/admin location
2) create a tablespace to store rman catalog database objects.
SQL> create tablespace rmants datafile '/u01/oradata/catdb/rmants.dbf' size 300m;
3) create a user
SQL> create user rmanusr identified by rmanusr;
4) grant one extra privilege to rman user.
SQL> grant connect,resource , recovery_catalog_owner to rmanusr;
5) assign rman tablespace to rman user as a default.
SQL> alter user rmanusr default tablespace rmants;
6) connect to RMAN prompt.
~]$rman catalog rmanusr/rmanusr
RMAN>
7) Create the catalog in RMAN prompt;
RMAN> create catalog
(NOTE: Go and check in rman user all objects are created or not)
8)After finishing the catalog database creation connect with target database and register it.
~]$ rman catalog rmanusr/rmanusr target=sys/orcl@to_lsnralias;
RMAN> register database;
(NOTE : jst go and check target database registered or not in rman user with rc_database command)
9) Change the backup policies in show.all file.
RMAN> show.all
10) After changing the policies just give the command like..
RMAN> backup database;
(Not : go and check in target database Rman backup location files are backed up or not)
HTML Comment Box is loading comments...