Home » RDBMS Server » Backup & Recovery » crosscheck command
crosscheck command [message #577670] Tue, 19 February 2013 09:13 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 22520
Registered: January 2009
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
Re: crosscheck command [message #577672 is a reply to message #577671] Tue, 19 February 2013 09:18 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the result of your commands as well.

Regards
Michel
Re: crosscheck command [message #577736 is a reply to message #577675] Wed, 20 February 2013 00:40 Go to previous messageGo to next message
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..............
Re: crosscheck command [message #577748 is a reply to message #577736] Wed, 20 February 2013 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Some of them are backup of archived logs, control file or other things that are not database files?

Regards
Michel
Re: crosscheck command [message #577749 is a reply to message #577748] Wed, 20 February 2013 02:45 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks sir,
you mean
RMAN> crosscheck backup of database;

command shows only datafiles backup?

thanks....
Re: crosscheck command [message #577751 is a reply to message #577749] Wed, 20 February 2013 03:30 Go to previous messageGo to next message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Backup sets or image copies of files in the database, yes.

Regards
Michel
Re: crosscheck command [message #577784 is a reply to message #577751] Wed, 20 February 2013 08:32 Go to previous message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
ok sir thanks alot.


thanks...
Previous Topic: Issue in SPFILE Autobackup
Next Topic: RMAN issus with catalog database
Goto Forum:
  


Current Time: Tue Jul 29 06:19:06 CDT 2014

Total time taken to generate the page: 0.18223 seconds