sachinpawan wrote:from primary
now i restarted test again,
now i am taking rman backup in stanvby DB,
my probelm is, how can i take backup of standby controlfile in rman for my future restore?
"RMAN> backup current controlfile for standby;" Starting backup at 10-APR-12 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=194 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including standby control file in backup set channel ORA_DISK_1: starting piece 1 at 10-APR-12 channel ORA_DISK_1: finished piece 1 at 10-APR-12 piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_04_10\O1_MF_NCNNF_TAG20120410T164736_7R85PN6Q_.BKP tag=TAG20120410T164736 comme channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 10-APR-12 RMAN>
if we use current controlfile...we can recover database....but the database may not be standby ?