Home » RDBMS Server » Backup & Recovery » how to judge the backup set is available(using RMAN)?
how to judge the backup set is available(using RMAN)? [message #559997] Mon, 09 July 2012 02:09 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
By trying to restore it (have a look at VALIDATE option).

Regards
Michel
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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;
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: New to RMAN, looking for tutorials
Next Topic: RMAN DUPLICATE error
Goto Forum:
  


Current Time: Thu Mar 28 17:09:41 CDT 2024