Home » RDBMS Server » Backup & Recovery » block change tracking file - when it is used?
block change tracking file - when it is used? [message #526496] Tue, 11 October 2011 05:16 Go to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

hi

i have question.
i did such commands


1. RMAN -> backup incremental level 0 database;
2. SQLPLUS -> alter database enable block change tracking 
using file '/home/oracle/block_change_tracking.tr';
3. RMAN -> backup incremental level 1 cumulative database;
4. RMAN -> backup incremental level 1 cumulative database;
5. RMAN -> backup incremental level 1 cumulative database;



and for such order i noticed that block change tracking file wasn't used for any cumulative backup. for each cumulative backup was done full scan over database.

it was used after i did incremental level 0 backup, and again incremental 1 cumulative.

so question and concern is.

if i want this feature to be usefull i should enable it before my incremental level 0, or i should do incremental level 0 immediately after i enable it?
am i right?

[Updated on: Tue, 11 October 2011 05:27] by Moderator

Report message to a moderator

Re: block change tracking file - when it is used? [message #526497 is a reply to message #526496] Tue, 11 October 2011 05:19 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

what will be 2 answers for this question - because i am messed - see atachement.

  • Attachment: pyt1.JPG
    (Size: 56.05KB, Downloaded 97 times)
Re: block change tracking file - when it is used? [message #526500 is a reply to message #526496] Tue, 11 October 2011 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
if i want this feature to be usefull i should enable it before my incremental level 0, or i should do incremental level 0 immediately after i enable it?


Both are correct.

Regards
Michel
Re: block change tracking file - when it is used? [message #526504 is a reply to message #526500] Tue, 11 October 2011 05:35 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

which one from a, b, c, d ?

for me there is only one correct - c.
Re: block change tracking file - when it is used? [message #526507 is a reply to message #526504] Tue, 11 October 2011 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no a, b, c, d in your posts.
I answered to your sentence.

Regards
Michel
Re: block change tracking file - when it is used? [message #526511 is a reply to message #526507] Tue, 11 October 2011 05:57 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

but what about my atachement? only one is (for me) correct.
Re: block change tracking file - when it is used? [message #526516 is a reply to message #526511] Tue, 11 October 2011 06:30 Go to previous message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't read attachment, post it in text in your post.

Regards
Michel
Previous Topic: Backup & Recovery
Next Topic: Flashback Version Query
Goto Forum:
  


Current Time: Wed Jul 30 23:10:25 CDT 2014

Total time taken to generate the page: 0.09158 seconds