Home » RDBMS Server » Backup & Recovery » Oracle Backup Views (Oracle 10g R2, Linux)
Oracle Backup Views [message #429391] Tue, 03 November 2009 08:25 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
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 #429400 is a reply to message #429397] Tue, 03 November 2009 09:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
So you are using RMAN.
RMAN writes the to standard out unless you specify a logfile.
No run-time errors are logged into dictionary.
You can get the details of job,longops etc. But not errors.
Re: Oracle Backup Views [message #429501 is a reply to message #429391] Wed, 04 November 2009 04:46 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior 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]

Report message to a moderator

Re: Oracle Backup Views [message #429505 is a reply to message #429501] Wed, 04 November 2009 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 #429526 is a reply to message #429501] Wed, 04 November 2009 06:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Those are in catalog.
Are you connecting to catalog as owner?
Re: Oracle Backup Views [message #429586 is a reply to message #429391] Wed, 04 November 2009 12:21 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check V$RMAN_BACKUP_JOB_DETAILS and/or V$RMAN_OUTPUT.
Re: Oracle Backup Views [message #430952 is a reply to message #429391] Fri, 13 November 2009 06:54 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: replace database
Next Topic: Recover database while archivelogs are purged
Goto Forum:
  


Current Time: Thu Mar 28 10:18:38 CDT 2024