Using the ALTER DATABASE Command
Log files or log file groups can be
added or modified with the ALTER
DATABASE command, as shown on Day 6. I
prefer the command-line utilities because they can be scripted, and as such are
a permanent record that can be used over and over again. An example of how to
use the ALTER
DATABASE command to add a log file is shown
here:
ALTER DATABASE database
ADD LOGFILE ( `log3a', `log3b' ) SIZE 10M;
To add a new log file to an already
existing group, you can use this command:
ALTER DATABASE database
ADD LOGFILE MEMBER `log3c' TO GROUP 3;
If you don't know the group name,
you can use the same command and specify the other members of the log file
group, as in
ALTER DATABASE database
ADD LOGFILE MEMBER `log3c' TO GROUP ( `log3a', `log3b');
As I have said before, by using a
SQL script and the ALTER
DATABASE command, you can preserve a
permanent record of the change and then use the file as a template for other,
similar operations.
Thank you
Asraful
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন