This content has been marked as final. Show 9 replies
Have you created standby database by directly copying primary database files??? Did you shutdown your Primary Database during this activity or not??
Actually I had copied all datafiles without issuing "ALter database begin backup"
Better used hot backup for creating standby database or RMAN Backup
HOT BACKUP :-- https://sites.google.com/site/catchdba/physical-standby-database-using-hotbackup
RMAN BACKUP :-- https://blogs.oracle.com/AlejandroVargas/resource/dataguard/how%20to%20create%20a%20physical%20standby%20database%20using%20Rman%20Duplicate%20command.pdf
Fayn_dba wrote:What procedure you used exactly?
I have created physical Standby. I am getting archives when I start the recovery process by issuing
alter database recover managed standby database using current logfile disconnect;
But when I stop this process & alter database open
alter database recover managed standby database cancel
logs reports no error but I get when "alter database open"
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/app/oracle/oradata/orcl/system01.dbf'
this. Actually I had copied all datafiles without issuing "ALter database begin backup"
what is the version you are using?
Why cant use RMAN duplicate?
When you start MRP(recovery) do you see any progress there as it is applying?
Read methods to take backups when database is open and do the same.
Thanks for your valuable replies.
I have copied oradata directory again by issuing "ALTER DATABASE BEGIN BACKUP"
now the point is that I am copying it to standby, when I should issue "alter database end backup"
I mean after copying all files & startup mount
or can I alter database end backup right now ? in production db
Place the primary database in begin backup mode, copy the datafiles to the standby server. Once done, end the backup mode of the primary database.
Hope this helps https://sites.google.com/site/catchdba/physical-standby-database-using-hotbackup
I guess the above link has already been posted and uses the same methodology which you are trying.