Duplicate database on Server B using rman cold bakcup of Server A.
686680Feb 25 2009 — edited Feb 26 2009Hi gurus,
I am planning to duplicate my production database (Server A) using the cold backup taken from RMAN on the Server B. The whole process should be done through RMAN using NOCATALOG mode.
I have transfered the backupsets to the Server B, with the same directory location as of Server A. I want to keep the DB name, and the file location same as the "Production DB".
I started the server B using the Pfile created from Server B's SPFILE.
SQL> *startup nomount pfile='/u01/app/oracle/db/dbs/initcentral.ora';
ORACLE instance started.*
Total System Global Area 8589934592 bytes
Fixed Size 2069904 bytes
Variable Size 5385489008 bytes
Database Buffers 3187671040 bytes
Redo Buffers 14704640 bytes
oracle@hrdbdr01:/home/oracle# rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 25 16:36:21 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: central (not mounted)
*RMAN> run {
allocate channel c1 type disk;
restore controlfile;
}*
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=2190 devtype=DISK
Starting restore at 25-FEB-09
released channel: c1
RMAN-00571: ==================================
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: ==================================
RMAN-03002: failure of restore command at 02/25/2009 16:39:28
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
*RMAN> run {
allocate channel c1 type disk;
restore controlfile from autobackup;
}*
allocated channel: c1
channel c1: sid=2190 devtype=DISK
Starting restore at 25-FEB-09
recovery area destination: /oradb/arch/central/
database name (or database unique name) used for search: CENTRAL
channel c1: no autobackups found in the recovery area
autobackup search outside recovery area not attempted because DBID was not set
released channel: c1
RMAN-00571: ===================================
RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS =====
RMAN-00571: ==================================
RMAN-03002: failure of restore command at 02/25/2009 16:39:59
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/db/dbs/%F';
RMAN-00571: ====================================
RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS =====
RMAN-00571: ====================================
RMAN-03002: failure of configure command at 02/25/2009 16:40:38
ORA-01507: database not mounted
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN-00571: =================================
RMAN-00569: ====== ERROR MESSAGE STACK FOLLOWS =====
RMAN-00571: ================================
RMAN-03002: failure of configure command at 02/25/2009 16:41:26
ORA-01507: database not mounted
PLEASE HELP !!!