1. You can provide log file name in the RMAN command line. 2. Generate a unique log file name for every RMAN backup operation.(say Date) 3. Once the RMAN backup is over, execute another shell script that accepts this RMAN logfile name as parameter and uploads this text file into the database.( Use DBMS_LOB) 4. If you have a catalog database, you can create a new schema that maintains these log files. 5. Create one more shell script that accepts the unique log file name can download the file name from the database to a predefined directory for reviewing
Hope this helps
Best Regards
Sriram Kumar
On 12/27/05, BN <bnsarma@(protected)> wrote: > > Greetings, > > I would like to save the following RMAN error messages inside a table > along with the timestamp > > > > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: =========================================================== > RMAN-03007: retryable error occurred during execution of command: backup > RMAN-07004: unhandled exception during command execution on channel d1 > RMAN-10035: exception raised in RPC: ORA-19502 (See ORA-19502.ora-code.com): write error on file > "/u03/oradata/vrwedb/control03.dbf", blockno 1751 (blocksize=8192) > ORA-27072 (See ORA-27072.ora-code.com): skgfdisp: I/O error > HP-UX Error: 28: No space left on device > Additional information: 1751 > RMAN-10031: ORA-19624 (See ORA-19624.ora-code.com) occurred during call to > DBMS_BACKUP_RESTORE.BACKUPPIECECREATE > > RMAN> > > > > Can somebody suggest me how I can do this. I want to save the new lines, > as they appear in the error message. > Am I looking at a CLOB or do I have other options. > > > -- > Regards & Thanks > BN >
<div>Hi,</div> <div> </div> <div>I guess you can use the following logic.</div> <div> </div> <div>1. You can provide log file name in the RMAN command line.</div> <div>2. Generate a unique log file name for every RMAN backup operation.(say Date)</div> <div>3. Once the RMAN backup is over, execute another shell script that accepts this RMAN logfile name as parameter and uploads this text file into the database.( Use DBMS_LOB)</div> <div>4. If you have a catalog database, you can create a new schema that maintains these log files.</div> <div>5. Create one more shell script that accepts the unique log file name can download the file name from the database to a predefined directory for reviewing</div> <div> </div> <div>Hope this helps</div> <div> </div> <div>Best Regards</div> <div> </div> <div>Sriram Kumar</div> <div><br><br> </div> <div><span class="gmail_quote">On 12/27/05, <b class="gmail_sendername">BN</b> <<a href="mailto:bnsarma@(protected)">bnsarma@(protected)</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <div>Greetings,</div> <div> </div> <div>I would like to save the following RMAN error messages inside a table along with the timestamp</div> <div> </div> <div> </div> <p>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br >RMAN-00571: ===========================================================<br>RMAN -03007: retryable error occurred during execution of command: backup <br>RMAN-07004: unhandled exception during command execution on channel d1<br >RMAN-10035: exception raised in RPC: ORA-19502 (See ORA-19502.ora-code.com): write error on file "/u03 /oradata/vrwedb/control03.dbf", blockno 1751 (blocksize=8192) <br>ORA-27072 (See ORA-27072.ora-code.com): skgfdisp: I/O error<br>HP-UX Error: 28: No space left on device <br>Additional information: 1751<br>RMAN-10031: ORA-19624 (See ORA-19624.ora-code.com) occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE</p> <p>RMAN><br></p> <p> </p> <div> </div> <div>Can somebody suggest me how I can do this. I want to save the new lines, as they appear in the error message.</div> <div>Am I looking at a CLOB or do I have other options.</div> <div><br clear="all"><br>-- <br>Regards & Thanks<br>BN </div></blockquote>< /div><br>
