Failure with cloning database structure and then restore from source db
577154Sep 28 2007 — edited Sep 28 2007Hello, dear experts!
I am trying to duplicate a database.
First step was to use the DBCA to create a template. Because there is no downtime possible, I only created a template of the structure without user schema and without objects.
At another destination I used this template to create a new database "CLON".
This worked successful. The database is up and running. (But quite empty).
Then I transferred the latest full backup of my source database to the new database. I have the same structure at the destiantion as at the
source.
Now I want to use rman restore to build up the clone with this backup. Therefore I start RMAN and connect to the target without catalog.
"RMAN> restore database;"
leads to:
Starten restore um 27.09.07
Kanal ORA_DISK_1 wird benutzt
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/27/2007 16:26:16
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 709 found to restore
RMAN-06023: no backup or copy of datafile 708 found to restore
RMAN-06023: no backup or copy of datafile 707 found to restore
...
"RMAN> list backup;"
does not show any results.
"RMAN> crosscheck backup;"
Zugewiesener Kanal: ORA_DISK_1
Kanal ORA_DISK_1: SID=17 Gerõtetyp=DISK
"RMAN> list backup;"
does not show any results.
To me this looks as if RMAN does not identify the/any backup.
What has to be done to solve the problem?
Thank you in advance,
Hergen.