I have a requirement from my manager to basically replicate an environment running on one Linux machine onto another. Lets say there are two machines A and B
I have all my applications (these applications have a database running and some of them also require weblogic) on machine A.
Now I want to replicate these applications in A on machine B. So my doubt is, if I copy the database folders from A to B, can I startup the database on machine B.
Also, in case this method doesn't work out, can creating a dump of the database in A and importing the same in B work?
>So my doubt is, if I copy the database folders from A to B, can I startup the database on machine B.
above will succeed if the database on A was cleanly shutdown prior to the start of the copy & left down for the duration of the copy.
but you may not ever be able to run OUI against system B to upgrade this database
Follow the steps here....
After logging into target database, under maintenance tab, data movement header; ther is "clone database" option. When you click on it; you'll see :
Clone Database uses RMAN to duplicate a database from:
-- An open database in ARCHIVELOG mode, or
-- An open database in NOARCHIVELOG mode (restart required), or
-- A saved working directory from previous cloning
Clone Database performs the following operations:
-- Backup each database file and store it in a working directory
-- Transfer each backup file from source to destination host
-- Restore each backup file to existing destination Oracle Home
-- Recover the cloned database with saved archived log files
-- Open the cloned database with resetlogs
Yes, emre_baransel ( Employee ACE ) wrote well. This is steps Backup based duplication.
and I want add additionally, if we are using NOARCHIVELOG mode, then we must use NOREDO option for recover.
ARCHIVELOG mode is not best practice. For High Availability database must be running archivelog mode.
Mahir M. Quluzade
I changed altered the database to archive log mode. however, while trying to take a backup using RMAN I encountered the following error
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of backup plus archivelog command at 11/21/2013 03:49:03
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/21/2013 03:49:00
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 67108864 bytes disk space from 4322230272 limit
any workarounds for this