OraFAQ Forum: Backup & Recovery » block change tracking file

Home » RDBMS Server » Backup & Recovery » block change tracking file - when it is used?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

block change tracking file - when it is used? [message #526496]

Tue, 11 October 2011 05:16

piotrtal
Messages: 168
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

piotrtal
Messages: 168
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 1011 times)

Report message to a moderator

Re: block change tracking file - when it is used? [message #526500 is a reply to message #526496]

Tue, 11 October 2011 05:28

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: block change tracking file - when it is used? [message #526504 is a reply to message #526500]

Tue, 11 October 2011 05:35

piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

which one from a, b, c, d ?

for me there is only one correct - c.

Report message to a moderator

Re: block change tracking file - when it is used? [message #526507 is a reply to message #526504]

Tue, 11 October 2011 05:40

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: block change tracking file - when it is used? [message #526511 is a reply to message #526507]

Tue, 11 October 2011 05:57

piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

but what about my atachement? only one is (for me) correct.

Report message to a moderator

Re: block change tracking file - when it is used? [message #526516 is a reply to message #526511]

Tue, 11 October 2011 06:30

Michel Cadot
Messages: 68641
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

Report message to a moderator

Previous Topic:	Backup & Recovery
Next Topic:	Flashback Version Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 03:16:05 CDT 2024