OraFAQ Forum: Backup & Recovery » how to change archivelog destination in oracle 10g

Home » RDBMS Server » Backup & Recovery » how to change archivelog destination in oracle 10g (oracle 10g, windows 7 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to change archivelog destination in oracle 10g [message #574498]

Fri, 11 January 2013 05:36

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

Hello,
I want to change my archive log destination currently my database its in archive mode and this archive log detail as under

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            F:\archivelogs
Oldest online log sequence     220
Next log sequence to archive   221
Current log sequence           221
SQL> show parameter DB_RECOVERY_FILE_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      F:\flash
db_recovery_file_dest_size           big integer 8000M
SQL>

this my f drive space is full so i want to change this my archive destination to my another g drive so how can i do this.and if i change this my archive destination does its affect any problem while recover my database in future.please help me in this situation

Report message to a moderator

Re: how to change archivelog destination in oracle 10g [message #574500 is a reply to message #574498]

Fri, 11 January 2013 05:54

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ ALTER SYSTEM SET <archived log destination parameter you use>=<anywhere you want>;
See "show parameter archive" and Database SQL Reference for ALTER SYSTEM

2/ If you use RMAN to backup and you need to recover you will have to catalog the archived logs (backups) if you don't restore them in the same location they were backed up.

Regards
Michel

Report message to a moderator

Previous Topic:	Re: does the full cold backup of rman include onlinde redologs?
Next Topic:	Recovery on DR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 11:17:16 CST 2024