来个基本的吧，这样帮助我们了解真正复制的过程
用户管理复制database
把rman建立的2个库删除吧环境有限

步骤1 建立复制库instance
C:\>oradim -new -sid xhtest4 -intpwd xh123
例程已创建。

C:\>mkdir d:\xhtest4

C:\>mkdir d:\xhtest4\bdump

C:\>mkdir d:\xhtest4\cdump

C:\>mkdir d:\xhtest4\archive

C:\>mkdir d:\xhtest4\udump

建立参数文件
*.background_dump_dest='d:\xhtest4\bdump'
*.compatible='10.1.0.2.0'
*.control_files='d:\xhtest4\control01.ctl'
*.core_dump_dest='d:\xhtest4\cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='xhtest4'
*.db_recovery_file_dest_size=2147483648
*.db_recovery_file_dest='d:\xhtest4'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=xhtestXDB)'
*.java_pool_size=50331648
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_dest_1='location=D:\xhtest4\archive'
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=200000000
*.sort_area_size=65536
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='d:\xhtest4\udump'
*.instance_name='xhtest4'
*.service_names='xhtest4' 纯手动要db_file_name_conver ,log_file_name_conver也没用，不写了

做好准备

SQL> create spfile='d:\rman复制参数\spfilexhtest4.ora' from pfile='d:\rman复制参
数\initxhtest4.ora'
2 ;

SQL> alter database backup controlfile to trace;

数据库已更改。

SQL> alter database begin backup;

数据库已更改。

SQL> @D:\oracle实验脚本\os备份数据文件.txt
已复制 1 个文件。

已复制 1 个文件。

SQL> alter database end backup;

数据库已更改。

SQL>

将备份复制到 xhtest4库的文件目录

C:\>set oracle_sid=xhtest4

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 7月 21 10:37:41 2008 开始工作喽

已连接到空闲例程。
SQL> startup nomount;
ORACLE 例程已经启动。

Total System Global Area 289406976 bytes
Fixed Size                   788552 bytes
Variable Size             263190456 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes

CREATE CONTROLFILE set DATABASE "XHTEST4" RESETLOGS ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 454
LOGFILE
GROUP 1 'd:\xhtest4\REDO01.LOG' SIZE 10M,
GROUP 2 'd:\xhtest4\REDO02.LOG' SIZE 10M,
GROUP 3 'd:\xhtest4\REDO03.LOG' SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'd:\xhtest4\SYSTEM01.DBF',
'd:\xhtest4\UNDOTBS01.DBF',
'd:\xhtest4\SYSAUX01.DBF',                                       控制文件的内容
'd:\xhtest4\USERS01.DBF',
'd:\xhtest4\EXAMPLE01.DBF',
'd:\xhtest4\TESTTB.DBF'
CHARACTER SET ZHS16GBK
;

SQL> @D:\oracle实验脚本\duplicate控制文件脚本.txt

控制文件已创建

SQL>

恢复下

SQL> set logsource 'F:\归档备份' 设置下自动应用归档日志的位置 .....................重点啊
SQL> recover database until cancel using backup controlfile;
ORA-00279: ?? 671627 (? 07/21/2008 10:14:56 ??) ???? 1 ????
ORA-00289: ??:
F:\F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\1

0.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1ARC00063_0660131038.001
ORA-00280: ?? 671627 (???? 1) ??? #63 ?

指定日志: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: ????????
'F:\F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\

10.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1ARC00063_0660131038.001'
ORA-27041: ??????
OSD-04002: ????????????
O/S-Error: (OS 123) ????????????????????????????????

ORA-00308: ????????
'F:\F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\

10.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1ARC00063_0660131038.001'
ORA-27041: ??????
OSD-04002: ????????????
O/S-Error: (OS 123) ????????????????????????????????

ORA-01547: ??: RECOVER ??? OPEN RESETLOGS ???????
ORA-01195: ?? 1 ??????????????????
ORA-01110: ???? 1: 'D:\XHTEST4\SYSTEM01.DBF'

SQL> recover database until cancel using backup controlfile;
ORA-00279: ?? 671627 (? 07/21/2008 10:14:56 ??) ???? 1 ????
ORA-00289: ??:
F:\F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\1

0.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1ARC00063_0660131038.001
ORA-00280: ?? 671627 (???? 1) ??? #63 ?

指定日志: {=suggested | filename | AUTO | CANCEL}
F:\oracle\product\10.1.0\oradata\xhtest\redo01.log
ORA-00310: ???????? 62; ???? 63
ORA-00334: ????: 'F:\ORACLE\PRODUCT\10.1.0\ORADATA\XHTEST\REDO01.LOG'

ORA-01547: ??: RECOVER ??? OPEN RESETLOGS ???????
ORA-01195: ?? 1 ??????????????????
ORA-01110: ???? 1: 'D:\XHTEST4\SYSTEM01.DBF' 出错不在归档日志里

SQL> recover database until cancel using backup controlfile;
ORA-00279: ?? 671627 (? 07/21/2008 10:14:56 ??) ???? 1 ????
ORA-00289: ??:
F:\F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\1

0.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1ARC00063_0660131038.001
ORA-00280: ?? 671627 (???? 1) ??? #63 ?

指定日志: {=suggested | filename | AUTO | CANCEL}
F:\oracle\product\10.1.0\oradata\xhtest\redo02.log
ORA-00279: ?? 672738 (? 07/21/2008 10:41:01 ??) ???? 1 ????
ORA-00289: ??:
F:\F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1F:\ORACLE\PRODUCT\1

0.1.0\DB_1F:\ORACLE\PRODUCT\10.1.0\DB_1ARC00064_0660131038.001
ORA-00280: ?? 672738 (???? 1) ??? #64 ?
ORA-00278: ??????????? 'F:\oracle\product\10.1.0\oradata\xhtest\redo02.log'

指定日志: {=suggested | filename | AUTO | CANCEL}
F:\oracle\product\10.1.0\oradata\xhtest\redo03.log 在redo03.log里还未归档应用完后 OK
已应用的日志。
完成介质恢复。
SQL> alter database open restlogs;
alter database open restlogs
*
第 1 行出现错误:
ORA-02288: ??? OPEN ??

SQL> alter database open resetlogs;

ITPub博客

oracle实验记录手工 duplicate database(1)

最新文章

ITPub博客

oracle实验记录 手工 duplicate database(1)

最新文章

oracle实验记录手工 duplicate database(1)