Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Duplicate database on Server B using rman cold bakcup of Server A.

686680Feb 25 2009 — edited Feb 26 2009
Hi 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 !!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2009
Added on Feb 25 2009
11 comments
656 views