-
You make it to noarchivelog...
Radhakrishnan.M
-
As long as you don't want/need archiving you can open in noarchivelog and not worry about the problem. However if you do want it in archivelog mode, set log_archive_start = true instead of false. You have to bounc the database after any changes in the init.ora for them to take effect.
-
Thanks everyone.
I have opened my database in 'NOARCHIVELOG' mode.
I need to work on it more to see if it crashes or not.
If it still crashes, I shall again return back to the same forum.
Thanks again for all your help.
Shiva.
-
hi!
It is not a good idea to run your database in no archivelog mode, if it's a production database. You may loose data if the database crashes.
Keep in archive log mode. Give enough space to archivelog destination. After each backup delete the archives. Make the process in cron script.
abhijit
-
If you don't want to runi in archivelog mode, mount the database and disable archivelog mode by using the following comand.
svrmgrl> startup mount;
svrmgrl>alter database noarchivelog;
svrmgrl>alter database open;
Thanks,
Bhaskar
-
If you restart your databse in noarchivelog mode then remember that your backup strategies change entirely.
I guess that there is not enough space in the archive destination.
Why dont you move some of your older archive logs elsewhere and free up disk space.
Also if you are backing up and change to noarchivelog mode then you have to take a full database backup(closed) again.
Nizar.
-
This is not a production database and there is no backup involved. So I guess running the database in noarchive mode is not going to be too dangerous.
Thanks again for all your responses.
I have learnt a lot from all you guys.
Shiva.
-
If you think, you need this database and you have to recover it when you loose, you need to have some type of backup exp/cold backup/hotbackup with archive logs.
Justify yourself and have some plan. Sometimes we do neglect and endup having tough time when the situation arise.
Just a reminder.
-
The error message is not saying anything about space problem. It says files to be archived manually which has already been set in control files.
So comment the above parameter, mount the database and then disable the archivelog as below.
svrmgrl>startup mount;
svrmgrl>alter database noarchivelog;
svrmgrl>alter database open;
Thanks,
Bhaskar
[Edited by Bhaskara on 01-17-2001 at 11:48 AM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|