I used below steps to change Archivelog destination for Oracle 10g.
Step 1: Login to Database as SYSDBA
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2BH3RNb5SsBuoluwWoLxelCKH_6rTUq_B2ioskf83wa10F3N6qd3rzGAOevGyFU5VtgvR4qT8PHXb5KWuQmW7Nx95D8cUR548NfiNHr7V9keQ-qwwQiCLqxpD10IINhF9krzBmUstU1sS/s320/1.bmp)
Step 2: Check the Archive Destination using archive log list command.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHCPkr9hxzf3vKKq5H8h99xX-t70H0NmBnE6r3iEpPYhERMXWGYwbLG3GI-EkRvjGQgzxpfhWRhWc6X2LoLrZ4e5DJ-Bkq5_RAux5mV8sLAke46lbc7VNL8tzTfEEo63bw8p3wPs_EBniG/s320/2.bmp)
Step 3: Set the value of db_recovery_file_dest Parameter.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnMbX63_9XrT_b72lqHhp95gWnKiU0sV97d3fvTTeHcYSrUwsD6RI6jpkDiJ0hkU6XpOKhvlmTeAT6lnQnjUZ5mAxSgDWzOzj0Zt3sR9Oj1Knc4D1p0ZEKc1Z0bNTPHWKmtu8C3OAUNDm8/s320/3.bmp)
Step 4: Set the value for db_recovery_file_dest_size Parameter
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioGECCe6okN37ZZXh0kYt6b6Ll37iBMm4d6yCh6yCZl74lH0ycaqVTjqADtJk6Gc5B70eKmpR-mUz9ScpHXNWQWo6R7ACZywuhGz1At-oBvGPZG70JZ4GhihPpYxGXUB_-ZZiIrfZNdcm-/s320/4.bmp)
Step 5: Check the new location for Archivelog destination
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx8SCaC-NeR_8NAWnhJCmPUpRA2msUbv_uD5orHEFXYhRjg00FN3YcRzR041fIxZw3KaTrTNBZ1JTlYkm268C5hXQWjC7A8eTEGbnNWn_45PhDO2EO6FHqmudoZy3Os00coM3etY_MYcWV/s320/5.bmp)
Step 6: Use the below command to generate Archivelog.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgx4qFYoJUPj6kb8__wwFWeg5R5f2qRcnckb5XYegZLC49kBYI1PYo-wFM19hvjCGfpy_FlnmDk1rYRp4mx2GtBVQ-6JlFHdj2zsIL3PaC48uyoyQpCC9mC9qLJp2_XqI4IRXM6dZ2QrPER/s320/6.bmp)
Step 7: Use the below command to check Archive Destination and log sequence.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqTgXVLWfVfq_durdNfQTJOX08sEQW_YdvPNHckYCHFRuD1IM4A7d6-jCjECuqr6d9N34KyRYCE0cVUIqS9_YhUcxQL1tPbs0CC3EkScwkZZUipiFMFc8XkkgW03sRgWAuGhpJZSoGMcNl/s320/7.bmp)
No comments:
Post a Comment