Duplicating a Database

简介: Duplicating a Database

数据库恢复技术:
image.png

Backup-Based Duplication With a Target Connection
image.png

1,参数配置文件,启动数据到nomount

DB_NAME=somevalue
SQL> STARTUP NOMOUNT

2,连接数据库

RMAN> CONNECT TARGET SYS/sysdba@prod; # source database
connected to target database: PROD (DBID=39525561)

RMAN> CONNECT AUXILIARY SYS/sysdba@dupdb; # duplicate database instance
connected to auxiliary database: DUPDB (not mounted)

3,数据库复制

DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPFILE
NOFILENAMECHECK;

// The PASSWORD FILE option specifies that RMAN should copy the password file to the destination host
// RMAN opens the database with the RESETLOGS option to create the online redo log

DUPLICATE DATABASE prod TO dupdb
DBID 8675309 # DBID of source database
UNTIL TIME "TO_DATE('11/01/2007', 'MM/DD/YYYY')"
SPFILE
NOFILENAMECHECK;

//The FROM ACTIVE DATABASE clause is not specified. By not specifying this clause, you instruct RMAN to perform backup-based duplication

目录
打赏
0
0
0
0
104
分享
相关文章
Duplicating an Active Database
Duplicating an Active Database duplicate体系结构 搞点英语出来吧,英语不好的哥们就好好翻译翻译吧,这段英语是必须看懂的。
912 0
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database (
127 2
19c 开启Oracle Database Vault
19c 开启Oracle Database Vault
188 1
Connect to Autonomous Database Using Oracle Database Tools
Connect to Autonomous Database Using Oracle Database Tools
85 1
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
76 0
|
10月前
|
Oracle Database Vault Access Control Components
Oracle Database Vault Access Control Components
69 0
What Is Oracle Database Vault?
The Oracle Database Vault security controls protect application data from unauthorized access, and helps you to comply with privacy and regulatory requirements. You can deploy controls to block privileged account access to application data and control sensitive operations inside the database using
56 0
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等