Hi Ashok,
Unfortunately we cannot bring the db in the archive log mode without shutting down the db.
Its not possible.
To bring the database in the archive log mode.. we need to shutdown and bring the database in the mount stage, so that control file can update its information stating that the database is in the archive log mode..
The pfile should be in either $ORACLE_BASE/admin/SID/pfile or $ORACLE_HOME/admin/SID/pfile. add the following lines to the end of the file:
############################
############################
log_archive_dest_1='location=/u02/oradata/cuddle/archive'
log_archive_start=TRUE
SQL> startup mount
ORACLE instance started.
Total System Global Area 184549376 bytes
Fixed Size 1300928 bytes
Variable Size 157820480 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
There are several system views that can provide us with information reguarding archives, such as:
V$DATABASE
Identifies whether the database is in ARCHIVELOG or NOARCHIVELOG mode and whether MANUAL (archiving mode) has been specified.
V$ARCHIVED_LOG
Displays historical archived log information from the control file. If you use a recovery catalog, the RC_ARCHIVED_LOG view contains similar information.
V$ARCHIVE_DEST
Describes the current instance, all archive destinations, and the current value, mode, and status of these destinations.
V$ARCHIVE_PROCESSES
Displays information about the state of the various archive processes for an instance.
V$BACKUP_REDOLOG
Contains information about any backups of archived logs. If you use a recovery catalog, the RC_BACKUP_REDOLOG contains similar information.
V$LOG
Displays all redo log groups for the database and indicates which need to be archived.
V$LOG_HISTORY
Contains log history information such as which logs have been archived and the SCN range for each archived log.
Using these tables we can verify that we are infact in ARCHIVELOG mode:
-----Original Message-----
From: Williams Edward D [mailto:oracledba-ezmlmshield-x76809482.[Email address protected]
Sent: Wednesday, August 08, 2007 4:14 PM
To: LazyDBA Discussion
Subject: RE: Archivelog Mode
Absolutely agree.
For a couple of minutes work, you can begin to get a decent back-up strategy in place (including hot-backups (RMAN) and, if you use 10G, flashback)
-----Original Message-----
From: Mans Axell [mailto:oracledba-ezmlmshield-x73538868.[Email address protected]
Sent: 08 August 2007 11:37
To: LazyDBA Discussion
Subject: AW: Archivelog Mode
Hi Ashok
No, there is NO other way to enable archive log mode.
I think you shouldn't have a problem convincing the business that a short downtime (1 minute maximum) is needed unless they don't want to risk loosing the entire database.
Måns
________________________________
Von: ashok [mailto:oracledba-ezmlmshield-x4326059.[Email address protected]
Gesendet: Mi 8/8/2007 12:32
An: LazyDBA Discussion
Betreff: Archivelog Mode
Hi,
I am trying to take the Backup of a DB.
For that we need to move the DB to archivelog mode.
For moving to archivelog mode we need to Shutdown and Startup DB in Mount stage right.
Is there is any other way to change the DB to Archivelog mode without shutdown the DB.
Since the DB which I am tiring to take Backup is up running and we don't have idle time to shutdown.
Regards,
Ashok.
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/> To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/> To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html
--------------------------------------------------------------------------------------------------------------------
'This email and any files transmitted with it are confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email in error please notify the system manager. Please
note that any views or opinions presented in this email are solely those of the author and do not necessarily
represent those of the Council. Finally, the recipient should check this email and any attachments for the presence
of viruses. The Council accepts no liability for any damage caused by any virus transmitted by this email.'
'Mae'r e-bost yma ag unrhyw ffeiliau trosglwyddwyd ynddi yn gyfrinachol ar gyfer defnydd yr unigolyn neu'r sefydliad
cyfeiriwyd ati yn unig. Os ydych wedi derbyn yr e-bost yma mewn camgymeriad rhowch wybod i reolwr eich system.
Nodwch taw unrhyw sylwadau neu farn soniwyd amdanynt yn yr e-bost yma ydi sylwadau a barn yr awdur ac nid yn
angenrheidiol yn cynrychioli rhai'r Cyngor. I orffen, dylid y person sy'n derbyn yr e-bost sicrhau nad oes firws
ynddi nac mewn unrhyw ddogfen sydd ynghlwm i'r e-bost. Nid yw'r Cyngor yn derbyn unrhyw gyfrifoldeb am unrhyw ddifrod
achoswyd gan unrhyw firws trosglwyddwyd gan yr e-bost yma.'
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Oracle LazyDBA home page