OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » step backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

step backup [message #508871]

Tue, 24 May 2011 14:06

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

hi;

i have a problem with this step : after i take a cold backup and a standby controle file and initstandby.ora

what i should to do after with all this files ???

regards

Report message to a moderator

Re: step backup [message #508875 is a reply to message #508871]

Tue, 24 May 2011 14:30

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Continue the steps you have on your checklist.

Regards
Michel

Report message to a moderator

Re: step backup [message #508883 is a reply to message #508875]

Tue, 24 May 2011 15:55

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

ok; but my question is what i need to do with the backup and controle file and initSTANDBY.ora ??

regards
Amin

Report message to a moderator

Re: step backup [message #508890 is a reply to message #508883]

Tue, 24 May 2011 23:45

knight
Messages: 111
Registered: January 2009

Senior Member

please post the complete steps from the document you are following

Report message to a moderator

Re: step backup [message #508895 is a reply to message #508883]

Wed, 25 May 2011 00:56

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

aminelhamzaoui wrote on Tue, 24 May 2011 22:55

ok; but my question is what i need to do with the backup and controle file and initSTANDBY.ora ??

regards
Amin

Why did you make them?

Regards
Michel

Report message to a moderator

Re: step backup [message #508913 is a reply to message #508890]

Wed, 25 May 2011 05:07

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

@knight

this the document www.oracle-class.com/?p=276

regards

Report message to a moderator

Re: step backup [message #508914 is a reply to message #508895]

Wed, 25 May 2011 05:13

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

@michel

i know, all this files (backup,controle file,initSTANDBY.ora ) are for create a standby database.but how ??

i know just initSTANDBY.ora should be in /dbs !!

the other files where should to be ???,for the backup i need a restore ???

regards

Report message to a moderator

Re: step backup [message #508933 is a reply to message #508914]

Wed, 25 May 2011 05:44

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

At the same location than you backup them (but in the other server).
But why do you ask us and the author of the method?

Regards
Michel

[Updated on: Wed, 25 May 2011 05:45]

Report message to a moderator

Re: step backup [message #508953 is a reply to message #508933]

Wed, 25 May 2011 06:44

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

@ michel : for illuminate the steps

in the primary i have :

/u01/app/oracle/backup ==> here i have i cold buckup
/u01/app/oracle/oratada/BDPIRMARY/ ==> here i have datafiles,contrile files , log files

in the stand byi have the same architecture

/u01/app/oracle/backup ==> (what i should have here)???
/u01/app/oracle/oratada/BDSTANDBY/ ==> (what i should have here)???

regards

Report message to a moderator

Re: step backup [message #508961 is a reply to message #508953]

Wed, 25 May 2011 06:58

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

u01/app/oracle/backup ==> (what i should have here)??? the backup
/u01/app/oracle/oratada/BDSTANDBY/ => the files you will restore from the backup

Regards
Michel

Report message to a moderator

Re: step backup [message #508967 is a reply to message #508961]

Wed, 25 May 2011 07:23

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

@michel thanks ;

how can i restore ??

regards

Report message to a moderator

Re: step backup [message #508968 is a reply to message #508967]

Wed, 25 May 2011 07:24

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

how can i restore a cold backup ???

Report message to a moderator

Re: step backup [message #508976 is a reply to message #508968]

Wed, 25 May 2011 07:41

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Using RMAN if you used RMAN to backup.

Regards
Michel

Report message to a moderator

Re: step backup [message #508986 is a reply to message #508976]

Wed, 25 May 2011 08:26

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

i used a cold backup like this one :
/***************************************************************/
set feedback off
set linesize 200
set heading off
set pagesize 0
set trimspool off
set verify off

define rep='/u01/app/oracle/backup'
define script='/u01/app/oracle/sauve.bat'

spool &script

select 'host copy '|| name || ' &rep' from v$datafile order by 1;
select 'host copy '|| member || ' &rep' from v$logfile order by 1;
select 'host copy '|| name || ' &rep' from v$controlfile order by 1;
select 'host copy '|| name || ' &rep' from v$tempfile order by 1;
spool off
shutdown immediate
@&script
startup pfile='dbs/init.ora'
/***************************************************************/

how i can restore it ???

Report message to a moderator