hi folks,
is it possible to configure standby database, by taking a HOT BACKUP..
regarsds
sonia
Printable View
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.
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
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
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
Take the backup first and then run ALTER DATABASE CREATE STANBY CONTROLFILE AS ...Quote:
Originally posted by Sonia
hi,
should i create the standby controlfile before taking the hot backup or after taking the hotbackup.
Regards
sonia