| Kris |
Posted: May 19, 2004 11:54:47 AM |
Total Post: 30
Joined: Jan, 2003
|
Hello,
can you tell me how to check log mode in the database. what query? it is urgent.
thanks |
|
|
 Vigyan |
| Posted: May 19, 2004 10:07:23 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Use archive log list at sql prompt.
SQL> archive log list
|
|
|
|
|
| Kris |
| Posted: Feb 17, 2005 10:15:01 AM | |
|
Total Post: 30
Joined: Jan, 2003
|
Another question...
How can I change the archive log mode when database is open?
Thanks,
Kris
|
|
|
|
|
| P |
| Posted: Mar 14, 2005 10:58:54 AM | |
|
Total Post: 7
Joined: Nov, 2003
|
u can check database mode by :
select log_mode from v$database;
u cannot change log mode while u r database is in open.
u need to mount u r database,then change archive<=>noarchive
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
