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
Yes actually sir this is actually 24/7 environment so downtime is not possible
1 person found this helpful
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.
Down time is not possible So better use RMAN Backup as mentioned by me also it doesn't require Primary Database shutdown.1 person found this helpful
Also backup taken by you is not consistent if you copied primary database files without shutting it down,
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
Hello,1 person found this helpful
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.
Please refer the link the that i posted in previous thread.1 person found this helpful
Thank you very much for your help. I did it through Hot Backup.