RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection_874352.1
RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection (Doc ID 874352.1)
In this Document
Applies to:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform. ***Checked for relevance on 9-Sep-2013*** GoalRman 11g release 2 provides us the flexibility of creating the rman duplicate without connecting to the target database and recovery catalog.
All rman needs here is the location of the backup pieces which is accessible and rman reads the backup pieces and restores the spfile,controlfile,datafiles and archivelog files to perform the duplicate operation.
This is a New Feature in 11gR2
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/wnbradv.htm#BRADV021 Oracle? Database Backup and Recovery User's Guide 11g Release 2 (11.2) . What's New in Backup and Recovery? Solution
Process involved in this type of duplicate database
++ Rman restores the spfile from the backup pieces located in the mentioned location. The steps involved in creating the duplicate database are as follows
1) Take a backup of the spfile, controlfile, database, and archivelogs as follows:
RMAN> backup spfile ;
RMAN> backup database include current controlfile plus archivelog ;
++ If the duplicate is going to happen on different server, move the backup pieces to a new server using commands like ftp,scp etc.
++ If the duplicate is going to happen on the same server as target, then you can either retain them in the same location where the backup was done or copy it to a required location.
For unix copy the password file from the target database to $ORACLE_HOME/dbs and rename it.
For windows copy the password file from the target database to %ORACLE_HOME/database and rename it.
DB_NAME=dup11r2
Unix Example
============ Just set the environment variables and start the instance. % export ORACLE_SID=dup11r2 % export ORACLE_HOME=/home/oracle/ora11g % export PATH=$ORACLE_HOME/bin:$PATH % sqlplus "/as sysdba" SQL > startup nomount
Windows Example
=============== Create a service and then set the necessary environment variables and start the instance. % oradim -new -sid dup11r2 set ORACLE_SID=dup11r2 set ORACLE_HOME=D:\Orahome\Ora11gr2 set PATH=D:\Orahome\Ora11gr2\bin;%PATH% % sqlplus "/as sysdba" SQL > startup nomount
EXAMPLE
======= % rman auxiliary / RMAN > DUPLICATE DATABASE TO dup11r2 UNTIL TIME "TO_DATE('29-MAY-2010 14:16:42','DD-MON-YYYY HH24:MI:SS')" SPFILE set control_files='D:\dup11r2\c1.ctl' set db_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2' set log_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2' BACKUP LOCATION 'D:\dup11r2' ; |
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1263438/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Creation Of Rman Duplicate Without Target And Recovery Catalog Connec-1113713.1
- Duplicating a Database Without Recovery Catalog or Target ConnectionDatabase
- RMAN-20001: target database not found in recovery catalogDatabase
- RMAN DUPLICATE Without Connecting To Target DB For Both Disk & Tape_1375864.1
- RMAN-20002: target database already registered in recovery catalog 解決方法Database
- 【RMAN】RMAN-20001: target database not found in recoveryDatabase
- rman duplicate target database RMAN-03002 RMAN-03015 RMAN-06136Database
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- Oracle 11gR2 使用RMAN Duplicate複製資料庫Oracle資料庫
- Oracle OCP IZ0-053 Q241(RMAN Recovery Catalog Keep)Oracle
- Create recovery catalog Configure Recovery Manager
- Creating Physical Standby using RMAN Duplicate Without Shutting Primary_789370.1
- Recovery Catalog creation and MaintenanceAINaN
- “rman target /” 和 “rman nocatalog target /” 區別
- oracle rman catalogOracle
- Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1]
- RMAN duplicate databaseDatabase
- rman catalog 命令所能catalog 的物件物件
- Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE WithoutGUIIDEDatabase
- Oracle 11gR2 使用 RMAN duplicate from active database 複製資料庫OracleDatabase資料庫
- rman 建立catalog庫
- RMAN - catalog start with命令
- "rman target /” 和"rman nocatalog target /”區別實踐
- oracle 10g rman duplicate target database for standby會自動新增臨時檔案Oracle 10gDatabase
- 【RMAN】catalog資料庫資料庫
- 【Oracle】rman upgrade catalogOracle
- rman中的catalog命令!
- upgrade oracle rman catalogOracle
- 通過rman duplicate database!Database
- RMAN duplicate On Windows7Windows
- 解決RMAN中 recovery catalog database: ORA-00955: name is already used by an existing objectDatabaseObject
- Oracle 11gR2 fast recovery area = flash recovery areaOracleAST
- Oracle 11GR2 Duplicate from BackupOracle
- rman target / debug trace
- rman: can't open target
- 11gR2中使用duplicate建立physical standby (從rman備份或從active database)Database
- rman duplicate操作手冊
- RMAN duplicate database到新主機Database