Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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
avdba_22
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
Starikovsky
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: 21st August 2014 - 09:02 AM