Database Backup and Recovery (MOSC)

MOSC Banner

RMAN scripts.

edited Jun 26, 2012 11:04PM in Database Backup and Recovery (MOSC) 1 commentAnswered
Dear All,

Thank you for your help...

I  am not too familiar with RMAN, and have been given a set of scripts that will help us restore a database from an RMAN backup..

However, the script fails:

I detail the scripts:

<database in nomount state>

05. On target server:

 startup nomount;

06. rman target /

       configure controlfile autobackup format for device type DISK to '/u02/backup/APGATE/CNTRL_%F';

       run {
        allocate channel c1 device type disk;
        restore controlfile from autobackup;
        sql "alter database mount";
        }

07. rman target /
        run {
        restore database;
        switch datafiles all;
        }


08. rman target /
        list backup of archivelog all;


09. rman target /
        recover database until sequence=<from step 8>

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