Reply from neworadba on May 18 at 5:35 AM Hi,
First of all, If you are creating a standdby database, then why do you require to open this db??
Why are you using cancel based recovery instead of PIT recovery.
You can do the following:
1. restore controlfile
2. restore database
3. shutdown db
4. copy the control file(s) from PROD to this standby database.
5. Startup the database in mount state.
6. Run "alter system switch logfile" (note the time and the log)
7. Copy all the archive logs until that time noted above to this Standby Site.
8. Run the following command:
SQL> recover database using backup controlfile until time '2012-05-18:02:00:00';
(Apply archive logs at intervals)
9. If required open the database using:
SQL> alter database open resetlogs;
Hope this helps.
Regards,
B Sarkar
| | | ---------------Original Message---------------
From: Dipti_Jadav
Sent: Monday, May 14, 2012 9:08 AM
Subject: Problem Regarding Standby Database Implementation On Oracle 11gR2 Standard Edition
Thank you for reply
B Sarkar
Yes, I am trying to create standby database on Standard edition.
But standby database created using simple steps :
restore controlfile from '...'
restore database
recover database
alter database open resetlogs;
there is no standby controlfile.
but i am not duplicating database using keyword duplicate database.
another thing both database having same sid name
other thing is :
if i use to apply new archive on standby database using following command:
recover database using backup controlfile until cancel;
It give me error:
ORA-01547,ORA-01152,
ORA-01110 :data file 1: 'D:\ORACLE\ORADATA\SURAV2\SYSTEM01.DBF'
than i run command:
alter database recover cancel
alter database open resetlogs;
so, it opened but no archive applied no new changes arrived .
can explain me why this happen?
thank you for response.. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment