- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Standby database
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
тАО11-09-2006 02:52 AM
тАО11-09-2006 02:52 AM
Standby database
Help me to get an idea of creating a standby database (9.2.04) . Does the flow goes as follows ,
a).Take a hot backup of production DB
b).Transfer the backup to remote host
c).Recover the remote DB to the current production
d).Do some magic with oracle configs
e) Ready to go !
Is it that simple ?
Regards,
Kaps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2006 03:10 AM
тАО11-09-2006 03:10 AM
Re: Standby database
if you to make backup with the base in begin and offline are not necessary to apply file them in case that he wants to leave identica to another base. but without off doubts to best make the procedure with the base and op├Г┬з├Г┬вo and more easy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2006 03:56 AM
тАО11-09-2006 03:56 AM
Re: Standby database
Regards,
Kaps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2006 07:22 AM
тАО11-09-2006 07:22 AM
Re: Standby database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2006 12:41 AM
тАО11-10-2006 12:41 AM
Re: Standby database
That's pretty close. Check out Metalink note 180031.1 on setting up a dataguard environment for more details.
The 9i version of data guard offers some improvements over the old standby database setup.
A couple highlights
If your filesystems are not identical on the seconday server you can use log/db_file_name_convert parameters in the init.ora and have oracle automatically convert file names for you. Also new files can be automatically added to the secondary database - something not available with standard recovery.
You do need to ensure all changes are logged in the database - set force logging in the primary instance.
Check out the Data Guard documentation.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2006 12:54 AM
тАО11-10-2006 12:54 AM
Re: Standby database
step a: you can use RMAN or user-managed backup.
Between b and c. alter database create standby controlfile as '/tmp/standby.ctl';
there is more to step d. some of the highlights are: service_names, lock_name_space, log_archive_dest_##,log_archive_dest_state_##, db_file_name_convert, log_file_name_convert, force_logging.
Consider using recover managed standby, dataguard to manage your standby.
NFS is not recommended.
Of course, last but not least, make sure that you have enough Oracle license to run your server. Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2006 12:59 AM
тАО11-10-2006 12:59 AM
Re: Standby database
Query select FILE#, UNRECOVERABLE_CHANGE#, UNRECOVERABLE_TIME from v$datafile; and make sure that all the changes on the primary are written to logs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2006 01:17 AM
тАО11-10-2006 01:17 AM
Re: Standby database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2006 07:06 PM
тАО11-10-2006 07:06 PM
Re: Standby database
What you are trying to do is neither simple nor complex.
You need to do everything right! I would prefer that you go through the proper documentation and get your steps are clear and precise possible...
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96653/toc.htm
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-27-2006 08:39 AM
тАО11-27-2006 08:39 AM
Re: Standby database
Regds,
Kaps