Home » Server Options » Data Guard » deleting old archived log? (oracle 11.2.0.1 RAC on solaris 10 , standby database)
deleting old archived log? [message #634565] Wed, 11 March 2015 06:34 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi,
i am having trouble in deleting the old archive log which are applied in standby database. i did following to delete the expired logs but get error

RMAN> crosscheck archivelog all;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 03/11/2015 16:06:06
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 03/11/2015 16:06:06
RMAN-20079: full resync from primary database is not done

RMAN> list expired copy of archivelog all;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 03/11/2015 16:06:53
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 03/11/2015 16:06:53
RMAN-20079: full resync from primary database is not done

RMAN> delete expired archivelog all;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 03/11/2015 16:07:12
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 03/11/2015 16:07:12
RMAN-20079: full resync from primary database is not done

RMAN> exit



Kindly help


Regards

Re: deleting old archived log? [message #634575 is a reply to message #634565] Wed, 11 March 2015 09:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

RMAN-20079: full resync from primary database is not done
 *Cause:  Resync from standby detected that a full resync from primary
          database is required. One of the following events on primary
          database may have caused this error:
             1) one or more tablespaces or datafiles were added
             2) one or more tablespaces or datafiles were dropped
             3) one or more datafiles status changed
 *Action: Perform full resync after connecting to primary database.
With RMAN connect to the primary database and execute "resync;".

[Updated on: Wed, 11 March 2015 13:29]

Report message to a moderator

Re: deleting old archived log? [message #634594 is a reply to message #634575] Wed, 11 March 2015 13:06 Go to previous message
janakors
Messages: 232
Registered: September 2009
Senior Member
thank you for your time.let me do it and i will return with results

Regards.
Previous Topic: catnofus.sql and catdbfus.sql
Next Topic: Logical dataguard - No-logging in force logging
Goto Forum:
  


Current Time: Thu Mar 28 10:52:10 CDT 2024