Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> nologging tables and rman backup, nologging tables and rman backup
post Dec 12 2007, 10:33 AM
Post #1

Advanced Member

Group: Members
Posts: 110
Joined: 25-February 05
Member No.: 1,517

We have lots of tables created with no logging option in one of our database. Will this be a problem? we do rman backups. Any special handling that needs to be done here?

Thank you.
Go to the top of the page
+Quote Post
post Dec 12 2007, 11:35 AM
Post #2

Advanced Member

Group: Members
Posts: 119
Joined: 13-November 07
Member No.: 13,939

Let me quote Oracle documentation...

"Incremental Backup Algorithm --
Each data block in a datafile contains a system change number (SCN), which is the SCN at which the most recent change was made to the block. During an incremental backup, RMAN reads the SCN of each data block in the input file and compares it to the checkpoint SCN of the parent incremental backup. (If block change tracking is enabled, RMAN does not read the portions of the file known to have not changed since the parent incremental backup.) If the SCN in the input data block is greater than or equal to the checkpoint SCN of the parent, then RMAN copies the block.

One consequence of this mechanism is that RMAN applies all blocks containing changed data during recovery—even if the change is to an object created with the NOLOGGING option. Hence, making incremental backups is a safeguard against the loss of changes made by NOLOGGING operations." (1)

(1) RMAN Backup Types -- Oracle® Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)
Part Number B14191-02
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 24th September 2017 - 12:27 PM