Home » RDBMS Server » Backup & Recovery » Help me with Crosscheck command in RMAN!
Help me with Crosscheck command in RMAN! [message #270741] Thu, 27 September 2007 22:57 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all!

I found some archive log files marked to be obsolete. And I did not deleted them. RMAN recommended to use Crosscheck command.

Please help me with this command.

Thank you!

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 4 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          1169   21-SEP-07          E:\ARCHIVE\ARC00884_0628936514.00
1
Archive Log          1170   21-SEP-07          E:\ARCHIVE\ARC00883_0628936514.00
1
Archive Log          1171   21-SEP-07          E:\ARCHIVE\ARC00885_0628936514.00
1
Archive Log          1172   22-SEP-07          E:\ARCHIVE\ARC00886_0628936514.00
1
Archive Log          1187   22-SEP-07          E:\ARCHIVE\ARC00887_0628936514.00
1
Archive Log          1215   22-SEP-07          E:\ARCHIVE\ARC00888_0628936514.00
1

RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 4 days
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          1169   21-SEP-07          E:\ARCHIVE\ARC00884_0628936514.00
1
Archive Log          1170   21-SEP-07          E:\ARCHIVE\ARC00883_0628936514.00
1
Archive Log          1171   21-SEP-07          E:\ARCHIVE\ARC00885_0628936514.00
1
Archive Log          1172   22-SEP-07          E:\ARCHIVE\ARC00886_0628936514.00
1
Archive Log          1187   22-SEP-07          E:\ARCHIVE\ARC00887_0628936514.00
1
Archive Log          1215   22-SEP-07          E:\ARCHIVE\ARC00888_0628936514.00
1

Do you really want to delete the above objects (enter YES or NO)? y

RMAN-06207: WARNING: 6 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status

RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Archivelog      E:\ARCHIVE\ARC00884_0628936514.001
RMAN-06214: Archivelog      E:\ARCHIVE\ARC00883_0628936514.001
RMAN-06214: Archivelog      E:\ARCHIVE\ARC00885_0628936514.001
RMAN-06214: Archivelog      E:\ARCHIVE\ARC00886_0628936514.001
RMAN-06214: Archivelog      E:\ARCHIVE\ARC00887_0628936514.001
RMAN-06214: Archivelog      E:\ARCHIVE\ARC00888_0628936514.001


RMAN>

[Updated on: Thu, 27 September 2007 22:57]

Report message to a moderator

Re: Help me with Crosscheck command in RMAN! [message #270751 is a reply to message #270741] Thu, 27 September 2007 23:28 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
The command is
RMAN> CROSSCHECK archivelog all;
Re: Help me with Crosscheck command in RMAN! [message #270752 is a reply to message #270751] Thu, 27 September 2007 23:31 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Yeah!
I've done.
Thank you, Frank!
Re: Help me with Crosscheck command in RMAN! [message #380262 is a reply to message #270741] Fri, 09 January 2009 16:26 Go to previous message
pkmr26
Messages: 1
Registered: January 2009
Location: USA
Junior Member

Great.. It worked for me.. Thanks allot trantuananh24hg
Previous Topic: Problem in upgrading RMAN catalog
Next Topic: A question about hot backup process
Goto Forum:
  


Current Time: Wed Dec 07 14:33:27 CST 2016

Total time taken to generate the page: 0.25065 seconds