| deleting old archived log? [message #634565] |
Wed, 11 March 2015 06:34  |
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  |
 |
Michel Cadot
Messages: 68421
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 |
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
