Resolving RMAN-06059, ORA-19625, ORA-17503, ORA-15173 errors I was trying to take a full backup of a database that had not been previously backed up. I issued the commands: rman <<EOF >> $LogFile connect target / connect catalog rman11gr2/Remote_catalog_password@REMOTECAT run { sql 'ALTER SYSTEM SWITCH LOGFILE'; ALLOCATE CHANNEL DEVICE TYPE DISK FORMAT '/dbbackup02/PRODDB/backups/%d_db_%T_%U.bus'; ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/dbbackup02/PRODDB/backups/%d_db_%T_%U.bus'; ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/dbbackup02/PRODDB/backups/%d_db_%T_%U.bus'; backup AS COMPRESSED backupset tag = "$Tag" filesperset 3 database include current controlfile plus archivelog filesperset 3 delete input; release channel release channel disk2; release channel disk3; crosscheck backup; delete noprompt expired backup; delete noprompt obsolete; } report need backup; list backup summary; list backup; resync catalog; exit; EOF The output with an error was: Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connected to target database: PRODDB (DBID=408587896) RMAN> connected to recovery catalog database RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> sql statement: ALTER SYSTEM SWITCH LOGFILE allocated channel: disk1 channel SID=1062 instance=PRODDB2 device type=DISK allocated channel: disk2 channel disk2: SID=1348 instance=PRODDB2 device type=DISK allocated channel: channel disk3: SID=1444 instance=PRODDB2 device type=DISK Starting backup at 06-JAN-17 current log archived
Resolving RMAN-06059, ORA-19625, ORA-17503, ORA-15173 errors I was trying to take a full backup of a database that had not been previously backed up. I issued the commands: rman <<EOF >> $LogFile connect target / connect catalog rman11gr2/Remote_catalog_password@REMOTECAT run { sql 'ALTER SYSTEM SWITCH LOGFILE'; ALLOCATE CHANNEL DEVICE TYPE DISK FORMAT '/dbbackup02/PRODDB/backups/%d_db_%T_%U.bus'; ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/dbbackup02/PRODDB/backups/%d_db_%T_%U.bus'; ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/dbbackup02/PRODDB/backups/%d_db_%T_%U.bus'; backup AS COMPRESSED backupset tag = "$Tag" filesperset 3 database include current controlfile plus archivelog filesperset 3 delete input; release channel release channel disk2; release channel disk3; crosscheck backup; delete noprompt expired backup; delete noprompt obsolete; } report need backup; list backup summary; list backup; resync catalog; exit; EOF The output with an error was: Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connected to target database: PRODDB (DBID=408587896) RMAN> connected to recovery catalog database RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> sql statement: ALTER SYSTEM SWITCH LOGFILE allocated channel: disk1 channel SID=1062 instance=PRODDB2 device type=DISK allocated channel: disk2 channel disk2: SID=1348 instance=PRODDB2 device type=DISK allocated channel: channel disk3: SID=1444 instance=PRODDB2 device type=DISK Starting backup at 06-JAN-17 current log archived
ORA-RMAN-06059-error.docx