| Oracle Backup Views [message #429391] |
Tue, 03 November 2009 08:25  |
pokhraj_d
Messages: 35
Registered: December 2007 |
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]
|
|
|
| Re: Oracle Backup Views [message #429392 is a reply to message #429391] |
Tue, 03 November 2009 08:30  |
 |
Mahesh Rajendran
Messages: 9793
Registered: March 2002
Location: oracleDocoVille |
Senior Member |
|
|
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]
|
|
|
| Re: Oracle Backup Views [message #429397 is a reply to message #429391] |
Tue, 03 November 2009 08:41 |
pokhraj_d
Messages: 35
Registered: December 2007 |
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 #429501 is a reply to message #429391] |
Wed, 04 November 2009 04:46 |
pokhraj_d
Messages: 35
Registered: December 2007 |
Member |
|
|
Hi,
Thanks for your suggestion. Also, I am not able to check the RC_* tables from sql prompt.
Please suggest from where I can check those tables, as I am connecting as "/ as sysdba" privilege.
Regards-
Pokhraj
[Updated on: Wed, 04 November 2009 04:46]
|
|
|
| Re: Oracle Backup Views [message #429505 is a reply to message #429501] |
Wed, 04 November 2009 04:55 |
Michel Cadot
Messages: 29417
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
What does mean "you are unable"?
Your eyes are closed? Your PC is OFF? There is no network? Database is down? Power is OFF? Building is burning?
Regards
Michel
|
|
|
|
|
| Re: Oracle Backup Views [message #430952 is a reply to message #429391] |
Fri, 13 November 2009 06:54 |
pokhraj_d
Messages: 35
Registered: December 2007 |
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: 2714
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.
|
|
|
] 
Members
Search
Help
Register
Login
Home
