NOLOGGING table in ARCHIVELOG
Hi,
I have few Staging tables in( my ETL environment ) where I want to switch off the logging i.e want them to be in NO LOGGING mode.
But I have a confusion that would I be able to recover them using the point-in-time recovery (suppose something goes wrong with the table).
Fact :
1. database is running in archive mode
2. we take incremental RMAN archive log backup every day and cumulative backup everty weekend.
3. database block change tracking is off.
Actually we delete the source data files ( i.e delta ) once the ETL job is finised i.e once data is loaded into staging area.
I have few Staging tables in( my ETL environment ) where I want to switch off the logging i.e want them to be in NO LOGGING mode.
But I have a confusion that would I be able to recover them using the point-in-time recovery (suppose something goes wrong with the table).
Fact :
1. database is running in archive mode
2. we take incremental RMAN archive log backup every day and cumulative backup everty weekend.
3. database block change tracking is off.
Actually we delete the source data files ( i.e delta ) once the ETL job is finised i.e once data is loaded into staging area.
0