- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Rollback Segments VS. Redo Logs
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-16-2003 11:57 AM
тАО05-16-2003 11:57 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2003 12:08 PM
тАО05-16-2003 12:08 PM
SolutionOracle maintains logs of all transactions against hte database. These transactions are recorded in files caled online redo log files. These logs are used to recover the database's transactions in their proper order in the event of a database crash. The redo log information is stored external to the databases datafiles.
Each Oracle database will maintain two or more onlien redo log files. When the log is filled, the database goes on to the next one.
If the database is running in archvielog mode then the database will make a copy of the online redo log files before overwriting them. These are called archvie logs.
Rollback segments allow users to udo transactions they have made against a database. This function is available for update, insert, delte transactions. It is not available for changes to database objects such as alter table commands.
Hope this helps.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2003 12:15 PM
тАО05-16-2003 12:15 PM
Re: Rollback Segments VS. Redo Logs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2003 12:44 PM
тАО05-16-2003 12:44 PM
Re: Rollback Segments VS. Redo Logs
log1
log2
log3
When the database is started it will start writing transactions to log1.
when log1 is full it will start writing to log2
when log3 is full it will then erase log1 and start writing there.
If its in archivelog mode, it will first copy off the contents of log1 to an external file and then erase log1 and start writing.
Thats the way its supposed to work. I would look at your init.ora file if its not behaving as expected.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2003 12:53 PM
тАО05-16-2003 12:53 PM
Re: Rollback Segments VS. Redo Logs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-17-2003 01:52 AM
тАО05-17-2003 01:52 AM
Re: Rollback Segments VS. Redo Logs
Just a few words of caution and some guidelines.
You cannot HOT backup a noarchivelog mode database.
With NOARCHIVELOG mode, YOU must be prepared to lose data at some point, it is inevitable.
In order to backup (without RMAN) you will follow the steps in:
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76993/toc.htm
which is the backup and recovery guide. It covers what structures you must backup in chapter 1. Basically you will need to
o shutdown normal
o copy the datafiles, control files, init.ora files
o startup
You do not want or need the online redo log files, when you restore, you'll be doing an "open resetlogs" which will recreate them.
Make SURE you test these backups by restoring them and seeing that everything you need is there. Make sure that as you add datafiles to the database, your backup routine will pick them up.
hope this helps!
regards
Yogeeraj