on 06-08-2009 1:14 PM
Dear all,
I am getting checkpoint not completed in db16.Can any please help me.I have trouble shoted.
the correction is : inscrease the on line redolog file. how i can increase the redo file .please give the steps.
Regards:
Ramu
Hi,
You can not resize the existing redo log files.
For this, you have to create another redo log files group, make it current and than drop the current redo log files group.
Full DB backup is always recommanded before using these steps.
1. alter database
add logfile group x
('c:\log\log0101.log','d:\log\log0102.log') size <Your new size in MB>M;
2. Switch to make it current
alter database switch logfile;
3. Drop the exisiting redo log files
alter database drop logfile group y;
Follow this link for more clarity on commands.
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/onlineredo.htm#i1006398
With Regards,
Saurabh
Edited by: Saurabh.Arora on Jun 8, 2009 8:35 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
https://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement
Hi,
Assuming Oracle already have group 1 and group 2, this command will create a third group (Unix directory):
ALTER DATABASE ADD LOGFILE GROUP 3
(u2018$HOME/ORADATA/directory/log3a.rdou2019,
u2018$HOME/ORADATA/directory/log3b.rdou2019)
SIZE 1 M;
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.