| Enable Archive log mode [message #247414] |
Mon, 25 June 2007 15:44  |
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 #247416 is a reply to message #247415] |
Mon, 25 June 2007 16:04  |
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 |
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 #247643 is a reply to message #247438] |
Tue, 26 June 2007 11:22 |
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 |
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 #248788 is a reply to message #248667] |
Mon, 02 July 2007 00:29 |
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 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
