Topic: Database Administration >> Physical Standby setup with RMAN??
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Physical Standby setup with RMAN?? |
| shantanu |
Posted: Jan 30, 2008 02:14:59 AM |
Total Post: 42
Joined: May, 2007
|
Hello all
Can someone provide steps for setting up physical standby using RMAN??
Appreciate your help! |
|
|
 Vinod |
| Posted: Jan 30, 2008 06:30:05 AM |  |
|
Total Post: 54
Joined: Oct, 2007
|
Hi
I have listed few basic mandatory steps for creation of standby database with RMAN below ,
Step A: Backup the database that includes backup of datafiles, archivelogs and controlfile for standby
Step B: Move the backups to the standby server
RMAN> run
2> {
3> allocate channel a type disk;
4> allocate channel b type disk;
5> allocate channel c type disk;
6> backup database plus archivelog;
7> }
using target database control file instead of recovery catalog
allocated channel: a
channel a: sid=142 devtype=DISK
allocated channel: b
channel b: sid=139 devtype=DISK
allocated channel: c
channel c: sid=159 devtype=DISK
Starting backup at 30-JAN-08
channel a: starting full datafile backupset
RMAN> run
2> {
3> allocate channel b type disk;
4> backup current controlfile for standby;
5> }
RMAN> restore standby controlfile from '/u04/oradata/flash_recovery_area/STNDBY_ORCL/backupset/2008_01_30/o1_mf_ncnnf_TAG20080130T173413_3t0no5wf_.bkp';
Starting restore at 30-JAN-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
Step C: Make proper changes in the parameter files of both primary and standby database
Step D: Do the restore and recover on standby database
Step E: Put the standby database in managed recovery mode .
Vinod
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 704 |
| Jayanta Sur | 479 |
| positive fanatic | 416 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 231 |
| Ramesh Jois | 226 |
| Bishal Khetan | 196 |
|
|
