Databases Reference
In-Depth Information
6.
Test to make sure this TNS entry is valid:
prolin101.oradb: # tnsping RMAN
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on
31-AUG-2012 20:37:12
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS = (PROTOCOL =TCP)(HOST = prodb01-scan)
(PORT=1521)) (CONNECT_DATA = (SERVER=DEDICATED) (SERVICE_NAME=RMAN)))
OK (200 msec)
7.
Create an RMAN user in the database:
SQL> grant dba to rman identified by secretsauze;
Grant succeeded.
8.
Connect a session to this TNS entry to make sure the service name, etc. are valid:
prolin101.oradb # sqlplus rman/secretsauze@RMAN
SQL*Plus: Release 11.2.0.3.0 Production on Fri Aug 31 20:40:41 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
9.
Now that this setup is complete, create channels in the following manner to use this
service name:
RMAN> connect rman/secretsauze@rman
2> run {
3> allocate channel c1 type disk format '+BACKUP/%u.rmb';
4> allocate channel c2 type disk format '+BACKUP/%u.rmb';
5> allocate channel c3 type disk format '+BACKUP/%u.rmb';
6> allocate channel c4 type disk format '+BACKUP/%u.rmb';
7> allocate channel c5 type disk format '+BACKUP/%u.rmb';
8> allocate channel c6 type disk format '+BACKUP/%u.rmb';
9> ... backup commands come here ...
10> }
