OraFAQ Forum: Backup & Recovery » How restore and recovery works

Home » RDBMS Server » Backup & Recovery » How restore and recovery works (suse linux 10 sp2)

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

How restore and recovery works [message #482349]

Thu, 11 November 2010 02:44

SystemEng
Messages: 12
Registered: November 2010

Junior Member

Hello

I was able to restore a live database to another database. But i have no idea how it got restored.

i had copied all the incremental backups on to the new database flash recovery folder.

The issue is that i didnt know which files to copy so i copied all the backups found on the live database. And i found that it was restoring from backups dated 09/11/2010.. why not from the latest INcremental 0 followed by its Incremental 1..

Does it depend on the controlfile and spfile i restored.

Can anyone please help me on that.

Report message to a moderator

Re: How restore and recovery works [message #482354 is a reply to message #482349]

Thu, 11 November 2010 02:54

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

Senior Member
Account Moderator

Database Backup and Recovery Basics
Database Backup and Recovery Reference
Database Backup and Recovery Advanced User's Guide

There is an example on how to restore in another server.

Regards
Michel

Report message to a moderator

Re: How restore and recovery works [message #482370 is a reply to message #482354]

Thu, 11 November 2010 03:38

SystemEng
Messages: 12
Registered: November 2010

Junior Member

After i restored my database,

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/APPPLU/ORAARCH2
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1

How can restore my archivelogs

RMAN> LIST COPY OF DATABASE ARCHIVELOG ALL;

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1396 1 1030 A 10-NOV-10 /oradata/APPPLU/ORAARCH2/1_1030_730481489.dbf
1398 1 1031 A 10-NOV-10 /oradata/APPPLU/ORAARCH2/1_1031_730481489.dbf
1400 1 1032 A 10-NOV-10 /oradata/APPPLU/ORAARCH2/1_1032_730481489.dbf
1402 1 1033 A 10-NOV-10 /oradata/APPPLU/ORAARCH2/1_1033_730481489.dbf
1404 1 1034 A 10-NOV-10 /oradata/APPPLU/ORAARCH2/1_1034_730481489.dbf
1406 1 1035 A 10-NOV-10 /oradata/APPPLU/ORAARCH2/1_1035_730481489.dbf
1409 1 1036 A 10-NOV-10 /oradata/APPPLU/ORAARCH2/1_1036_730481489.dbf
1407 1 1036 A 10-NOV-10 /oradata/APPPLU/ORAARCH1/1_1036_730481489.dbf

If i understand , my current log should be 1036 when i do archive list log??

Report message to a moderator

Re: How restore and recovery works [message #482392 is a reply to message #482370]

Thu, 11 November 2010 04:15

SystemEng
Messages: 12
Registered: November 2010

Junior Member

When i did

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
1036

But i need now to apply all the archived logs found in the Archived destination.

Should the database be using a standby control file...

......Help

Report message to a moderator

Re: How restore and recovery works [message #482576 is a reply to message #482392]

Fri, 12 November 2010 17:15

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You should follow the detailed process Restore and Recovery of the Database on a New Host explained in the links that Michel posted above.

Standby control files are for standby databases.

Report message to a moderator

Previous Topic:	Job_Action details
Next Topic:	Can we recover archived logs from new backups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:26:45 CST 2024