-
Originally posted by yls177
so i changed to the below
1) create standby controlfile
2) being bacup mode for tablespaces
3)rcp
4) end backup mode for tablespaces
5) startup
6) result: beautiful
comments?
Ok if you say so but that does not make any sense
http://download-west.oracle.com/docs...e_ps.htm#63563
which says...
"The control file must also be created after the last time stamp for the backup datafiles."
I'm stmontgo and I approve of this message
-
Originally posted by yls177
really?
actually, the cause of the errros above is because i do the below
1) being backup mode for tablespaces
2) rcp
3) end backup mode
4) create standby controlfile
5) startup
6) got these errors
so i changed to the below
1) create standby controlfile
2) being bacup mode for tablespaces
3)rcp
4) end backup mode for tablespaces
5) startup
6) result: beautiful
comments?
startup?? whic database you are starting up??? and which result are you talking abt???? starting the databse???
-nagarjuna
-
i meant startup nomount for the standby database. in my previous postings, i did the first one whereby i got errors... so i did the second one and its all fine.
-
-
Originally posted by yls177
any verdicts?
yeah, you have no clue
I'm stmontgo and I approve of this message
-
Hi,
I think the Oracle manual is confusing.
To get the standby controlfile to work properly, you have to recover _past_ the last SCN recorded in it. So, back to your case:
First time
Hot backup files
Create standby controlfile
=> error
Second time
Create standby controlfile
Hot backup files
=> OK
Second time around, changes will have been made on the system while the hot backup was going on, so you ended up recovering past the point when you created your standby controlfile.
Top tip:
Create standby controlfile
alter system archive log current;
Works every time.
Cheers,
Annabel
-
Right, the link indicates when to create the control file.
got what i am trying to do.
Cheers
-
Originally posted by yls177
got what i am trying to do.
Might be, but this thread still clearly indicates that you don't understand how standby database (or recovery in general) works...
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
What jmodic says rings true -> looks like the poser has no clue as to waht a standby is -> hope a recovery on this db is not reqd. in the near future !!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|