如何備份克隆數(shù)據(jù)庫(kù)

這篇文章主要介紹如何備份克隆數(shù)據(jù)庫(kù)，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！

---基于備份克隆


1、創(chuàng)建pfile
  create pfile from spfile
添加
  log_archive_dest
compatible=


2、創(chuàng)建密碼文件及文件夾


orapwd file=D:\app\product\11.2.0\dbhome_1\database\PWDGTJ.ora password=GTJ entries=4


3、listener.ora、tnsnames.ora創(chuàng)建本地命名一定要在目標(biāo)數(shù)據(jù)庫(kù)以及輔助數(shù)據(jù)庫(kù)創(chuàng)建


4、注冊(cè)新實(shí)例


oradim –new –sid GTJ –intpwd GTJ


5、創(chuàng)建spfile


create  spfile from pfile='D:\app\product\11.2.0\dbhome_1\database\initgtj.ora' 


STARTUP NOMOUNT FORCE PFILE='D:\app\product\11.2.0\dbhome_1\database\initgtj.ora' 


 alter system set compatible='11.2.0.4.0' scope=spfile;


 




DUPLICATE TARGET DATABASE
  FOR STANDBY
  FROM ACTIVE DATABASE
  PASSWORD FILE
  SPFILE 
    PARAMETER_VALUE_CONVERT '/disk1', '/disk2'
    SET DB_FILE_NAME_CONVERT '/disk1','/disk2'
    SET LOG_FILE_NAME_CONVERT '/disk1','/disk2'
    SET DB_UNIQUE_NAME 'dup1'
    SET SGA_MAX_SIZE 200M
    SET SGA_TARGET 125M;


6、連接rman 
目標(biāo)數(shù)據(jù)庫(kù)以及輔助數(shù)據(jù)庫(kù)都要?jiǎng)?chuàng)建
rman    AUXILIARY  sys/gtj@gtjtest






7、克隆數(shù)據(jù)庫(kù)
-----------------運(yùn)行成功-------------------------------------------------------------
RUN{ 
SET NEWNAME FOR DATABASE TO 'D:\APP\ORADATA\GTJ\%b';
DUPLICATE DATABASE TO 'GTJ' BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09' NOFILENAMECHECK;
}
rman nocatalog
connect target sys/oracle@zz
connect AUXILIARY  sys/gtj@gtjtest
rman  target sys/oracle@zz  AUXILIARY  sys/gtj@gtjtest
run{ 
 
SET NEWNAME FOR DATABASE TO 'D:\APP\ORADATA\GTJ\%b';


duplicate target database to GTJ FROM ACTIVE DATABASE 
logfile   
group 1 ('D:\APP\ORADATA\GTJ\REDO01.LOG') size 10m,   
group 2 ('D:\APP\ORADATA\GTJ\REDO02.LOG') size 10m,   
group 3 ('D:\APP\ORADATA\GTJ\REDO03.LOG') size 10m;   
  
}  
------------------------參考-----------------------------------------------------------
RUN{
DUPLICATE DATABASE ORCL TO 'GTJ' BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09' 
SET DB_FILE_NAME_CONVERT ('D:\APP\ORADATA\ORCL','D:\APP\ORADATA\GTJ')
SET LOG_FILE_NAME_CONVERT ('D:\APP\ORADATA\ORCL','D:\APP\ORADATA\GTJ');
}


DUPLICATE DATABASE TO GTJ
  UNTIL TIME "TO_DATE('08/09/2017 19:00:00', 'MM/DD/YYYY HH24:MI:SS')"
  BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09'
  NOFILENAMECHECK;


alter system set db_recovery_file_dest='D:\app\flash_recovery_area'


RUN
{  
  ALLOCATE AUXILIARY CHANNEL newdb DEVICE TYPE sbt; 
  DUPLICATE TARGET DATABASE TO newdb
    PFILE ?/dbs/initNEWDB.ora
    UNTIL TIME 'SYSDATE-1'  # specifies incomplete recovery
    SKIP TABLESPACE example, history   # skip desired tablespaces
    DB_FILE_NAME_CONVERT ('/h2/oracle/dbs/trgt/','/h3/oracle/oradata/newdb/')
    LOGFILE
      GROUP 1 ('/h3/oradata/newdb/redo01_1.f',
               '/h3/oradata/newdb/redo01_2.f') SIZE 4M,
      GROUP 2 ('/h3/oradata/newdb/redo02_1.f',
               '/h3/oradata/newdb/redo02_2.f') SIZE 4M,
      GROUP 3 ('/h3/oradata/newdb/redo03_1.f',
               '/h3/oradata/newdb/redo03_2.f') SIZE 4M REUSE;
}






RUN
{
  SET NEWNAME FOR DATABASE TO '/oradata1/%b'; 
  DUPLICATE TARGET DATABASE TO dupdb
    LOGFILE
      GROUP 1 ('/duplogs/redo01a.log', 
               '/duplogs/redo01b.log') SIZE 4M REUSE,
      GROUP 2 ('/duplogs/redo02a.log',
               '/duplogs/redo02b.log') SIZE 4M REUSE;
}
 


DUPLICATE DATABASE TO GTJ
  UNTIL TIME "TO_DATE('08/09/2017 19:00:00', 'MM/DD/YYYY HH24:MI:SS')"
  BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09'
  NOFILENAMECHECK;


DUPLICATE DATABASE 'PROD' dbid 8675309 to 'TEST'
  UNTIL TIME "to_date('11/01/2007', 'MM/DD/YYYY')"
  BACKUP LOCATION '/backups' NOFILENAMECHECK
  PFILE='?/dbs/inittest.ora' db_file_name_convert='prod','test';

以上是“如何備份克隆數(shù)據(jù)庫(kù)”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注億速云行業(yè)資訊頻道！