1. over view
Primary DB:
ORACLE_SID=demo
Standby DB:
ORACLE_SID=test
2. make sure your primary DB in archivelog mode
sqlplus "/ as sysdba"
alter system set log_archive_dest_1='location=Z:\ora92\admin\demo\arch' scope=both;
alter system set log_archive_dest_2='SERVICE=test OPTIONAL REOPEN=180' scope=both;
log_archive_start=true
log_archive_format='demo%T.%S'
3. get standby DB init parameters
set ORACLE_SID=demo
cd $ORACLE_HOME/database
sqlplus "/ as sysdba"
create pfile from spfile
copy initdemo.ora inittest.ora
notepad inittest.ora
*.control_files='C:\oradata\test\control01.ctl'
*.DB_FILE_NAME_CONVERT =('Z:\ORA92\ORADATA\DEMO\','C:\ORADATA\TEST\')
*.log_file_name_convert =('Z:\ORA92\ORADATA\DEMO\','C:\ORADATA\TEST\')
*.instance_name='test'
*.lock_name_space='test'
*.service_names='test'
*.STANDBY_ARCHIVE_DEST='location=C:\oradata\test\arch'
notes for NT:
make sure all path/filenames are upper casse
4. backup primary DB online
rman nocatalog target /
run {
allocate channel CC type disk
FORMAT 'c:\oradata\demo_%s.%p';
set limit channel CC kbytes 2097150;
backup database
include current controlfile for standby;
sql "alter system archive log current";
}
5. create NT service or passwd file
a. NT:
oradim -new -sid test -intpwd oracle
b. UNIX
orapwd file=pwdtest.oraorapwdtest password=oracle
6. startup standby DB
set ORACLE_SID=test
rman nocatalog target /
startup nomount;
exit
7. create standby db
rman nocatalog
connect target /@demo
connect auxiliary /
duplicate target database for standby dorecover;
8. check standby db
sqlplus "/ as sysdba"
alter database open read only;
select * from all_users;
deleter * from scott.emp;
9. from read only to recovery
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
10. from recover to read only
recover managed standby database cancel;
alter database open read only;
Just wanna get more and more professional with oracle
Just wanna a job relateed with oracle