- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- tar and zip backups/recovery
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-14-2009 09:55 AM
тАО05-14-2009 09:55 AM
is it possible? in deffirent the 2 case
1. database online
2. database offline
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2009 10:17 AM
тАО05-14-2009 10:17 AM
Re: tar and zip backups/recovery
But more than likely, if the database is online, your backup will not be valid and will not be able to restore properly, as it tries to backup open files and some times it is successful and sometimes it fails. Even if it is successful, it may have inconsistent data and when restored, oracle may not like the restored files.
UNIX because I majored in cryptology...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2009 10:18 AM
тАО05-14-2009 10:18 AM
Re: tar and zip backups/recovery
2. database offline -- should not be a problem. That should be straight forward.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2009 12:27 AM
тАО05-15-2009 12:27 AM
SolutionBasicaly, you have those 2 backup modes you already refered: offline and online.
In the offline (the easier way), you just have to shutdown your apps and database and copy the $APPL_TOP, all your controlfiles, redologs and database files and, if you patched the database recently, your $ORACLE_HOME also.
In the online mode, you have to:
- first ensure you have a minimum 30Gb disk space for the archivelogs. If you don't have then buy a disk first;
- shutdown the apps (ensure users are out) as the apps owner (usually applmgr):
$ cd $COMMON_TOP/admin/scripts/
applmgr$ adstrtal.sh stop
- shutdown the db as db owner (usually oracle):
$ cd $ORACLE_HOME/appsutil/scripts/
$ addbctl.sh stop immediate
- backup you database in offline mode (cp, tar,...);
- in the meantime edit your init.ora to edit the following parameters:
$vi $ORACLE_HOME/dbs/init
/log (vi command to search for existing paramaters. If they already exists then edit them, else add them: )
log_archive_dest='/disc.../.../
log_archive_start=TRUE
- Set the archivelog mode (still as db owner oracle):
$sqlplus '/ as sysdba'
SQL>create spfile='/THE_FULL_PATH.../init
SQL>startup mount;
SQL>alter database archivelog;-- I'm not sure this is necessary since you have already set "log_archive_start=TRUE"
SQL>alter database open;
- Shut down your database:
SQL>shutdown immediate;
SQL>exit;
- Finaly, backup it again in offline mode (cp, tar,...)
- Now you are ready to start rman backups (I attached a quick start guide for rman that you should start looking.
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2009 06:13 AM
тАО05-15-2009 06:13 AM
Re: tar and zip backups/recovery
Look at Oracle Note 230672.1 for R11i
and 406982.1 for R12i