- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Moving Oracle 10gR2 Flashback Logfiles (*.flb) on ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2009 04:45 PM
тАО05-26-2009 04:45 PM
Moving Oracle 10gR2 Flashback Logfiles (*.flb) on the Fly
I was forced to enable archive log and use flash backup, but at the time the destination was on local disk instead of the SAN share.
Due to this everytime oracle starts it updates one of the *.flb file within the flash_recovery_area.
Thus (Oracle is configured as package on SG) when flipping the Oracle package to the other node, it fails to start properly due to not having the latest *.flb file (basically out-of-sync, until you copy the *flb file across).
I updated the db parameter 'db_recovery_file_dest' to point to diskspace on the SAN share once I realised this, but the instance was still using the flashback files on the local disk (until it rolls to new flashback logs - this took some time).
What I want to know is how to move it on demand, similar to moving other log files, or dbs.
When I tried alter database rename file '
it returned:
ORA-01511: error in renaming log/data files
ORA-06000: ....
Anyone have any ideas?
Cheers
Jov
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-03-2009 12:22 AM
тАО06-03-2009 12:22 AM
Re: Moving Oracle 10gR2 Flashback Logfiles (*.flb) on the Fly
I'm not sure about what you can do with flashback logs but maybe it works like redo logs:
- shutdown the database;
- move the logs;
- startup mount;
- and Finaly, alter database rename file...;
But, to be sure check the manual or Metalink about it...
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-03-2009 12:58 AM
тАО06-03-2009 12:58 AM
Re: Moving Oracle 10gR2 Flashback Logfiles (*.flb) on the Fly
Thanks for the response, but the steps you listed were followed and it gave the error I mentioned in my original post.
Regards
Jov
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-03-2009 01:20 AM
тАО06-03-2009 01:20 AM
Re: Moving Oracle 10gR2 Flashback Logfiles (*.flb) on the Fly
What about moving the files to the target destination and creating a symbolic link to the SAN share?
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-03-2009 05:15 AM
тАО06-03-2009 05:15 AM
Re: Moving Oracle 10gR2 Flashback Logfiles (*.flb) on the Fly
Maybe you need to "alter database flashback off" before renaming the flashback logs...
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-03-2009 06:54 AM
тАО06-03-2009 06:54 AM
Re: Moving Oracle 10gR2 Flashback Logfiles (*.flb) on the Fly
If you are using ASM I recomend Metalink Note 438580.1.
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2009 09:32 AM
тАО06-18-2009 09:32 AM
Re: Moving Oracle 10gR2 Flashback Logfiles (*.flb) on the Fly
The original *.flb files were on local disk and we had to move them onto the SAN given Oracle was in a SG Cluster Package.
I enabled Flashback Snapshots becauses the app guys were applying their solution and it killing the Oracle DB Instance almost everytime, thus flashback was a good time saver instead of re-creating the db instance.
At the time I was not aware that flasback recovery (FR) allocation was on local disk, thus the initial snapshots were saved on the local disk (keep in mind these ware Oracle Managed Files).
After realising the FR space was on local disk I updated the parameters to point to the SAN VG, but that didn't change existing Flashback Snapshot files
The only was way to delete the snapshots then recreate these snapshots after the FR points to the SAN.
Thanks for the suggestions anyway as they were tried before posting.
Jov
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2009 09:32 AM
тАО06-18-2009 09:32 AM