Alter system checkpoints

I have one trivial doubt in this "alter system checkpoints."

Can i give this query while taking hot backup what would be happened?

==expertblr
expertblrAsked:
Who is Participating?
 
actonwangConnect With a Mentor Commented:
it should be "alter system checkpoint".

it should be ok if you issue this. I didn't test it. but I assume that when you issue "alter tablespace xx begin backup" all subsequenct actions will be redirected into log files.


acton
0
 
sathyagiriConnect With a Mentor Commented:
Yes you could give the alter system checkpoint while doing hot back up.

As soon as you start your hot back up, the System Change Number (SCN) is frozen in your file headers and the back up program continues to work as normal. When you force a checkpoint the change still gets written to your data file however does not update the file header. This ways the recovery program identifies that the SCN in the file header is wrong and hence looks for the redo log to apply the delta changes.

Here's a good article on this one
http://www.speakeasy.org/~jwilton/hot-backup.html
0
 
gvsbnarayanaConnect With a Mentor Commented:
Hi,
  It's more useful to issue "Alter System Switch Log File" as it implicitly cause a check point.
Then you will have more consistent data files when compared to issueing "Alter system checkpoint"
HTH
Regards,
Badri.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
KeyurkumarCommented:
Why you want to issue that command ?
~Keyur
0
 
actonwangCommented:
I think that i gave the answer in the first post lound and clear. question resolved already..

////////////////
it should be "alter system checkpoint".

it should be ok if you issue this. I didn't test it. but I assume that when you issue "alter tablespace xx begin backup" all subsequenct actions will be redirected into log files.




0
 
actonwangCommented:
let me know any more question,  expertblr.

acton
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
All Courses

From novice to tech pro — start learning today.