Re: Saving Backup Errros inside the db
- From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
- To: bnsarma@xxxxxxxxx
- Date: Tue, 27 Dec 2005 22:13:09 -0400
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 <bnsarma@xxxxxxxxx> 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
>
Other related posts:
