Home » RDBMS Server » Server Administration » ENABLING ARCHIVE LOG (Oracle 10g)
ENABLING ARCHIVE LOG [message #308096] Fri, 21 March 2008 02:37 Go to next message
MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA
Member
Hi Experts
I want to enable archive log to my databse so that the destination file is my DR site. Later, I want to restart my DR site databse from archive file. Can you help me please?

Melaku K.
Re: ENABLING ARCHIVE LOG [message #308105 is a reply to message #308096] Fri, 21 March 2008 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LOG_ARCHIVE_DEST_n

Regards
Michel
Re: ENABLING ARCHIVE LOG [message #308257 is a reply to message #308096] Sat, 22 March 2008 22:37 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What is DR?
Re: ENABLING ARCHIVE LOG [message #308259 is a reply to message #308257] Sat, 22 March 2008 22:48 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Arju wrote on Sat, 22 March 2008 23:37
What is DR?


Disaster Recovery.
Re: ENABLING ARCHIVE LOG [message #308463 is a reply to message #308096] Mon, 24 March 2008 07:39 Go to previous messageGo to next message
ahmed.nsa
Messages: 12
Registered: March 2008
Location: bangalore
Junior Member

create pf sile from spfile first.
edit your pfile and update following information

set LOG_ARCHIVE_DEST_n IN initialization parameter file
example: log_archive_dest_1="SERVICE=standbydb MANDATORY REOPEN=300"
enable archiving in INIT FILE OR DYNAMICALLY using ALTER command.

CONNECT as sysdba and startup in mount state.
change the mode ex: alter database archivelog;
then OPEN the database.
THEN again shut down and update your spfile
by using create spfile from pfile.
finally startup the database.
Re: ENABLING ARCHIVE LOG [message #308469 is a reply to message #308463] Mon, 24 March 2008 07:48 Go to previous messageGo to next message
ahmed.nsa
Messages: 12
Registered: March 2008
Location: bangalore
Junior Member
enable archiving by setting log_archive_start=true in pfile.

or using alter command ie alter system archive log start;
Re: ENABLING ARCHIVE LOG [message #308562 is a reply to message #308469] Mon, 24 March 2008 21:44 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
ahmed.nsa wrote on Mon, 24 March 2008 08:48
enable archiving by setting log_archive_start=true in pfile.

or using alter command ie alter system archive log start;

These commands have been deprecated in 10g.
Previous Topic: Taking datafile offline instead of the tablespace
Next Topic: How to move all data from +dg1 to +dg2?
Goto Forum:
  


Current Time: Mon Nov 04 12:17:24 CST 2024