-
standby using HOT BACKUP
hi folks,
is it possible to configure standby database, by taking a HOT BACKUP..
regarsds
sonia
-
if you have controlfile created as 'STANDBY CONTROLFILE'
-
You can use any backup to create standby database.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Yes it is possible
1. You can take new backup of ur primary database or you can use ur old backup
2. Create standby controlfile
3. copy above things to new site.
4 Place archvielogs in with destination Init parameters
Things works fine.
viraj
-----------
OCA 9i
A Wise Man Knows How much he doesn't know !!!
-
1) Create stanby database from a valid hot or cold backup
2) create a standby controlfile by running the following command on the primary and then tranfer the new standby controlfile to the standby database server.
ALTER DATABASE CREATE STANBY CONTROLFILE AS 'mystandbycontrolfile.ctl'
3) apply the archive logs against the standby database
alapps
Fast, Cheap, Reliable... Pick Two(2)
-
standby using HOT BACKUP
Whether it is HOT or COLD Backup doesn't matter.
The ARCHs must be in tandem match with the the source database.
VAST
-
hi,
should i create the standby controlfile before taking the hot backup or after taking the hotbackup.
Regards
sonia
-
Originally posted by Sonia
hi,
should i create the standby controlfile before taking the hot backup or after taking the hotbackup.
Regards
sonia
Take the backup first and then run ALTER DATABASE CREATE STANBY CONTROLFILE AS ...
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|