| how to change location of archive file for already running 24x7database in archive mode? [message #112988] |
Wed, 30 March 2005 06:49  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
My Oracle database (24x7) is running in archive log mode on RED hat linux operating system now i want to change the location of my archive log file from
/usr/app/oracle/flash_recovery_area/JODO/archivelog/
to
/var/oracle/flash_recovery_area/
what are steps to change location of archive log file?
---------------------------
when i am trying this query
---------------------------
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1= 'location = /var/oracle/flash_recovery_area/';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1= 'location = /var/oracle/flash_recovery_area/'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
------------------------------------------
i know how to create sp file from pfile .... but please let me know that if my database is started by configuration of spfile then how i can make change in my spfile .... is it so that, i have to set parameter in my init.ora then i have to compile that init.ora again to create spfile or i have to do something else..
----------------------------------
i hope you all are able to understand my question...
it will be better if some one gives me step to change location of my archive log
yours faithfully
sunil
|
|
|
|
| Re: how to change location of archive file for already running 24x7database in archive mode? [message #113019 is a reply to message #112988] |
Wed, 30 March 2005 10:30  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Please refer oracle documentation for more information.
sys@mutation_mutation > archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/product/9.2.0/dbs/arch
Oldest online log sequence 45
Next log sequence to archive 47
Current log sequence 47
sys@mutation_mutation > alter system archive log start to '/u01/app/oracle/product/9.2.0/dbs/arch2';
System altered.
sys@mutation_mutation > archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/product/9.2.0/dbs/arch2
Oldest online log sequence 45
Next log sequence to archive 47
Current log sequence 47
sys@mutation_mutation > alter system switch logfile;
System altered.
sys@mutation_mutation > !ls -lrt $ORACLE_HOME/dbs/arch2
total 41056
-rw-r----- 1 oracle dba 93090304 Mar 30 10:23 1_47.dbf
sys@mutation_mutation > alter system set log_archive_dest='/u01/app/oracle/product/9.2.0/dbs/arch2' scope=spfile;
System altered.
sys@mutation_mutation > show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string /u01/app/oracle/product/9.2.0/
dbs/arch2
[Updated on: Wed, 30 March 2005 10:40] Report message to a moderator |
|
|
|
| Re: how to change location of archive file for already running 24x7database in archive mode? [message #113297 is a reply to message #113019] |
Fri, 01 April 2005 02:40 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
Mahesh thank u very much ... for your relpy as i m working on database which is 24x7 and i dont have test server so i am scared to do any thing on the server directly as a dba... i know how to aduti DBA work but fact is that if mydatabase is not in working position than client dont allow me to work on error they just want to know y database is not allowing them to connect all such question they ask on phone ... as i have to manage Database 24 hr daily and here is no other team of database administrator... and to be very honest nothing is proper on my database... yea but its running...as this is my new job i m scared that if things get wrong everyone will blame me not the person who handling database earlier ...i hope you understand ...one thing more i have to report to that person who dont know oracle database ... i dont know what to do ....
Mahesh i know this is not technical question but as as DBA what i am feeling now other DBA must have also goen through this phase in their past.
If you have any idea then please let me know ..what i should do?
One technical question is if i want to start archive log at 2 location then what query i shuould write .
Note :- database is 24x7 on linux ... so i m not going to stop it .. i need only query..
thank u mahesh..and other who will reply
friend
sunil
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
