Home » Server Options » Data Guard » step backup
step backup [message #508871] Tue, 24 May 2011 14:06 Go to next message
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
Re: step backup [message #508875 is a reply to message #508871] Tue, 24 May 2011 14:30 Go to previous messageGo to next message
Michel Cadot
Messages: 67297
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Continue the steps you have on your checklist.

Regards
Michel
Re: step backup [message #508883 is a reply to message #508875] Tue, 24 May 2011 15:55 Go to previous messageGo to next message
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
Re: step backup [message #508890 is a reply to message #508883] Tue, 24 May 2011 23:45 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
please post the complete steps from the document you are following
Re: step backup [message #508895 is a reply to message #508883] Wed, 25 May 2011 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67297
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: step backup [message #508913 is a reply to message #508890] Wed, 25 May 2011 05:07 Go to previous messageGo to next message
aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc
Junior Member
@knight

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

regards
Re: step backup [message #508914 is a reply to message #508895] Wed, 25 May 2011 05:13 Go to previous messageGo to next message
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
Re: step backup [message #508933 is a reply to message #508914] Wed, 25 May 2011 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67297
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: step backup [message #508961 is a reply to message #508953] Wed, 25 May 2011 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67297
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: step backup [message #508967 is a reply to message #508961] Wed, 25 May 2011 07:23 Go to previous messageGo to next message
aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc
Junior Member
@michel thanks ;

how can i restore ??

regards
Re: step backup [message #508968 is a reply to message #508967] Wed, 25 May 2011 07:24 Go to previous messageGo to next message
aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc
Junior Member
how can i restore a cold backup ???
Re: step backup [message #508976 is a reply to message #508968] Wed, 25 May 2011 07:41 Go to previous messageGo to next message
Michel Cadot
Messages: 67297
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using RMAN if you used RMAN to backup.

Regards
Michel
Re: step backup [message #508986 is a reply to message #508976] Wed, 25 May 2011 08:26 Go to previous messageGo to next message
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 ???
Re: step backup [message #508991 is a reply to message #508986] Wed, 25 May 2011 09:00 Go to previous messageGo to next message
Michel Cadot
Messages: 67297
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use FTP.

Regards
Michel
Re: step backup [message #508997 is a reply to message #508991] Wed, 25 May 2011 09:10 Go to previous messageGo to next message
aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc
Junior Member
can i use a external hard disc ??

regards
Re: step backup [message #508999 is a reply to message #508997] Wed, 25 May 2011 09:13 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Yes.
Re: step backup [message #509005 is a reply to message #508999] Wed, 25 May 2011 09:29 Go to previous message
aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc
Junior Member
ok ; i will try it

thanks regards
Previous Topic: Check RFS server is working
Next Topic: LOG_ARCHIVE_DEST_2 Error
Goto Forum:
  


Current Time: Thu Aug 13 00:39:32 CDT 2020