Skip navigation.

knight's blog

Standby database using RMAN duplicate

Steps to create standby database using RMAN:

primary database name:taurus
host name:sony
db_unique_name=production

standby database name:taurus
hostname:sonydr
db_unique_name=standby

Oracle 10.2.0.1.0
RHEL 4
-force logging is enabled on the primary database.
-password file is created for primary database
-primary database is in archivelog mode

[code]
SQL> select name,open_mode,log_mode
2 from v$database;

NAME OPEN_MODE LOG_MODE
--------- ---------- ------------
TAURUS READ WRITE ARCHIVELOG

SQL>

SQL> select instance_name,

RMAN checksyntax

RMAN is recommended for backups/restore of oracle databases.It is a very powerful tool and has variety of useful features.There is 'checksyntax' feature in RMAN which allows one to check RMAN scripts syntactically without executing it.This feature is available from 10G release 2.It proves to be useful for checking scriptsfor live databases where one doesnt have leisure to execute scripts any time and any times!!

bash-3.00$ vi rman_bkp.rman

RUN {
ALLOCATE CHANNEL c1 TYPE DISK FORMAT '/data/backup/Hotbkp_Full_%D_%d_%s_%p'; BACKUP database; RELEASE CHANNEL c1;
allocate channel c2 type dis