Re: Saving Backup Errros inside the db

Hi,

I guess you can use the following logic.

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 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: write error on file
> "/u03/oradata/vrwedb/control03.dbf", blockno 1751 (blocksize=8192)
> ORA-27072: skgfdisp: I/O error
> HP-UX Error: 28: No space left on device
> Additional information: 1751
> RMAN-10031: ORA-19624 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
>
Received on Wed Dec 28 2005 - 03:13:09 CST