| Archivelog Mode [message #53799] |
Fri, 11 October 2002 09:39  |
Michael Pressgrove
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
|
I am trying to configure our hot backup agent for oracle and the manuals say that I need to be operating in archivemode in order to backup objects hot. It tells me that I have to execute a few statements at the SRVMGR prompt. What is that, and how do I get to it. I am an NT Network guy, to me that means NT's server manager where I manage the domain, which im sure is not the case here. Please help. Thanks.
|
|
|
|
| Re: Archivelog Mode [message #53804 is a reply to message #53799] |
Fri, 11 October 2002 13:13  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Do the following:
1. Edit your init.ora file to include:
log_archive_start = true
log_archive_dest = "location=c:oracledirectory"
log_archive_format = arch_%t_%s.arc
2. Shutdown your database:
svrmgrl>connect internal
svrmgrl>shutdown immediate
3. Mount your database:
svrmgrl>startup mount
4. Enable the ARCHIVELOG mode:
svrmgrl>alter database archivelog mode;
5. Open the database:
svrmgrl>alter database open;
6. Check the log mode:
svrmgrl>select log_mode from v$database;
It should say ARCHIVELOG.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: Archivelog Mode [message #53828 is a reply to message #53799] |
Mon, 14 October 2002 06:41 |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
run
> cmd
go to ur oracle home directory ex d:oracle
>cd bin
>dir svrmg*
( name can change depending the oracle's version )
> svrmgr ( or the name U find )
at the prompt:
SVRMGR>connect internal
( prompt U for password ... need to know it ! )
SVRMGR>shutdown
SVRMGR>startup mount
SVRMGR>alter database [[name]] ARCHIVELOG
SVRMGR>shutdown
edit init.ora
set param log_archive_start to TRUE
SVRMGR>startup
SVRMGR>ARCHIVE LOG LIST
read information automatic ARCHIVING must be "enabled"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
