| Oracle Backup Views [message #429391] |
Tue, 03 November 2009 08:25  |
pokhraj_d
Messages: 117
Registered: December 2007
|
Senior Member |
|
|
Hi All,
I am taking the backups of production databases on daily basis. Today the backup script got failed for some unknown reasons, though there is enough space at the /backup filesystem and also the DB instance is up and running.
There is no such log file created by the script through which I can get the error details.
Is there is any views from where I can get the error details for such failed backups?
Please help.
Regards-
Pokhraj Das
[Updated on: Tue, 03 November 2009 08:27] Report message to a moderator |
|
|
|
| Re: Oracle Backup Views [message #429392 is a reply to message #429391] |
Tue, 03 November 2009 08:30  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Quote:I am taking the backups production databases on daily basis. Today the backup script got failed for some unknown reasons, though there is enough space at the /backup filesystem and also the DB instance is up and running.
Any scheduled backup should have a log. Atleast from the cronjob.
The "unknown" reasons should have some pointers in the log.
It also depends on how you did the backup.
Start with alert<sid>.log
[Updated on: Tue, 03 November 2009 08:33] Report message to a moderator |
|
|
|
| Re: Oracle Backup Views [message #429397 is a reply to message #429391] |
Tue, 03 November 2009 08:41 |
pokhraj_d
Messages: 117
Registered: December 2007
|
Senior Member |
|
|
Hi,
I have checked from the alert.log file. No ORA- or RMAN- error found at the alert.log file.
Any views from where I can get the RMAN error?
Regards-
Pokhraj Das
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle Backup Views [message #430952 is a reply to message #429391] |
Fri, 13 November 2009 06:54 |
pokhraj_d
Messages: 117
Registered: December 2007
|
Senior Member |
|
|
Hi,
I am facing with a new problem.
I have 300 production instance currently running. Through RMAN I am taking the full backup at the weekend and incr backup on weekdays.
I am not able to view the details of backups whether it is successfull or failed.
I queried V$RMAN_STATUS that showing the STATUS "COMPLETED" OR "FAILED". But not sure for which instance the backup is "COMPLETED" or "FAILED".
Is there is any way to get the details for the same?
Note: I have connected with sys.I am not using OEM GRID control.
Regards-
Pokhraj Das
|
|
|
|
| Re: Oracle Backup Views [message #431012 is a reply to message #430952] |
Fri, 13 November 2009 11:26 |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
That view is specific to the database you are connecting to. If you want a centralized place to obtain that information for all 300 databases, then you'll have to create a recovery catalog.
Next time create a new thread instead of replying to an older thread.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
