Home » RDBMS Server » Backup & Recovery » How restore and recovery works (suse linux 10 sp2)
How restore and recovery works [message #482349] Thu, 11 November 2010 02:44 Go to next message
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.
Re: How restore and recovery works [message #482354 is a reply to message #482349] Thu, 11 November 2010 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How restore and recovery works [message #482370 is a reply to message #482354] Thu, 11 November 2010 03:38 Go to previous messageGo to next message
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??

Re: How restore and recovery works [message #482392 is a reply to message #482370] Thu, 11 November 2010 04:15 Go to previous messageGo to next message
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
Re: How restore and recovery works [message #482576 is a reply to message #482392] Fri, 12 November 2010 17:15 Go to previous message
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.
Previous Topic: Job_Action details
Next Topic: Can we recover archived logs from new backups
Goto Forum:
  


Current Time: Sat Feb 27 00:27:40 CST 2021