Database Backup and Recovery (MOSC)

MOSC Banner

New backup on networkdrive - cant read from new host

edited Aug 25, 2011 2:36AM in Database Backup and Recovery (MOSC) 1 commentAnswered
Hi!
I take a backup on PROD and want to use that backup on test to duplicate the PROD db.

I ran this first on PROD:

[code]

connect catalog rman11cv/password@metarep
connect target /

RUN
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'G:\restore\%U';
BACKUP DATABASE PLUS ARCHIVELOG;
}
[/code]

I runs fine.

I map the network drive on my TEST machine. I run the script:

[code]

connect target sys/password@pdm;
connect auxiliary /;
run {
allocate auxiliary channel 'ch1' type disk;

SET NEWNAME FOR DATAFILE 1 TO 'D:\oracle\oradata\database\data\SYSTEM01.DBF';
SET NEWNAME FOR DATAFILE 2 TO 'D:\oracle\oradata\database\data\UNDOTBS01.DBF';

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