Archive

Archive for the ‘rman’ Category

Oracle 11g rman Catalog Setup

June 3, 2011 Leave a comment

Here are the steps to create RMAN catalog in 11g database

1)Create tablespace for RMAN repository
2)create RMAN owner user
3)Grant privileges to the RMAN Repository owner
4)create catalog using RMAN catalog command tool
5)Register the database with RMAN repository

[oracle@rmanl001 bin]$ export ORACLE_SID=rman11g
[oracle@rmanl001 bin]$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jun 2 22:43:20 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace rman_tbs
datafile ‘/u01/app/oracle/oradata/rman11g/rman_tbs01.dbf’ size 100M autoextend off
extent management local
segment space management auto;  2    3    4

Tablespace created.

SQL> create user rman identified by rman001
default tablespace rman_tbs
temporary tablespace temp;  2    3

User created.

SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.

[oracle@rmanl001 bin]$ ./rman catalog rman/rman001

Recovery Manager: Release 11.2.0.2.0 – Production on Thu Jun 2 22:45:47 2011

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

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

Check to see if any objects were created in rman table space;

Now we will register 10g database with the rman repository.

SQL> connect rman@rman11g
Enter password:
Connected.
SQL> select * from rc_database;

no rows selected

[oracle@rmanl001 bin]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0.5/db_1
[oracle@rmanl001 bin]$ export ORACLE_SID=rmandv1
[oracle@rmanl001 bin]$ cd /u01/app/oracle/product/10.2.0.5/db_1

[oracle@rmanl001 bin]$ export TNS_ADMIN=/u01/app/oracle/product/11.2.0.2/db_1/network/admin
[oracle@rmanl001 bin]$ ./tnsping rman11g

TNS Ping Utility for Linux: Version 10.2.0.5.0 – Production on 02-JUN-2011 22:56:23

Copyright (c) 1997,  2010, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rmanl001.ukatru.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rman11g.ukatru.com)))
OK (10 msec)

[oracle@rmanl001 bin]$ ./rman catalog rman/rman001@rman11g target /

Recovery Manager: Release 10.2.0.5.0 – Production on Thu Jun 2 22:56:27 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: RMANDV1 (DBID=701459141)
connected to recovery catalog database

RMAN> register database;

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

SQL> select * from rc_database;

DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS
———- ———- ———- ——– —————– ———
1          2  701459141 RMANDV1                  1 02-JUN-11

RMAN> show all
2> ;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/10.2.0.5/db_1/dbs/snapcf_rmandv1.f’; # default

RMAN> configure channel device type disk format ‘/u01/app/backup/rmandv1_%U’;

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   ‘/u01/app/backup/rmandv1_%U’;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

[oracle@rmanl001 backup]$ pwd
/u01/app/backup

RMAN> backup database;

Starting backup at 03-JUN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/rmandv1/system01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/rmandv1/undotbs01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/rmandv1/rman_catalog.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/rmandv1/sysaux01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/rmandv1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-JUN-11
channel ORA_DISK_1: finished piece 1 at 03-JUN-11
piece handle=/u01/app/backup/rmandv1_03mduskp_1_1 tag=TAG20110603T103608 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 03-JUN-11
channel ORA_DISK_1: finished piece 1 at 03-JUN-11
piece handle=/u01/app/backup/rmandv1_04mdusls_1_1 tag=TAG20110603T103608 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 03-JUN-11

select DB_ID,BACKUP_TYPE,START_TIME,COMPLETION_TIME,STATUS,CONTROLFILE_INCLUDED from rman.rc_backup_set;

DB_ID B START_TIM COMPLETIO S CONTROL
———- – ——— ——— – ——-
701459141 D 03-JUN-11 03-JUN-11 A BACKUP

 

*rmanl001*<oracle:rman11g>:/u01/app/backup=>ls -tlr
total 681072
-rw-r—– 1 oracle oinstall 682434560 Jun  3 10:36 rmandv1_03mduskp_1_1
-rw-r—– 1 oracle oinstall   7143424 Jun  3 10:36 rmandv1_04mdusls_1_1

Advertisements
Categories: rman

Steps to Create a Recovery Catalog in 10g database

June 3, 2011 Leave a comment

In this article I will describe the process to create recovery catalog in 10.2.0.5 database.

[oracle@rmanl001 bin]$ export ORACLE_SID=rmandv1
[oracle@rmanl001 bin]$ ./sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Thu Jun 2 21:19:03 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Step1)Create separate tablespace to store rman catlog tables.

SQL> CREATE  TABLESPACE rmancatlog_tbs DATAFILE ‘/u01/app/oracle/oradata/rmandv1/rman_catalog.dbf’
SIZE 250M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Tablespace created.

Step2)Create rman user

SQL> CREATE USER rman IDENTIFIED BY rman001
DEFAULT TABLESPACE rmancatlog_tbs
QUOTA UNLIMITED ON rmancatlog_tbs
TEMPORARY TABLESPACE TEMP;

User created.

Step3)

SQL> GRANT recovery_catalog_owner TO rman;

Grant succeeded.

[oracle@rmanl001 bin]$ ./rman catalog rman/rman001@rmandv1

Recovery Manager: Release 10.2.0.5.0 – Production on Thu Jun 2 21:26:30 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN>exit

 

 

Categories: rman
%d bloggers like this: