OraFAQ Forum: Backup & Recovery » crosscheck command

Home » RDBMS Server » Backup & Recovery » crosscheck command

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

crosscheck command [message #577670]

Tue, 19 February 2013 09:13

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

hello experts,

crosscheck backup of database vs crosscheck backup command

RMAN> crosscheck backup;

it shows all backup pieces.

RMAN> crosscheck backup of database;

it shows 2 backup piece of each backupset.

please suggest me-

when should be use: crosscheck backup of database;

and when should be use: crosscheck backup;

thanks...........

[Updated on: Tue, 19 February 2013 09:16]

Report message to a moderator

Re: crosscheck command [message #577671 is a reply to message #577670]

Tue, 19 February 2013 09:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

neither command is required

Report message to a moderator

Re: crosscheck command [message #577672 is a reply to message #577671]

Tue, 19 February 2013 09:18

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

ok sir thanks,

crosscheck backup of database vs crosscheck backup command

RMAN> crosscheck backup;

it shows all backup pieces.

RMAN> crosscheck backup of database;

it shows 2 backup piece of each backupset.

please suggest me-

when should be use: crosscheck backup of database;

and when should be use: crosscheck backup;

thanks...........

[Updated on: Tue, 19 February 2013 09:19]

Report message to a moderator

Re: crosscheck command [message #577675 is a reply to message #577672]

Tue, 19 February 2013 10:31

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

Senior Member
Account Moderator

Post the result of your commands as well.

Regards
Michel

Report message to a moderator

Re: crosscheck command [message #577736 is a reply to message #577675]

Wed, 20 February 2013 00:40

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

ok sir,

result is here,

RMAN> crosscheck backup of database;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\FLASH_RECOVERY_AREA\TESTDB\2013_02_19\O1_MF_NNNDF_TAG20130219T195754_8L72ZDGP_.BKP RECID=13 STAMP=807826760
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\FLASH_RECOVERY_AREA\TESTDB\2013_02_19\O1_MF_NNNDF_TAG20130219T195754_8L72ZCGC_.BKP RECID=12 STAMP=807826760
Crosschecked 2 objects


RMAN> crosscheck backup;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\FLASH_RECOVERY_AREA\TESTDB\2013_02_19\O1_MF_NNNDF_TAG20130219T195754_8L72ZDGP_.BKP RECID=13 STAMP=807826760
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\FLASH_RECOVERY_AREA\TESTDB\2013_02_19\O1_MF_NNNDF_TAG20130219T195754_8L72ZCGC_.BKP RECID=12 STAMP=807826760
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\FLASH_RECOVERY_AREA\TESTDB\2013_02_19\O1_MF_NNSNF_TAG20130219T195754_8L730T6Z_.BKP RECID=14 STAMP=807826760
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\FLASH_RECOVERY_AREA\TESTDB\2013_02_19\O1_MF_NCNNF_TAG20130219T195754_8L730THF_.BKP RECID=11 STAMP=807826759
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\FLASH_RECOVERY_AREA\TESTDB\2013_02_19\O1_MF_ANNNN_TAG20130219T195847_8L73112W_.BKP RECID=10 STAMP=807826759
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\FLASH_RECOVERY_AREA\TESTDB\2013_02_19\O1_MF_ANNNN_TAG20130219T195847_8L7310NH_.BKP RECID=9 STAMP=807826759
Crosschecked 6 objects

thanks..............

Report message to a moderator