Home » RDBMS Server » Backup & Recovery » Restore & Recover Oracle Database with zero lose data (oracle 11g RAC , solaris11(x64))
Restore & Recover Oracle Database with zero lose data [message #628616] Wed, 26 November 2014 07:58 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Restore & Recover Oracle Database with zero lose data [message #628626 is a reply to message #628619] Wed, 26 November 2014 08:24 Go to previous messageGo to next message
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 .





Re: Restore & Recover Oracle Database with zero lose data [message #628628 is a reply to message #628626] Wed, 26 November 2014 08:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Restore & Recover Oracle Database with zero lose data [message #628633 is a reply to message #628628] Wed, 26 November 2014 08:42 Go to previous messageGo to next message
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.


Re: Restore & Recover Oracle Database with zero lose data [message #628638 is a reply to message #628633] Wed, 26 November 2014 09:21 Go to previous messageGo to next message
gazzag
Messages: 1118
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.
Re: Restore & Recover Oracle Database with zero lose data [message #628673 is a reply to message #628638] Wed, 26 November 2014 23:17 Go to previous messageGo to next message
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
Re: Restore & Recover Oracle Database with zero lose data [message #628681 is a reply to message #628673] Thu, 27 November 2014 00:35 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
ORA-279 signalled during: alter database recover


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".

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


Current Time: Thu Mar 28 11:44:13 CDT 2024