Databases Reference
In-Depth Information
In this example we have used pprd-scan as the SCAN name and the port 1521 as the listener port.
Substitute with the specific values from your database.
14.
Log on to the database as SYSDBA. Create a user called RMAN with SYSDBA role:
SQL> grant sysdba to rman identified by secretpass1;
Grant succeeded.
15.
Copy the file orapwPROPRD1 in $ORACLE_HOME/dbs to all the other Compute nodes to
make sure that RMAN can connect to all the nodes using the password file:
[oradb@dwhpdb01 dbs]$ scp orapwPROPRD1 oradb@dwhpdb02:`pwd`/orapwPROPRD2
orapwPROPRD1 100% 1536 1.5KB/s 00:00
[oradb@dwhpdb01 dbs]$ scp orapwPROPRD1 oradb@dwhpdb03:`pwd`/orapwPROPRD3
orapwPROPRD1 100% 1536 1.5KB/s 00:00
[oradb@dwhpdb01 dbs]$ scp orapwPROPRD1 oradb@dwhpdb04:`pwd`/orapwPROPRD4
orapwPROPRD1 100% 1536 1.5KB/s 00:00
[oradb@dwhpdb01 dbs]$ scp orapwPROPRD1 oradb@dwhpdb05:`pwd`/orapwPROPRD5
orapwPROPRD1 100% 1536 1.5KB/s 00:00
[oradb@dwhpdb01 dbs]$ scp orapwPROPRD1 oradb@dwhpdb06:`pwd`/orapwPROPRD6
orapwPROPRD1 100% 1536 1.5KB/s 00:00
[oradb@dwhpdb01 dbs]$ scp orapwPROPRD1 oradb@dwhpdb07:`pwd`/orapwPROPRD7
orapwPROPRD1 100% 1536 1.5KB/s 00:00
[oradb@dwhpdb01 dbs]$ scp orapwPROPRD1 oradb@dwhpdb08:`pwd`/orapwPROPRD8
orapwPROPRD1 100% 1536 1.5KB/s 00:00
16.
Start RMAN and connect to the target using the new service name and the RMAN user
created earlier:
RMAN> connect target rman/secretpass1@rman
connected to target database: PROPRD (DBID=1716317401)
17.
Allocate multiple channels as shown below and start the backup:
RMAN> run {
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> allocate channel c4 type disk;
6> allocate channel c5 type disk;
7> allocate channel c6 type disk;
8> allocate channel c7 type disk;
9> allocate channel c8 type disk;
10> backup database;
11> }
