溫馨提示×

溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊×
其他方式登錄
點(diǎn)擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》

duplicate命令中有pfile、logfile、*_file_name_convert、nofilenamecheck的案例

發(fā)布時(shí)間：2020-08-17 13:04:06 來源：ITPUB博客 閱讀：146 作者：lusklusklusk 欄目：關(guān)系型數(shù)據(jù)庫
總結(jié)
1、pfile選項(xiàng)說明使用的rman命令執(zhí)行的那端的一個(gè)文件
如果rman在源端開啟，則pfile放在源端上，如果ramn在目標(biāo)端開啟，則pfile放在目標(biāo)端上
2、logfile表示在duplicate命令中生成目標(biāo)端的文件，和rman命令在哪端執(zhí)行無關(guān)
logfile的生成的文件在目標(biāo)端，logfile選項(xiàng)時(shí)必須指定size
3、一般操作時(shí)，除非自己清楚源端和目標(biāo)端的datafile、online redo log文件不在同一個(gè)共享的目錄中，否則不要加上nofilenamecheck
4、如果pfile或spifle中指定了*_file_name_convert參數(shù)，但是duplicate命令中重新指定了db_file_name_convert、logfile選擇，則會覆蓋掉pfile或spifle中指定了*_file_name_convert參數(shù)的設(shè)置，見如下logfile、*_file_name_convert、nofilenamecheck選項(xiàng)中5、6的實(shí)驗(yàn)


pfile選項(xiàng)
前提條件
源端端目標(biāo)端在不同機(jī)器，不共享/u01/app/oracle/oradata/prod1路徑，各自都有自己的/u01/app/oracle/oradata/prod1目錄
源端的logfile位于路徑/u01/app/oracle/oradata/prod1，目標(biāo)端的pfile或spfile沒有指定任何db_file_name_convert和log_file_name_convert參數(shù)

源端文件/home/oracle/initprod1std.ora(SGA=800M,process=200)
目標(biāo)端pfile文件/home/oracle/initprod1std.ora(SGA=700M,process=190)
目標(biāo)端pfile文件$ORACLE_HOME/dbs/initprod1std.ora(SGA=600M,process=180)
目標(biāo)端spfile文件$ORACLE_HOME/dbs/spfileprod1std.ora(SGA=600M,process=180)


1、rman在源端服務(wù)器上執(zhí)行，目標(biāo)端沒有/home/oracle/initprod1std.ora，目標(biāo)端沒有spfile，目標(biāo)端使用$ORACLE_HOME/dbs/initprod1std.ora
run {
duplicate target database to prod1std from active database
pfile=/home/oracle/initprod1std.ora
LOGFILE
  '/u02/log01.dbf' size 1024M,
  '/u02/log02.dbf' size 1024M,
  '/u02/log03.dbf' size 1024M
NOFILENAMECHECK;
}
目標(biāo)端的結(jié)果
SGA=800M
process=200
db_data_files.file_name和源端一樣
v$logfile.member路徑為/u02
說明使用了源端的文件/home/oracle/initprod1std.ora，并且在目標(biāo)端生成了rman命令中的logfile

2、rman在源端服務(wù)器上執(zhí)行，目標(biāo)端沒有/home/oracle/initprod1std.ora，目標(biāo)端有$ORACLE_HOME/dbs/initprod1std.ora，目標(biāo)端使用spfile啟動$ORACLE_HOME/dbs/spfileprod1std.ora
run {
duplicate target database to prod1std from active database
pfile=/home/oracle/initprod1std.ora
LOGFILE
  '/u02/log01.dbf' size 1024M,
  '/u02/log02.dbf' size 1024M,
  '/u02/log03.dbf' size 1024M
NOFILENAMECHECK;
}
報(bào)錯(cuò)RMAN-05597: Database started with server parameter file and PFILE clause used in command

3、rman在源端服務(wù)器上執(zhí)行，源端服務(wù)器上沒有/home/oracle/initprod1std.ora，目標(biāo)端沒有/home/oracle/initprod1std.ora，目標(biāo)端沒有spfile，目標(biāo)端使用$ORACLE_HOME/dbs/initprod1std.ora
run {
duplicate target database to prod1std from active database
pfile=/home/oracle/initprod1std.ora
LOGFILE
  '/u02/log01.dbf' size 1024M,
  '/u02/log02.dbf' size 1024M,
  '/u02/log03.dbf' size 1024M
NOFILENAMECHECK;
}
報(bào)錯(cuò)RMAN-04017: startup error description: LRM-00109: could not open parameter file '/home/oracle/initprod1std.ora'

4、rman在源端服務(wù)器上執(zhí)行，源端服務(wù)器上沒有/home/oracle/initprod1std.ora，目標(biāo)端有/home/oracle/initprod1std.ora，目標(biāo)端沒有spfile，目標(biāo)端使用$ORACLE_HOME/dbs/initprod1std.ora
run {
duplicate target database to prod1std from active database
pfile=/home/oracle/initprod1std.ora
LOGFILE
  '/u02/log01.dbf' size 1024M,
  '/u02/log02.dbf' size 1024M,
  '/u02/log03.dbf' size 1024M
NOFILENAMECHECK;
}
報(bào)錯(cuò)RMAN-04017: startup error description: LRM-00109: could not open parameter file '/home/oracle/initprod1std.ora'

3、4說明使用的是源端的文件/home/oracle/initprod1std.ora




logfile、*_file_name_convert、nofilenamecheck選項(xiàng)
源端端目標(biāo)端在不同機(jī)器，不共享/u01/app/oracle/oradata/prod1路徑，各自都有自己的/u01/app/oracle/oradata/prod1目錄

1、源端的logfile位于路徑/u01/app/oracle/oradata/prod1，目標(biāo)端的使用spfile啟動，spfile沒有指定任何db_file_name_convert、log_file_name_convert參數(shù)
run {duplicate target database to prod1std from active database;}
報(bào)錯(cuò)
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/example01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/system01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/redo03.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/redo02.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/redo01.log conflicts with a file used by the target database

2、源端的logfile位于路徑/u01/app/oracle/oradata/prod1，目標(biāo)端的使用spfile啟動，spfile沒有指定任何db_file_name_convert、log_file_name_convert參數(shù)
run {duplicate target database to prod1std from active database nofilenamecheck;}
目標(biāo)端的結(jié)果
db_data_files.file_name和源端一樣
v$logfile.member和源端一樣

3、源端的logfile位于路徑/u01/app/oracle/oradata/prod1，目標(biāo)端的使用spfile啟動，spfile沒有指定任何db_file_name_convert、log_file_name_convert參數(shù)
run {duplicate target database to prod1std from active database db_file_name_convert=('/u01/app/oracle/oradata/prod1','/u01/app/oracle/oradata/prod1std');}
報(bào)錯(cuò)
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/redo03.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/redo02.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/prod1/redo01.log conflicts with a file used by the target database

4、源端的logfile位于路徑/u01/app/oracle/oradata/prod1，目標(biāo)端的使用spfile啟動，spfile沒有指定任何db_file_name_convert、log_file_name_convert參數(shù)
run {duplicate target database to prod1std from active database 
db_file_name_convert=('/u01/app/oracle/oradata/prod1','/u01/app/oracle/oradata/prod1std') 
logfile 
'/u01/app/oracle/oradata/prod1std/redo01.log' size 50M,
'/u01/app/oracle/oradata/prod1std/redo02.log' size 50M,
'/u01/app/oracle/oradata/prod1std/redo03.log' size 50M;
}
目標(biāo)端結(jié)果
db_data_files.file_name在/u01/app/oracle/oradata/prod1std目錄下
v$logfile.member在/u01/app/oracle/oradata/prod1std路徑下

5、源端的dbfile,logfile都位于路徑/u01/app/oracle/oradata/prod1，目標(biāo)端的使用spfile啟動，spfile指定
db_file_name_convert='/u01/app/oracle/oradata/prod1/', '/u01/app/oracle/oradata/prod1std/'
log_file_name_convert='/u01/app/oracle/oradata/prod1/', '/u01/app/oracle/oradata/prod1std/'
run {duplicate target database to prod1std from active database;
}
目標(biāo)端結(jié)果
db_data_files.file_name在/u01/app/oracle/oradata/prod1std目錄下
v$logfile.member在/u01/app/oracle/oradata/prod1std路徑下

6、源端的dbfile,logfile都位于路徑/u01/app/oracle/oradata/prod1，目標(biāo)端的使用spfile啟動，spfile指定
db_file_name_convert='/u01/app/oracle/oradata/prod1/', '/u01/app/oracle/oradata/prod1std/'
log_file_name_convert='/u01/app/oracle/oradata/prod1/', '/u01/app/oracle/oradata/prod1std/'
run {duplicate target database to prod1std from active database 
db_file_name_convert=('/u01/app/oracle/oradata/prod1','/u01/app/oracle/oradata/data2') 
logfile 
'/u01/app/oracle/oradata/data2/redo01.log' size 50M,
'/u01/app/oracle/oradata/data2/redo02.log' size 50M,
'/u01/app/oracle/oradata/data2/redo03.log' size 50M;
}
目標(biāo)端結(jié)果
db_data_files.file_name在/u01/app/oracle/oradata/data2目錄下
v$logfile.member在/u01/app/oracle/oradata/data2路徑下




logfile選項(xiàng)時(shí)不加size時(shí)報(bào)錯(cuò)
run {duplicate target database to prod1std from active database
db_file_name_convert=('/u01/app/oracle/oradata/prod1','/u01/app/oracle/oradata/prod1std')
logfile 
'/u01/app/oracle/oradata/prod1std/redo01.log',
'/u01/app/oracle/oradata/prod1std/redo02.log',
'/u01/app/oracle/oradata/prod1std/redo03.log';}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "comma": expecting one of: "size"
RMAN-01007: at line 1 column 208 file: standard input
向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手