OraFAQ Forum: Backup & Recovery » Check full successful backup

Home » RDBMS Server » Backup & Recovery » Check full successful backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Check full successful backup [message #179755]

Wed, 28 June 2006 10:06

toshidas2000
Messages: 120
Registered: November 2005

Senior Member

All
How do I check when was the last full hot database backup successful in RMAN for both 8i and 10g target databases??

Thanks
Toshi

Report message to a moderator

Re: Check full successful backup [message #179769 is a reply to message #179755]

Wed, 28 June 2006 11:49

Vamshee
Messages: 32
Registered: February 2005

Member

To connect to Recovery Manager from the OS.

Target DB: ACCT
RMAN DB: PAY

Eg:
-------
$ rman target internal/internal@acct rcvcat rman/rman@pay

RMAN > crosscheck backupset;
Gives a list of backupsets with their status (EXPIRED/AVAILABLE)

RMAN > list backup;
Gives a list of the backups done with their details

Regards
Vamshee

Report message to a moderator

Previous Topic:	Cloning Database - Document
Next Topic:	Hardware failure make Oracle 8 database down

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 22 23:09:36 CDT 2026