OraFAQ Forum: Backup & Recovery » Restore & Recover Oracle Database with zero lose data

Home » RDBMS Server » Backup & Recovery » Restore & Recover Oracle Database with zero lose data (oracle 11g RAC , solaris11(x64))

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

Restore & Recover Oracle Database with zero lose data [message #628616]

Wed, 26 November 2014 07:58

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Dear All,

We have configured oracle 11g R2 RAC with 2 nodes on solaris 11 .Every day we take snapshot of LUN where all data are stored and we mount diskgroup and startup database in another server , after that we took backup(expdp) also take full rman backup with archivelog. Then We restore database from rman backup in another server(without RAC) .But we could not recover database until last archivelog.

Please guide
Asraf

[Updated on: Wed, 26 November 2014 07:58]

Report message to a moderator

Re: Restore & Recover Oracle Database with zero lose data [message #628619 is a reply to message #628616]

Wed, 26 November 2014 08:07

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

Senior Member
Account Moderator

I can but maybe I do it properly and you no but as you didn't show us what you actually did then we can't help.

Report message to a moderator

Re: Restore & Recover Oracle Database with zero lose data [message #628626 is a reply to message #628619]

Wed, 26 November 2014 08:24

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Yes I will share what I did ,

Snapshot :

1. Take rman backup
when I took rman backup sequence 2001 for thread 1 and 1500 for thread 2.
2. Transfer backup pieces in another server
3. Copy archivelog from Live DB (RAC) to New server

New Server :

ASM started
database status down

1. nomount dataabse
2. restore controlfile from backup
3. mount database
4. restore database
[ all datafiles are successfully restored]

5. register archivelog [ thread 1 sequence from 2001 to 2100 and thread 2 sequence from 1501 to 1596]
[these archivelog has not backup by rman, It is generated after took rman backup]
6. recover database
after that rman could not recover database last sequence .

Report message to a moderator

Re: Restore & Recover Oracle Database with zero lose data [message #628628 is a reply to message #628626]

Wed, 26 November 2014 08:27

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

Senior Member
Account Moderator

We want the execution listing, all the commands and logs, for the last operation (restore/recover).

Report message to a moderator

Re: Restore & Recover Oracle Database with zero lose data [message #628633 is a reply to message #628628]

Wed, 26 November 2014 08:42

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

can you remarks : restore and recover process is right way or not

I will configure again next week.

Report message to a moderator

Re: Restore & Recover Oracle Database with zero lose data [message #628638 is a reply to message #628633]

Wed, 26 November 2014 09:21

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Essentially your restore/recover process is correct. However, I don't understand this:
Quote:

after that rman could not recover database last sequence

RMAN "talks" in error codes - RMAN-XXXXX. What error codes did it report? Please copy and paste them.

Report message to a moderator

Re: Restore & Recover Oracle Database with zero lose data [message #628673 is a reply to message #628638]

Wed, 26 November 2014 23:17

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18 , 19 , 20
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18 , 19 , 20
alter database recover datafile list
21 , 22 , 23 , 24 , 25 , 26 , 27 , 28 , 29 , 30 , 31 , 32 , 33 , 34 , 35 , 36 , 37 , 38 , 39 , 40
Completed: alter database recover datafile list
21 , 22 , 23 , 24 , 25 , 26 , 27 , 28 , 29 , 30 , 31 , 32 , 33 , 34 , 35 , 36 , 37 , 38 , 39 , 40
alter database recover datafile list
41 , 42 , 43 , 44 , 45 , 46 , 47 , 48 , 49 , 50 , 51 , 52 , 53 , 54 , 55 , 56
Completed: alter database recover datafile list
41 , 42 , 43 , 44 , 45 , 46 , 47 , 48 , 49 , 50 , 51 , 52 , 53 , 54 , 55 , 56
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 64 slaves
ORA-279 signalled during: alter database recover if needed
start until cancel using backup controlfile
...
alter database recover logfile '/TEST_RMAN/rman/rmanbackup/arch/2014_11_19/thread_1_seq_3929.277.863786563'
Media Recovery Log /TEST_RMAN/rman/rmanbackup/arch/2014_11_19/thread_1_seq_3929.277.863786563
Wed Nov 19 07:30:32 2014
Errors with log /TEST_RMAN/rman/rmanbackup/arch/2014_11_19/thread_1_seq_3929.277.863786563
Errors in file /u01/app/oracle/diag/rdbms/dbcl/dbcl/trace/dbcl_pr00_5091.trc:
ORA-00326: log begins at change 14725613613, need earlier change 14722614416
ORA-00334: archived log: '/TEST_RMAN/rman/rmanbackup/arch/2014_11_19/thread_1_seq_3929.277.863786563'
ORA-326 signalled during: alter database recover logfile '/TEST_RMAN/rman/rmanbackup/arch/2014_11_19/thread_1_seq_3929.277.863786563'...
alter database recover cancel
Media Recovery Canceled
Completed: alter database recover cancel
Wed Nov 19 09:08:51 2014
alter database recover datafile list clear

Report message to a moderator

Re: Restore & Recover Oracle Database with zero lose data [message #628681 is a reply to message #628673]

Thu, 27 November 2014 00:35

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

Senior Member
Account Moderator

Quote:

ORA-279 signalled during: alter database recover

Code: [Select all] [Show/ hide]

ORA-00279: change %s generated at %s needed for thread %s
 *Cause: The requested log is required to proceed with recovery.
 *Action:  Please supply the requested log with "ALTER DATABASE RECOVER
           LOGFILE <file_name>" or cancel recovery with "ALTER DATABASE
           RECOVER CANCEL".

Report message to a moderator

Previous Topic:	Block corruption found during rman
Next Topic:	RMAN Restore of Backups as Part of a Database Upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 10:13:10 CDT 2025