×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Continuous Operation question

Continuous Operation question

Continuous Operation question

(OP)
Hi, All

According to the manual:

"Continuous Operations provides the ability to backup data files while database applications are running and users are connected.  However, in the event of a hard drive failure, if you use Continuous Operations to make backups, you will lose all changes to your data since the last backup. You cannot use Archival Logging and the Maintenance utility Roll Forward command to restore changes to your data files that occurred after the last backup."

So, for example, if the hard drive fails in the middle of continuous operations and the last backup took place the night before, does this mean that all the data entered today is gone?

Any reply would be helpful.

Regards,

William Chadbourne
Oracle DBA

RE: Continuous Operation question

Where in the docs did you see that?  
What version of PSQL are you using?

If your hard drive fails to the point of requiring a back up, it probably won't matter what state the file is in.

Are you trying to prepare for failure or is there some other reason for your question (like your seeing an error)?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Continuous Operation question

(OP)
Hi, mirtheil

1. Advanced Operations Guide - Page 8-21
2. PervasiveSQL V8.6 R2
3. I have just installed Pervasive and have to set up the backups which by the way really suck.

Regards,

William Chadbourne
Oracle DBA

RE: Continuous Operation question

What process are you doing for backups (why do they "really suck")?  

I also guess I don't understand the reason for the original question.  If a hard drive fails, would expect any data since the last backup, regardless of the application, to be available?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Continuous Operation question

(OP)
Hi, mertheil

In Oracle, yes because I would have it multplex the archive logs and control files to a separate disk and if available to another server.

I am just backing up data files.  I also have to create a list of all the files to back up and point to it in order to go into continuous operation mode.

Regards,

William Chadbourne
Oracle DBA

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close