Home » RDBMS Server » Backup & Recovery » Recovery catalog Views (Oracle 10g Linux)
Recovery catalog Views [message #431272] Mon, 16 November 2009 06:59 Go 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

Report message to a moderator

Re: Recovery catalog Views [message #431354 is a reply to message #431272] Tue, 17 November 2009 00:26 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hi pokhraj,

If you are using CATALOG then check in schema's owner of CATALOG.

SQL> desc rc_rman_status
Name Null? Type
----------------------------------------- -------- ------------------
DB_KEY NOT NULL NUMBER
DBINC_KEY NOT NULL NUMBER
DB_NAME NOT NULL VARCHAR2(Cool
RECID NOT NULL NUMBER
STAMP NOT NULL NUMBER
RSR_KEY NOT NULL NUMBER
PARENT_KEY NUMBER
SESSION_KEY NUMBER
ROW_TYPE VARCHAR2(33)
ROW_LEVEL NUMBER
OPERATION VARCHAR2(33)
STATUS VARCHAR2(33)
COMMAND_ID VARCHAR2(33)
MBYTES_PROCESSED NOT NULL NUMBER
START_TIME NOT NULL DATE
END_TIME DATE
JOB_KEY NUMBER
INPUT_BYTES NUMBER
OUTPUT_BYTES NUMBER
OPTIMIZED VARCHAR2(3)
OBJECT_TYPE VARCHAR2(80)
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
OUTPUT_DEVICE_TYPE VARCHAR2(17)

Regards,
Vish

Report message to a moderator

Re: Recovery catalog Views [message #431412 is a reply to message #431272] Tue, 17 November 2009 04:54 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The answer does NOT change from your previous post several days ago!!!

DO NOT multi-post !!

Report message to a moderator

Previous Topic: Hot Backups
Next Topic: Oracle 9.2.0.4.0 on Windows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 07:19:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.