Database Backup and Recovery (MOSC)

MOSC Banner

when to use "using backup controlfile"

edited Aug 28, 2017 11:46AM in Database Backup and Recovery (MOSC) 7 commentsAnswered

Hi,

I want to make a simple restore / recovery on a new identical oracle (same os, os version and oracle version) (DRP, oracle 11 or 12). DB is in archivelog. I have a rman backup (controlfile autobackup is on), archive logs since backup, current redo log, dbid on disk e:.

=> New hardware is an image of the "original" database, but a few months older. So folders exist, spfile is unchanged, but controlfile/datafiles/... are old versions

=>

copy e:\redolog\*.* c:\oralogs\online /Y

using rman:

set dbid=...

startup nomount;

restore controlfile from 'e:\backup\....';

alter database mount;

catalog start with 'e:\backup\';

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