Database Backup and Recovery (MOSC)

MOSC Banner

The 'cleanckp.sql' script

edited Jun 16, 2017 10:20AM in Database Backup and Recovery (MOSC) 5 commentsAnswered

Hi,

    I have a customer who still has an 8i production database (he can't move off this version in the short term because the 3rd party supplier of his system is no longer trading - however the good news is that he is in the process of redeveloping it, with a target completion time of Q4 this year). Anyhow, his problem is that repopulating his test database by restoring an RMAN backup of his production database takes a very long time. He has identified the problem (cf. SR 3-14981827471, MOS note 209780.1 and bug 247611.1) - it appears that he needs to run a script called 'cleanckp.sql'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center