Home » RDBMS Server » Backup & Recovery » Block Change Tracking file is deleted (Oracle 11g,Linux 6)
Block Change Tracking file is deleted [message #682211] Sat, 10 October 2020 01:11 Go to next message
BalajiDBA
Messages: 84
Registered: October 2018
Location: India
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 Go to previous messageGo to next message
John Watson
Messages: 8393
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 Go to previous messageGo to next message
BalajiDBA
Messages: 84
Registered: October 2018
Location: India
Member
Quote:
My guess: it will be re-created on the next startup.
Thank you John for your quick responds Smile
Re: Block Change Tracking file is deleted [message #682217 is a reply to message #682214] Sat, 10 October 2020 03:10 Go to previous messageGo to next message
John Watson
Messages: 8393
Registered: January 2010
Location: Global Village
Senior Member
What happened?
Re: Block Change Tracking file is deleted [message #682338 is a reply to message #682217] Sat, 17 October 2020 02:58 Go to previous message
BalajiDBA
Messages: 84
Registered: October 2018
Location: India
Member
For your guessing
Quote:
My guess: it will be re-created on the next startup.
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:
  


Current Time: Fri Oct 23 23:04:44 CDT 2020