OraFAQ Forum: Backup & Recovery » how to judge the backup set is available(using RMAN)?

Home » RDBMS Server » Backup & Recovery » how to judge the backup set is available(using RMAN)?

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

how to judge the backup set is available(using RMAN)? [message #559997]

Mon, 09 July 2012 02:09

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

hi,all,after backuping the database ,how to judge the backup set is available ?

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Report message to a moderator

Re: how to judge the backup set is available(using RMAN)? [message #559999 is a reply to message #559997]

Mon, 09 July 2012 02:14

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

By trying to restore it (have a look at VALIDATE option).

Regards
Michel

Report message to a moderator

Re: how to judge the backup set is available(using RMAN)? [message #560019 is a reply to message #559997]

Mon, 09 July 2012 15:19

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Or...

RMAN> RESTORE DATABASE PREVIEW;

[Updated on: Mon, 09 July 2012 23:27] by Moderator

Report message to a moderator

Re: how to judge the backup set is available(using RMAN)? [message #565359 is a reply to message #560019]

Mon, 03 September 2012 22:33

vincentH4357
Messages: 19
Registered: August 2012
Location: Denver, Colorado

Junior Member

I am new at oracle but as far as i know list backup should give u all the backups. Only which are available-
list backup;
croscheck copy;
crosscheck backup;

Report message to a moderator

Re: how to judge the backup set is available(using RMAN)? [message #565366 is a reply to message #565359]

Tue, 04 September 2012 01:12

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ir gives you the list of what you have not if you are able to restore (think if a file is missing in the backup).

Regards
Michel

Report message to a moderator

Previous Topic:	New to RMAN, looking for tutorials
Next Topic:	RMAN DUPLICATE error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 22:15:36 CST 2024