OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RESTORE RMAN (HP-UX puma B.11.11)

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

RESTORE RMAN [message #504112]

Thu, 21 April 2011 10:27

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

Hello all,

i have a datagaurd configuration ( host a et host b ) oracle 10gr2
now: i lost some archive log in host A ( seq 10 til seq 20 )

i cant restore my archivelog by rman:

RMAN> RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=HOSTA,NB_ORA_POLICY=oracle_HOT_HOSTA,NB_ORA_SERV=aigle,NB_ORA_SCHED=oracle_critique_HOSTA';
RESTORE ARCHIVELOG FROM SEQUENCE 10 UNTIL SEQUENCE 20;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}

MY QUESTION IS:

the script does not give me any log since many hours , still
starting restore at 21 APR 2011
PLEASE HELP ME

BEST REGARDS

Report message to a moderator

Re: RESTORE RMAN [message #504121 is a reply to message #504112]

Thu, 21 April 2011 10:38

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

RMAN is most likely waiting for your MML to reply it.
Waiting for a tape?

Regards
Michel

Report message to a moderator

Re: RESTORE RMAN [message #504125 is a reply to message #504121]

Thu, 21 April 2011 10:49

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

Hello Michel
but i have 1hour waiting for it and stil working with no response
Best regards

Report message to a moderator

Re: RESTORE RMAN [message #504135 is a reply to message #504125]

Thu, 21 April 2011 11:38

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, and you will wait still someone gives you the tape.

Regards
Michel

[Updated on: Thu, 21 April 2011 11:38]

Report message to a moderator

Re: RESTORE RMAN [message #504362 is a reply to message #504135]

Sun, 24 April 2011 04:01

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

sorry but , i resolv this problem, i must not connect to our cat , it was full
Best regards

Report message to a moderator

Re: RESTORE RMAN [message #504367 is a reply to message #504362]

Sun, 24 April 2011 04:43

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks for the feedback.

Which "cat" are you talking about? RMAN cat or your tape provider one?

Regards
Michel

Report message to a moderator

Re: RESTORE RMAN [message #504370 is a reply to message #504367]

Sun, 24 April 2011 04:54

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

RMAN CAT, you have to do a clean up of your RMAN cat
regards

Report message to a moderator

Re: RESTORE RMAN [message #504378 is a reply to message #504370]

Sun, 24 April 2011 06:04

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks and regards
Michel

Report message to a moderator

Previous Topic:	how to recover truncated table
Next Topic:	Backup from Application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 07:27:49 CDT 2024