Legato 7.4.4
Networker module for oracle 4.5
Please note that it's not the case that backups older than a certain date are not showing up. It's got alternating stretches of what was backed up on node 1 vs. node 2. If I run a crosscheck on node 1, it will only see the backups that were done on node 1. If I run a crosscheck on node 2, it will only see the backups that were done on node 2. This is the case even with NSR_CLIENT specified.
4/11-4/15 node 2
4/16-5/19 node 1
5/20-6/2 node 2
6/3-6/18 node 1
6/19-6/24 node 2
Here is the daily script:
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA\$OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
release channel oem_disk_backup;
allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(NSR_DATA_VOLUME_POOL=oraclebackup1,NSR_DATA_VOLUME_POOL1=oraclebackup2,NSR_CLIENT=gendev)';
backup archivelog all not backed up;
backup backupset all not backed up since time 'SYSDATE-1';
}
allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(NSR_DATA_VOLUME_POOL=oraclebackup1,NSR_DATA_VOLUME_POOL1=oraclebackup2,NSR_CLIENT=gendev)';
delete noprompt obsolete recovery window of 75 days device type 'SBT_TAPE';
Here is the weekly script:
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA\$OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
release channel oem_disk_backup;
allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(NSR_DATA_VOLUME_POOL=oraclebackup1,NSR_DATA_VOLUME_POOL1=oraclebackup2,NSR_CLIENT=gendev)';
backup recovery area;
}
allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(NSR_DATA_VOLUME_POOL=oraclebackup1,NSR_DATA_VOLUME_POOL1=oraclebackup2,NSR_CLIENT=gendev)';
delete noprompt obsolete recovery window of 75 days device type 'SBT_TAPE';
The hostnames/IPs of the cluster are:
node 1: racdev1 (192.168.15.176, physical) vracdev1 (192.168.15.206, virtual)
node 2: racdev2 (192.168.15.181, physical) vracdev2 (192.168.15.210, virtual)
On the cluster there are two databases: gendev and sandbox. (So far we've been restricting the conversation to gendev, but be aware that there is another database on the cluster.) Each database has one instance on racdev1 and one instance on racdev2. Neither the databases nor the individual instances have their own dedicated IPs. This is the standard setup for RAC databases running on Oralce clusterware.
Backups of each database are kicked off as an rman script run from Oracle Grid Control, which can run on either instance of the database. They are the standard Oracle-recommended scripts generated by grid control. The Networker parameters are passed using the parms syntax on the allocate channel commands in the script.
What should the value of NSR_CLIENT be for the backups for each of the two databases? If it's anything other than racdev1, vracdev1, racdev2, or vracdev2, I'm told it needs to have an IP, so what do we need to add to DNS?
Networker module for oracle 4.5
Please note that it's not the case that backups older than a certain date are not showing up. It's got alternating stretches of what was backed up on node 1 vs. node 2. If I run a crosscheck on node 1, it will only see the backups that were done on node 1. If I run a crosscheck on node 2, it will only see the backups that were done on node 2. This is the case even with NSR_CLIENT specified.
4/11-4/15 node 2
4/16-5/19 node 1
5/20-6/2 node 2
6/3-6/18 node 1
6/19-6/24 node 2
Here is the daily script:
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA\$OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
release channel oem_disk_backup;
allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(NSR_DATA_VOLUME_POOL=oraclebackup1,NSR_DATA_VOLUME_POOL1=oraclebackup2,NSR_CLIENT=gendev)';
backup archivelog all not backed up;
backup backupset all not backed up since time 'SYSDATE-1';
}
allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(NSR_DATA_VOLUME_POOL=oraclebackup1,NSR_DATA_VOLUME_POOL1=oraclebackup2,NSR_CLIENT=gendev)';
delete noprompt obsolete recovery window of 75 days device type 'SBT_TAPE';
Here is the weekly script:
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA\$OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
release channel oem_disk_backup;
allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(NSR_DATA_VOLUME_POOL=oraclebackup1,NSR_DATA_VOLUME_POOL1=oraclebackup2,NSR_CLIENT=gendev)';
backup recovery area;
}
allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(NSR_DATA_VOLUME_POOL=oraclebackup1,NSR_DATA_VOLUME_POOL1=oraclebackup2,NSR_CLIENT=gendev)';
delete noprompt obsolete recovery window of 75 days device type 'SBT_TAPE';
The hostnames/IPs of the cluster are:
node 1: racdev1 (192.168.15.176, physical) vracdev1 (192.168.15.206, virtual)
node 2: racdev2 (192.168.15.181, physical) vracdev2 (192.168.15.210, virtual)
On the cluster there are two databases: gendev and sandbox. (So far we've been restricting the conversation to gendev, but be aware that there is another database on the cluster.) Each database has one instance on racdev1 and one instance on racdev2. Neither the databases nor the individual instances have their own dedicated IPs. This is the standard setup for RAC databases running on Oralce clusterware.
Backups of each database are kicked off as an rman script run from Oracle Grid Control, which can run on either instance of the database. They are the standard Oracle-recommended scripts generated by grid control. The Networker parameters are passed using the parms syntax on the allocate channel commands in the script.
What should the value of NSR_CLIENT be for the backups for each of the two databases? If it's anything other than racdev1, vracdev1, racdev2, or vracdev2, I'm told it needs to have an IP, so what do we need to add to DNS?