| Bishal |
Posted: May 12, 2008 07:16:24 AM |
Total Post: 160
Joined: Apr, 2008
|
Hi,
Wanted to know how to we get database from archive log mode to non archive mode both during runtime and ehen the instance is shut down...
Also, I wanted to know is can export and import utilities work for database in non archival log mode....
Your answers are most welcome..
Thanx in advance.... |
|
|
 dbavinod |
| Posted: May 12, 2008 07:45:41 AM |  |
|
Total Post: 90
Joined: Sep, 2006
|
Shutdown edit pfile / spfile (spfile when instance is up of course) to say log_archive_start = false.
startup mount
alter database noarchivelog;
alter database open;
to use exp DB shd be in open mode thats it
|
|
|
|
|
| Mohammed Taj |
| Posted: May 13, 2008 01:20:46 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Or if it is your database running on 10g or 11g
then
shutdown
startup mount
alter database noARRCHIVELOG;
alter database open;
EXPORT/IMPORT is utility it is doesn't matter with ARCHIVELOG mode.
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: May 13, 2008 02:58:58 AM | |
|
Total Post: 79
Joined: Apr, 2008
|
1.sql> shutdown immediate
2.sql>startup mount
3.sql> alter database noarchivelog
4.alter database open
to learn more please read the topic
http://sharear.blogspot.com/2008/04/enabling-archivelog-mode.html
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
