OraFAQ Forum: Backup & Recovery » Block Change Tracking file is deleted

Home » RDBMS Server » Backup & Recovery » Block Change Tracking file is deleted (Oracle 11g,Linux 6)

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

Block Change Tracking file is deleted [message #682211]

Sat, 10 October 2020 01:11

BalajiDBA
Messages: 100
Registered: October 2018
Location: India

Senior Member

Hi,

This is an interview question.
Could someone please explain what would happen if Block Change Tracking file is deleted.

Regards,
Balaji

[Updated on: Sat, 10 October 2020 01:22]

Report message to a moderator

Re: Block Change Tracking file is deleted [message #682212 is a reply to message #682211]

Sat, 10 October 2020 01:42

John Watson
Messages: 8547
Registered: January 2010
Location: Global Village

Senior Member

Balaji, there is a simple problem solving technique: testing. Why do you not simply delete it, and see what happens? Then let us all know.

My guess: it will be re-created on the next startup.

[Updated on: Sat, 10 October 2020 01:48]

Report message to a moderator

Re: Block Change Tracking file is deleted [message #682214 is a reply to message #682212]

Sat, 10 October 2020 02:39

BalajiDBA
Messages: 100
Registered: October 2018
Location: India

Senior Member

Quote:

My guess: it will be re-created on the next startup.

Thank you John for your quick responds Smile

Report message to a moderator

Re: Block Change Tracking file is deleted [message #682217 is a reply to message #682214]

Sat, 10 October 2020 03:10

John Watson
Messages: 8547
Registered: January 2010
Location: Global Village

Senior Member

What happened?

Report message to a moderator

Re: Block Change Tracking file is deleted [message #682338 is a reply to message #682217]

Sat, 17 October 2020 02:58

BalajiDBA
Messages: 100
Registered: October 2018
Location: India

Senior Member

For your guessing
Quote:

My guess: it will be re-created on the next startup.

Report message to a moderator

Previous Topic:	ORA-12170: TNS:Connect timeout occurred
Next Topic:	View v$backup_datafile is not updated after a backup. Rman is skipping datafiles.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 16 04:28:03 CDT 2021