- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Backup and restoration
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
тАО09-28-2005 03:30 AM
тАО09-28-2005 03:30 AM
Regards,
Allan
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2005 03:35 AM
тАО09-28-2005 03:35 AM
SolutionFor databases, at least Oracle, it is recommended to either:
1) Do a cold backup. This is where the DB is shutdown completely so no one can access it.
2) Do hot backups. This where your DB is in archivelog mode and you put the tablespaces in Backup Mode, then back them up, the take them back out of backup mode.
3) Utilize Oracles RMAN utility to help with backups. Most 3rd party backup products can interface with RMAN.
Any other methods used run the risk of not having valid backups.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2005 03:35 AM
тАО09-28-2005 03:35 AM
Re: Backup and restoration
You state that archiving is off so the backup of the database needs to be done 'COLD' in order to have a good backup of the DB.
If this is done then you will have a good backup and those changes will be present.
If archiving is on then you can put the database into BACKUP MODE, backup the database, backup the archive logs, then when you do a restore you can lay down the DB and the archive logs and the DBAs can apply the archive logs to the DB.
If archiving is off, a good DB backup is a COLD DB during the backup.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2005 03:50 AM
тАО09-28-2005 03:50 AM
Re: Backup and restoration
Regards,
Allan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2005 03:53 AM
тАО09-28-2005 03:53 AM
Re: Backup and restoration
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2005 03:54 AM
тАО09-28-2005 03:54 AM
Re: Backup and restoration
if the database was properly shut down before the full backup (COLD backup) you should have a proper backup copy of your database as for Friday evening.
If you need hot backup you should use RMAN
http://www.oracle.com/technology/deploy/availability/htdocs/RMAN_Overview.htm
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2005 04:20 AM
тАО09-28-2005 04:20 AM
Re: Backup and restoration
A cold backup is a physical backup.
During a cold backup the database is closed and not available to users. All files of the database are copied.The datafiles do not change during the copy so the database is in sync upon restore.
Depending on your requirements it is relatively straight forward to place your system into nonarchivelog mode and use the control file instead of a catalog.
Uncomment or just appent the following example.
log_archive_start = TRUE
log_archive_dest_1 = 'LOCATION=/arch_dir_name'
log_archive_dest _state_1 = ENABLE
log_archive_format = %d_%t_%s.arc
Issue the following commands to put a database into ARCHVELOG mode:
SQL> CONNECT sys AS SYSDBA
SQL> STARTUP MOUNT EXCLUSEVE;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ARCHIVE LOG START;
SQL> ALTER DATABASE OPEN;
Regards,
Simon