Home » RDBMS Server » Server Administration » Enable Archive log mode
Enable Archive log mode [message #247414] Mon, 25 June 2007 15:44 Go to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Hey Experts

I am going to turn my production database ( 10.2.0.1) from no archive log mode TO archivelog mode.

I know its simple , but as it is production database, I am little
conscious and does not want that any problem comes while i am implementing that.

Here are some of the steps i will follow.

1. I will shutdown my database and take cold backup of controlfile,pfile,spfile,datafiles.
2. I will have to change parameteres log_archive_format,log_archived_dest,db_recovery_file_dest,db_recovery_file_dest_size.
in pfile
3. I will not use log_archive_start parameter in pfile as it is been deprecated in 10g.
SHUTDOWN IMMEDIATE,Take cold backup.
4. Start up mount pfile='/.....'
5. alter database archivelog mode
6.create spfile from pfile
7. shutdown immediate.
8. startup
9. archive log list


This is pretty much I would do.

If somebody have any suggestions.Plz do respond me.

Also if anybody finds any Document that can support the same , plz do send me the link.

Thanks

Harry

Re: Enable Archive log mode [message #247415 is a reply to message #247414] Mon, 25 June 2007 15:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Seems correct to me.

Regards
Michel
Re: Enable Archive log mode [message #247416 is a reply to message #247415] Mon, 25 June 2007 16:04 Go to previous messageGo to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Actually later on i want to implement RMAN BACKUPS. Is there any any parameter I have to set for Starting RMAN Backups in the pfile and have to shut down database for the same.
OR all the parameters are Dynamic.

Regards

Re: Enable Archive log mode [message #247417 is a reply to message #247416] Mon, 25 June 2007 16:25 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
harry07 wrote on Mon, 25 June 2007 15:04
Actually later on i want to implement RMAN BACKUPS. Is there any any parameter I have to set for Starting RMAN Backups in the pfile and have to shut down database for the same.
OR all the parameters are Dynamic.

Regards





Theres no need of setting any parameter in pfile.

You can customize RMAN in the RMAN prompt.

LIke.

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/10.2.0/dbs/snapcf_MY_DB.f'; # default

RMAN>

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP off;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN>

[Updated on: Mon, 25 June 2007 16:32]

Report message to a moderator

Re: Enable Archive log mode [message #247421 is a reply to message #247417] Mon, 25 June 2007 18:30 Go to previous messageGo to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
THANKS DREAMZZ

Regards

harry..
Re: Enable Archive log mode [message #247438 is a reply to message #247414] Mon, 25 June 2007 21:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

> I will have to change parameteres log_archive_format,log_archived_dest,db_recovery_file_dest,db_recovery_file_dest_size.
in pfile


Is this step is needed? If not your dependency task will be lessen.
Re: Enable Archive log mode [message #247643 is a reply to message #247438] Tue, 26 June 2007 11:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
log_archive_format,log_archived_dest,db_recovery_file_dest,
db_recovery_file_dest_size.


All are Dynamic parameters except LOG_ARCHIVE_FORMAT.

You can Change them in currently running instance without restart except the one.
Re: Enable Archive log mode [message #247759 is a reply to message #247414] Wed, 27 June 2007 02:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Keep in mind.


if you configure "log_archive_dest_1" parameter then all archive log file generated in "log_archive_dest" location.

and if you configure "db_recovery_file_dest" parameter then all archive log generated in FLASH RECOVERY AREA.

or you cann't set "log_archive_dest" parameter with "db_recovery_file_dest" or "log_archive_dest_n" parameters.


1. I will shutdown my database and take cold backup of controlfile,pfile,spfile,datafiles.

2. I will have to change parameteres log_archive_format,log_archived_dest,db_recovery_file_dest,db_recovery_file_dest_size.
in pfile

3. I will not use log_archive_start parameter in pfile as it is been deprecated in 10g.
SHUTDOWN IMMEDIATE,Take cold backup.

4. Start up mount pfile='/.....'

5. alter database archivelog mode

6.create spfile from pfile

7. shutdown immediate.

8. startup

9. archive log list


above procedure is also correct but you can also switch archivelog mode

1. set all require parameters with scope=spfile.
note: scope=spfile specify only for non modifiable parameters.

2. shutdown immediate;

3. startup mount

4. alter database archivelog;

5. alter database open;

6. archive log list

7. create pfile from spfile ---> for new init<sid>.ora file.




Regards
Taj
Re: Enable Archive log mode [message #247988 is a reply to message #247414] Wed, 27 June 2007 13:50 Go to previous messageGo to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Thanks Taz

As i want to use db_recovery_file_dest parameter.So

1. should i use log_archive_dest or log_archive_dest_1((as i only have one archive log destination))

2. Or i dont have to use either of these.

Regards

Harry

[Updated on: Wed, 27 June 2007 13:54]

Report message to a moderator

Re: Enable Archive log mode [message #248667 is a reply to message #247988] Sat, 30 June 2007 02:46 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
log_archive_dest this parameter you cann't use with db_recovery_file_dest or log_archive_dest_n...

if you want to multiple archive log destination you should set "log_archive_dest_n" parameter for mutliple location.

Re: Enable Archive log mode [message #248788 is a reply to message #248667] Mon, 02 July 2007 00:29 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Mohammad, Can I use log_archive_dest_n parameter along with db_recovery_file_dest parameters. What is the use of db_recovery_file_dest when I have log_archive_dest_n parameter?
Re: Enable Archive log mode [message #248894 is a reply to message #248788] Mon, 02 July 2007 10:39 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Can I use log_archive_dest_n parameter along with db_recovery_file_dest parameters.


Yes

Quote:
What is the use of db_recovery_file_dest when I have log_archive_dest_n parameter?


db_recovery_file_dest is new in oracle 10g for flash recovery area
where as log_archive_dest_n generated archivelog copy on the basis of this parameter

SQL> show parameter log_archive_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string      $ESPSVCS_ORAARC
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable


ie you make 10 copy of your archive logs.
Re: Enable Archive log mode [message #248896 is a reply to message #248894] Mon, 02 July 2007 10:45 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
You cannot enable these parameters if you have set values for the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST parameters. You must disable those parameters before setting up the flash recovery area. You can instead set values for the LOG_ARCHIVE_DEST_n parameters. If you do not set values for local LOG_ARCHIVE_DEST_n, then setting up the flash recovery area will implicitly set LOG_ARCHIVE_DEST_10 to the flash recovery area.


http://www.filibeto.org/sun/lib/nonsun/oracle/10.2.0.1.0/B19306_01/server.102/b14231/create.htm
Previous Topic: Confusion with initial extent in Uniform LMT
Next Topic: erorr Installing Oracle10g when ./runInstaller
Goto Forum:
  


Current Time: Fri Dec 09 19:51:08 CST 2016

Total time taken to generate the page: 0.23057 seconds