Database Backup and Recovery (MOSC)

MOSC Banner

Multiple backup-restore using cold backup

edited Jun 10, 2014 4:23AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

Hello,

I'm a beginner with RMAN backup-restore utility, and have a question about something I have done and seems working, but does not seem very clean.

Here is the situation:

I have a test database (11.1.0.7.0), which is not archived, and a developer is making data transformation on it regularly.

So my job here is to take a cold backup and restore it whenever it fails.

I have made a full backup in mount mode including controlfile:

RMAN> run{

     allocate channel ch1 device type disk ;

     backup database noexclude include current controlfile

     format '/oracle/backup/DB_TMP_%t_%s_%p';

     }2> 3> 4> 5>

allocated channel: ch1

Tagged:

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center