Database Backup and Recovery (MOSC)

MOSC Banner

RMAN Incremental backups or Archive Log backups

edited Sep 19, 2014 5:02AM in Database Backup and Recovery (MOSC) 5 commentsAnswered

I do a full RMAN backup each night, and hourly archive log backups every hour.

I've successfully recovered my production database to any point in time.

This way I know exactly which backups I need to do a restore - the previous nights backup, and the archive log backups to just after the point in tie I want to recover to.

However, I've met several other Oracle DBA's who have suggested to do RMAN Level 0, and then Level 1 cumultive and differentail backups.  This I think is just added complictions, as i have to know which backup i need to restore my database from - essential for whne I refresh my test databases from production. (How do I knwo which files to copy to the test system for example...)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center