Pessoal, percebi um comportamento que não tinha percebido ainda no RMAN.
Talvez seja algo bem noob, mas se alguém puder compartilhar uma solução :)
Os scripts estão no final do e-mail.
Bom, estou movendo alguns datafiles para um novo disco.
No script eu estou alocando 10 canais, no entanto, ao executar esse bloco,
eu percebo que o rman está usando apenas no ch1 para todos os backup as
copy.
Eu imagino que seja pq tudo está indo para um mesmo disco... mas, eu já vi
backups sendo feitos para um único mount point e ainda assim rodando em
diversos canais.
RUN
{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
allocate channel ch5 type disk;
allocate channel ch6 type disk;
allocate channel ch7 type disk;
allocate channel ch8 type disk;
allocate channel ch9 type disk;
allocate channel ch10 type disk;
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_BTC_GDWHS_PUBLIC_I_S_03.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_BTC_GDWHS_PUBLIC_I_S_03.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHD_D_01.dbf" FORMAT
"/mnt/GWP01/datafiles/GWP01_CHD_D_01.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles1/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_07.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_CHG_BILL_GLOBAL_D_S_07.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_08.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_CHG_BILL_GLOBAL_D_S_08.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles1/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_09.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_CHG_BILL_GLOBAL_D_S_09.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_10.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_CHG_BILL_GLOBAL_D_S_10.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_01.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_CHG_BILL_GLOBAL_D_S_01.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles18/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_02.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_CHG_BILL_GLOBAL_D_S_02.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_03.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_CHG_BILL_GLOBAL_D_S_03.dbf";
BACKUP AS COPY DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_04.dbf"
FORMAT "/mnt/GWP01/datafiles/GWP01_CHG_BILL_GLOBAL_D_S_04.dbf";
}
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_BTC_GDWHS_PUBLIC_I_S_03.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_BTC_GDWHS_PUBLIC_I_S_03.dbf"
TO COPY;
RECOVER DATAFILE 1389;
SQL "ALTER DATABASE DATAFILE 1389 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_BTC_GDWHS_PUBLIC_I_S_03.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHD_D_01.dbf'' OFFLINE";
SWITCH DATAFILE "/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHD_D_01.dbf"
TO COPY;
RECOVER DATAFILE 35;
SQL "ALTER DATABASE DATAFILE 35 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHD_D_01.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles1/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_07.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles1/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_07.dbf"
TO COPY;
RECOVER DATAFILE 68;
SQL "ALTER DATABASE DATAFILE 68 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles1/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_07.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_08.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_08.dbf"
TO COPY;
RECOVER DATAFILE 70;
SQL "ALTER DATABASE DATAFILE 70 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_08.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles1/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_09.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles1/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_09.dbf"
TO COPY;
RECOVER DATAFILE 71;
SQL "ALTER DATABASE DATAFILE 71 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles1/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_09.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_10.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_10.dbf"
TO COPY;
RECOVER DATAFILE 72;
SQL "ALTER DATABASE DATAFILE 72 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_10.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_01.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_01.dbf"
TO COPY;
RECOVER DATAFILE 107;
SQL "ALTER DATABASE DATAFILE 107 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_01.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles18/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_02.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles18/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_02.dbf"
TO COPY;
RECOVER DATAFILE 108;
SQL "ALTER DATABASE DATAFILE 108 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles18/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_02.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_03.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_03.dbf"
TO COPY;
RECOVER DATAFILE 109;
SQL "ALTER DATABASE DATAFILE 109 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_03.dbf";
SQL "ALTER DATABASE DATAFILE
''/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_04.dbf''
OFFLINE";
SWITCH DATAFILE
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_04.dbf"
TO COPY;
RECOVER DATAFILE 110;
SQL "ALTER DATABASE DATAFILE 110 ONLINE";
DELETE NOPROMPT DATAFILECOPY
"/oracle/GWP01/datafiles3/oradata/GWP01/GWP01_CHG_BILL_GLOBAL_D_S_04.dbf";
Evandro Giachetto
Oracle DBA
evandrogiache...@gmail.com
