Home » RDBMS Server » Backup & Recovery » RMAN-Backup prod to development
RMAN-Backup prod to development [message #300921] Mon, 18 February 2008 13:06 Go to next message
TanteKaethe
Messages: 4
Registered: November 2006
Junior Member
Hi,

I have imported a copy of the prod database to the development database with data pump.

This time I received a full rman backup.


The data pump import was clear to me: delete all objects in user schema and then import new objects with data.


How do I "import" the rman backup?

Do I have to delete all objects in the the development database before the "restore", too?

Can I just run the following command to "import" the rman backup (OS and Oracle version are identical)
Quote:
set dbid = <development dbid>;
startup nomount;
restore controlfile ;
alter database mount ;
restore database ;
recover database ;


Thanks

[Updated on: Mon, 18 February 2008 13:13]

Report message to a moderator

Re: RMAN-Backup prod to development [message #300924 is a reply to message #300921] Mon, 18 February 2008 13:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't "import" a backup, you restore it.
This means drop the current database.

Regards
Michel
Re: RMAN-Backup prod to development [message #300926 is a reply to message #300921] Mon, 18 February 2008 13:41 Go to previous messageGo to next message
TanteKaethe
Messages: 4
Registered: November 2006
Junior Member
I see. I have to think in a completely different way. If I drop the whole database, the restore will build all datafiles (identical to production)!?
Re: RMAN-Backup prod to development [message #300930 is a reply to message #300926] Mon, 18 February 2008 14:20 Go to previous message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Previous Topic: Rman backup monitoring
Next Topic: Incremental backups are huge
Goto Forum:
  


Current Time: Mon May 13 20:57:00 CDT 2024