| RMAN duplicate [message #463268] |
Wed, 30 June 2010 08:18  |
eigeneachse
Messages: 37
Registered: July 2008
|
Member |
|
|
Hi@all[/email],
for development purposes i want to have a copy if my production database. I want to do the following.
Backup the PROD Database with RMAN -> OK
Use the Backupsets for duplication -> NOT OK
First i tried to do this with an auxiliary connection. This works great with this script.
connect auxiliary sys/VERYSECRET@ORCLNEW;
run
{
duplicate target database to ORCLNEW;
}
Now i want to isolate the process from the production system and, referring to the Oracle documentation, i made the following script.
run
{
DUPLICATE DATABASE ORCL dbid 1248241705 to ORCLNEW
BACKUP LOCATION '/u01/flash_recovery_area/ORCL'
NOFILENAMECHECK;
}
The result is as as printed below
[oracle@orcl_test ~]$ echo $ORACLE_SID
ORCLNEW
[oracle@orcl_test ~]$ rman target / @clone.rmn
Recovery Manager: Release 11.1.0.6.0 - Production on Wed Jun 30 15:14:10 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORCLNEW (not mounted)
RMAN> run
2> {
3> DUPLICATE DATABASE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "database": expecting one of: "target"
RMAN-01007: at line 3 column 11 file: clone.rmn
I want to ask you for help on this issue. What am i doing wrong? Are there any RMAN Configurations that i've forgotten?
The Oracle documentation says we can use something like this.Link
DUPLICATE DATABASE prod TO dupdb
DBID 8675309 # DBID of source database
UNTIL TIME "TO_DATE('11/01/2007', 'MM/DD/YYYY')"
SPFILE
NOFILENAMECHECK;
But this is not as far away then my script, isn't it?
Thanks in advance for every hint.
Regards
Ralph
[Updated on: Wed, 30 June 2010 08:22] Report message to a moderator |
|
|
|
|
|
| Re: RMAN duplicate [message #463272 is a reply to message #463270] |
Wed, 30 June 2010 08:37  |
eigeneachse
Messages: 37
Registered: July 2008
|
Member |
|
|
Mahesh Rajendran wrote on Wed, 30 June 2010 15:33>>Now i want to isolate the process from the production system
By that I suppose you mean not to use Active duplication and totally rely on backupsets and without catalog.
Exactly. I want to manually transfer the backupsets to the development area and process the files there. I don't want to have connections to the production system.
Regards
Ralph
[Updated on: Wed, 30 June 2010 08:38] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
