copyright (c) 1995, 2002, oracle corporation. all rights reserved.
rman> connect catalog rman/[email protected]
连接到恢复目录数据库
rman> connect target /
连接到目标数据库: encore (dbid=3146513770) rman> run 2> {allocate channel d1 type disk maxpiecesize = 500m; 3> backup full database 4> format 'e:/rmanbak/db_%d_%s_%p_%t'; 5> release channel d1; 6> }
rman> run 2> {allocate auxiliary channel d1 type disk; 3> set newname for datafile 1 to 'f:/clone/data ystem01.dbf';
脚本克隆数据库时，出现 no backup copy 之类的错误， 之后补充备份目标数据库的日志，
rman> run 2> {allocate channel d1 type disk maxpiecesize = 500m; 3> backup archivelog all 4> format 'e:/rmanbak/log_%d_%s_%p_%t'; 5> release channel d1; 6> }
rman> run 2> {allocate auxiliary channel d1 type disk; 3> set newname for datafile 1 to 'f:/clone/data ystem01.dbf'; 4> set newname for datafile 2 to 'f:/clone/data/undotbs01.dbf'; 5> set newname for datafile 3 to 'f:/clone/data/cwmlite01.dbf'; 6> set newname for datafile 4 to 'f:/clone/data/drsys01.dbf'; 7> set newname for datafile 5 to 'f:/clone/data/example01.dbf'; 8> set newname for datafile 6 to 'f:/clone/data/indx01.dbf'; 9> set newname for datafile 7 to 'f:/clone/data/odm01.dbf'; 10> set newname for datafile 8 to 'f:/clone/data/tools01.dbf'; 11> set newname for datafile 9 to 'f:/clone/data/users01.dbf'; 12> set newname for datafile 10 to 'f:/clone/data/xdb01.dbf'; 13> duplicate target database to clone_db 14> logfile 15> group 1 ('f:/clone/data/redo01.dbf') size 10m, 16> group 2 ('f:/clone/data/redo02.dbf') size 10m, 17> group 3 ('f:/clone/data/redo03.dbf') size 10m; 18> }
分配的通道: d1 通道 d1: sid=8 devtype=disk
正在执行命令: set newname
正在执行命令: set newname
正在执行命令: set newname
正在执行命令: set newname
正在执行命令: set newname
正在执行命令: set newname
正在执行命令: set newname
正在执行命令: set newname
正在执行命令: set newname
正在执行命令: set newname
启动 duplicate db 于 2004-06-28 21:43:51
正在打印存储的脚本: memory script { set until scn 261688166; set newname for datafile 1 to "f:/clone/data ystem01.dbf"; set newname for datafile 2 to "f:/clone/data/undotbs01.dbf"; set newname for datafile 3 to "f:/clone/data/cwmlite01.dbf"; set newname for datafile 4 to "f:/clone/data/drsys01.dbf"; set newname for datafile 5 to "f:/clone/data/example01.dbf"; set newname for datafile 6 to "f:/clone/data/indx01.dbf"; set newname for datafile 7 to "f:/clone/data/odm01.dbf"; set newname for datafile 8 to "f:/clone/data/tools01.dbf"; set newname for datafile 9 to "f:/clone/data/users01.dbf"; set newname for datafile 10 to "f:/clone/data/xdb01.dbf"; restore check readonly clone database ; } 正在执行脚本: memory script
sql*plus: release 9.2.0.5.0 - production on mon jun 28 22:01:46 2004
copyright (c) 1982, 2002, oracle corporation. all rights reserved.
enter user-name: sys/[email protected] as sysdba
connected to: oracle9i enterprise edition release 9.2.0.5.0 - production with the partitioning, oracle label security, olap and oracle data mining options jserver release 9.2.0.5.0 - production
dbca是一款可以配置、管理和建立数据库的工具。在初始数据库安装过程中，如果你选择“建立一个数据库选项(create a database option)”，这一工具就会启动并运行。你可以建立一个基于模板的数据库，也可以从先前的范例中导入一个新的模板。 很多管理人员并不知道，只要在命令行中键入dbca这可以进入到dbca环境。一旦这一工具启动，你可以建立一个新的数据库，配置数据库的init.ora选项，删除一个现有的数据库，或者管理数据库模板。这些数据库模板与安装时生成的模板类似(比如general purpose， data warehouse，以及transaction processing)。
