Database Backup and Recovery (MOSC)

MOSC Banner

Database backup suggestion using OS level backup

edited May 15, 2009 5:40AM in Database Backup and Recovery (MOSC) 5 commentsAnswered ✓
 Hi,

(11g Enterprise Edition Server on Linux x86-64 and Sun Fire X4150) * 2 on the drawing board with Active Data Guard option

According to my SA, there is no backup tailored to database currently.  I will have to rely on periodic incremental and full OS level backup for a while which only backup closed files.   Can anyone suggest a backup strategy in my case?

I am thinking of RMAN cold backup on the production database to the disk without interrupting the web reporting front end which will connect to the standby read only database (Active Data Guard option).  I haven't read any of the RMAN or Data Guard manuals yet but just by browsing the Internet.  Is this doable?  If so, can it be automated? Also, how long will it take RMAN to perform a cold backup on a database of size about 8 GB?

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