Prev: Hyperion Planning Developer 9.3/11.3 , Hartford, Connecticut
Next: Oracle PL/SQ L , Toronto, ON, Canada
From: Fin on 11 Aug 2010 17:54
I am wanting to use an Incremental backup to maintain a readable copy
of my database on a separate machine. I have read the articles
regarding turning TRACKMOD on and doing a FULL backup prior to
performing incremental backups.

My database does not have online users and is only really used once a
day with data being LOADED into a single table and several Stored
Procedures then distribute the processed results to be stored in
appropriate tables based on date. As I do not have online users per
say, having processed said updates, what would be the most efficient
method to keep the copy updated ?

I could take incremental backups and use a redirected restore on the
backup file, but I don't want to have to deal with log files is that
is at all possible. Is this at all possible ? or after performing a
restore does one still have to roll forward log files ? I would have
thought if nothing else changes post backup, then restoring the backup
should be sufficient to apply an changes to updated tables ? I would
have thought that the log fiels would only be necessary of changes
were made AFTER the incremental backup was taken no ?

Also, if further Stored Procedures / UDFs / tables etc are added does
the backup also apply those to the target database ?

Many thanks , Tim
From: stefan.albert on 12 Aug 2010 04:55
if you don't have "online" users you can run an offline backup - this
means that the database is not connectable in the time of the backup.
this can be a full or incremental backup.
when restoring an offline backup you don't need to fuzz around with
log files.
and yes, UDFs, SPs and tables added to the DB are included in the
backup.
From: Fin on 12 Aug 2010 12:22
Thanks for the response, I had hoped as much. Excellent news.
 | 
Pages: 1
Prev: Hyperion Planning Developer 9.3/11.3 , Hartford, Connecticut
Next: Oracle PL/SQ L , Toronto, ON, Canada