OraFAQ Forum: Backup & Recovery » Restore backup to Fresh Database

Home » RDBMS Server » Backup & Recovery » Restore backup to Fresh Database (Oracle DB 10.2.0.4.0, Red Hat 4.6 64bit)

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

Restore backup to Fresh Database [message #454821]

Fri, 07 May 2010 11:40

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Hi,

I finish configure my new database. So i want to restore backup form other server to this new database.

Usually i backup using RMAN. This command that i use to backup:

backup database plus acrhivelog delete all input;

From this backup, i want to restore. This is my list control file:

-rw-r-----  1 oracle dba 19365888 Apr 21 22:16 cfc-1346230845-20100419-00
-rw-r-----  1 oracle dba 19365888 Apr 30 01:13 cfc-1346230845-20100430-00
-rw-r-----  1 oracle dba 19365888 Apr 30 03:43 cfc-1346230845-20100430-01
-rw-r-----  1 oracle dba 19365888 Apr 30 03:43 cfc-1346230845-20100430-02
-rw-r-----  1 oracle dba 19365888 May  1 01:15 cfc-1346230845-20100501-00
-rw-r-----  1 oracle dba 19365888 May  1 03:47 cfc-1346230845-20100501-01
-rw-r-----  1 oracle dba 19365888 May  1 03:47 cfc-1346230845-20100501-02
-rw-r-----  1 oracle dba 19365888 May  3 01:26 cfc-1346230845-20100503-00
-rw-r-----  1 oracle dba 19365888 May  3 03:58 cfc-1346230845-20100503-01
-rw-r-----  1 oracle dba 19365888 May  3 03:58 cfc-1346230845-20100503-02
-rw-r-----  1 oracle dba 19365888 May  3 22:21 cfc-1346230845-20100503-03
-rw-r-----  1 oracle dba 19365888 May  4 00:59 cfc-1346230845-20100504-00
-rw-r-----  1 oracle dba 19365888 May  4 03:31 cfc-1346230845-20100504-01
-rw-r-----  1 oracle dba 19365888 May  4 03:31 cfc-1346230845-20100504-02
-rw-r-----  1 oracle dba 19365888 May  5 01:00 cfc-1346230845-20100505-00
-rw-r-----  1 oracle dba 19365888 May  5 01:21 cfc-1346230845-20100505-01
-rw-r-----  1 oracle dba 19365888 May  5 03:36 cfc-1346230845-20100505-02
-rw-r-----  1 oracle dba 19365888 May  5 03:37 cfc-1346230845-20100505-03
-rw-r-----  1 oracle dba 19365888 May  6 01:00 cfc-1346230845-20100506-00
-rw-r-----  1 oracle dba 19365888 May  6 03:32 cfc-1346230845-20100506-01
-rw-r-----  1 oracle dba 19365888 May  6 03:32 cfc-1346230845-20100506-02
-rw-r-----  1 oracle dba 19365888 May  7 01:07 cfc-1346230845-20100507-00
-rw-r-----  1 oracle dba 19365888 May  7 03:39 cfc-1346230845-20100507-01
-rw-r-----  1 oracle dba 19365888 May  7 03:39 cfc-1346230845-20100507-02
-rw-r-----  1 oracle dba 19365888 May  7 23:25 cfc-1346230845-20100507-03

This is backup data:

-rw-r-----  1 oracle dba  1618413056 Apr 21 19:49 1blbgrpb_1_1
-rw-r-----  1 oracle dba 20017397760 Apr 21 21:43 1clbgs8v_1_1
-rw-r-----  1 oracle dba   128704512 Apr 21 21:44 1dlbh2u9_1_1
-rw-r-----  1 oracle dba    29040640 Apr 21 21:44 1elbh300_1_1
-rw-r-----  1 oracle dba  1403813888 Apr 21 21:52 1flbh30f_1_1
-rw-r-----  1 oracle dba   225673216 Apr 21 21:55 1glbh3fk_1_1
-rw-r-----  1 oracle dba   485539840 Apr 21 21:58 1hlbh3js_1_1
-rw-r-----  1 oracle dba   192610304 Apr 21 21:59 1ilbh3pv_1_1
-rw-r-----  1 oracle dba    78807040 Apr 21 22:00 1jlbh3t8_1_1
-rw-r-----  1 oracle dba    10706944 Apr 21 22:00 1klbh3ul_1_1
-rw-r-----  1 oracle dba     7462912 Apr 21 22:00 1llbh3us_1_1
-rw-r-----  1 oracle dba     4096000 Apr 21 22:01 1mlbh3v3_1_1
-rw-r-----  1 oracle dba  1734639616 Apr 21 22:10 1nlbh3v7_1_1
-rw-r-----  1 oracle dba   537280512 Apr 21 22:14 1olbh4hq_1_1
-rw-r-----  1 oracle dba   127664128 Apr 21 22:15 1plbh4nt_1_1
-rw-r-----  1 oracle dba   195510272 Apr 21 22:16 1qlbh4pk_1_1
-rw-r-----  1 oracle dba     4814336 Apr 21 22:16 1rlbh4s5_1_1
-rw-r-----  1 oracle dba   109209088 May  3 19:49 6dlcp9us_1_1
-rw-r-----  1 oracle dba 20016496640 May  3 21:43 6elcpa0m_1_1
-rw-r-----  1 oracle dba   104071168 May  3 21:43 6flcpglc_1_1
-rw-r-----  1 oracle dba    44326912 May  3 21:44 6glcpgmp_1_1
-rw-r-----  1 oracle dba  2241822720 May  3 21:56 6hlcpgn9_1_1
-rw-r-----  1 oracle dba   226050048 May  3 21:58 6ilcphe9_1_1
-rw-r-----  1 oracle dba   459718656 May  3 22:02 6jlcphiq_1_1
-rw-r-----  1 oracle dba   192610304 May  3 22:04 6klcphph_1_1
-rw-r-----  1 oracle dba    80093184 May  3 22:05 6llcpht5_1_1
-rw-r-----  1 oracle dba    10706944 May  3 22:05 6mlcphui_1_1
-rw-r-----  1 oracle dba     7462912 May  3 22:05 6nlcphup_1_1
-rw-r-----  1 oracle dba     4096000 May  3 22:05 6olcphv1_1_1
-rw-r-----  1 oracle dba  1736163328 May  3 22:15 6plcphv4_1_1
-rw-r-----  1 oracle dba   538984448 May  3 22:19 6qlcpiic_1_1
-rw-r-----  1 oracle dba   127516672 May  3 22:20 6rlcpioq_1_1
-rw-r-----  1 oracle dba   195510272 May  3 22:21 6slcpiqh_1_1
-rw-r-----  1 oracle dba    18633728 May  3 22:21 6tlcpit8_1_1
-rw-r-----  1 oracle dba    44103168 May  4 22:45 7jlcs8ls_1_1
-rw-r-----  1 oracle dba 20016513024 May  5 00:39 7klcs8mo_1_1
-rw-r-----  1 oracle dba   104169472 May  5 00:40 7llcsfcm_1_1
-rw-r-----  1 oracle dba    37765120 May  5 00:40 7mlcsfe3_1_1
-rw-r-----  1 oracle dba  2241626112 May  5 00:53 7nlcsfei_1_1
-rw-r-----  1 oracle dba   225468416 May  5 00:55 7olcsg5i_1_1
-rw-r-----  1 oracle dba   459767808 May  5 00:58 7plcsga3_1_1
-rw-r-----  1 oracle dba   192610304 May  5 01:00 7qlcsgfi_1_1
-rw-r-----  1 oracle dba    80281600 May  5 01:01 7tlcsgir_1_1
-rw-r-----  1 oracle dba    10706944 May  5 01:01 7vlcsgk9_1_1
-rw-r-----  1 oracle dba     7462912 May  5 01:01 80lcsgko_1_1
-rw-r-----  1 oracle dba     4096000 May  5 01:01 81lcsgl7_1_1
-rw-r-----  1 oracle dba  1736163328 May  5 01:14 82lcsgla_1_1
-rw-r-----  1 oracle dba   538984448 May  5 01:18 83lcshct_1_1
-rw-r-----  1 oracle dba   127516672 May  5 01:19 84lcshkt_1_1
-rw-r-----  1 oracle dba   195510272 May  5 01:21 85lcshmu_1_1
-rw-r-----  1 oracle dba     1378304 May  5 01:21 86lcshq0_1_1
-rw-r-----  1 oracle dba  3015792640 May  7 20:52 a2ld3u6c_1_1
-rw-r-----  1 oracle dba 20016570368 May  7 22:47 a3ld3v68_1_1
-rw-r-----  1 oracle dba   104144896 May  7 22:48 a4ld45to_1_1
-rw-r-----  1 oracle dba    34947072 May  7 22:48 a5ld45v5_1_1
-rw-r-----  1 oracle dba  2325528576 May  7 23:01 a6ld45vk_1_1
-rw-r-----  1 oracle dba   225271808 May  7 23:03 a7ld46n8_1_1
-rw-r-----  1 oracle dba   459767808 May  7 23:06 a8ld46rp_1_1
-rw-r-----  1 oracle dba   192610304 May  7 23:08 a9ld470u_1_1
-rw-r-----  1 oracle dba    80371712 May  7 23:08 aald4747_1_1
-rw-r-----  1 oracle dba    10706944 May  7 23:09 abld475b_1_1
-rw-r-----  1 oracle dba     7462912 May  7 23:09 acld475i_1_1
-rw-r-----  1 oracle dba     4096000 May  7 23:09 adld475p_1_1
-rw-r-----  1 oracle dba  1736163328 May  7 23:19 aeld475s_1_1
-rw-r-----  1 oracle dba   538460160 May  7 23:22 afld47of_1_1
-rw-r-----  1 oracle dba   127516672 May  7 23:23 agld47vr_1_1
-rw-r-----  1 oracle dba   195502080 May  7 23:25 ahld481i_1_1
-rw-r-----  1 oracle dba    26319872 May  7 23:25 aild484b_1_1

So, my question is what command that i need to use to restore this backup to new-clean database?

Thank you.
MzarM.

Report message to a moderator

Re: Restore backup to Fresh Database [message #454823 is a reply to message #454821]

Fri, 07 May 2010 11:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Depends on your need.
Does the new database reside in same host or another host?
Do you want to restore or recover to some point in time?
You can restore/recover or use RMAN duplication feature.
All are addressed in documentation.
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10734/rcmrecov.htm#1008869
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10734/rcmdupdb.htm#1006085

[Updated on: Fri, 07 May 2010 11:53]

Report message to a moderator

Re: Restore backup to Fresh Database [message #454828 is a reply to message #454823]

Fri, 07 May 2010 11:59

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

I want to restore and recover database from the list. So, what command i need to use? I'm new with DB. This is fresh database. The backup is from other server.

Report message to a moderator

Re: Restore backup to Fresh Database [message #454830 is a reply to message #454828]

Fri, 07 May 2010 12:04

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

Senior Member
Account Moderator

And why the links posted by Mahesh Rajendran do not answer your question?

Regards
Michel

[Updated on: Fri, 07 May 2010 12:05]

Report message to a moderator

Re: Restore backup to Fresh Database [message #454834 is a reply to message #454830]

Fri, 07 May 2010 12:08

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Because i don't which one i need to use. As you can see i have a lot of backup list. Do i need to type one by one? At least please show some example from my list.

Report message to a moderator

Re: Restore backup to Fresh Database [message #454836 is a reply to message #454834]

Fri, 07 May 2010 12:16

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

Senior Member
Account Moderator

RMAN knows the one that it needs, just asks it but basically it is the last full backup plus the incremental ones (f you have any) plus the archived log ones until the point you want to restore. These are basic of RMAN and restore/recover.

Regards
Michel

Report message to a moderator

Re: Restore backup to Fresh Database [message #454837 is a reply to message #454836]

Fri, 07 May 2010 12:20

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Ok, let me explain detail. Perhaps you not understand my situation.

1. I have backup data from Server A.

2. I finish setup new database on Server B.

3. I want to restore backup from Server A to Server B.

4. Server B is fresh database. No backup or list backup.

My point is how to restore and recover database from Server A to Server B? I already test but got some error. This is first time i restore backup to new database. Please assist me.

Report message to a moderator

Re: Restore backup to Fresh Database [message #454838 is a reply to message #454837]

Fri, 07 May 2010 12:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> I already test but got some error.
Messages like this does not help us anything.
Always post the exact error.
Had you read at least the headings in referred URL,
You could have come across this topic.
Restoring the Database to a New Host

Please read the docos.
Understand the restore/recover concepts before trying it and save yourself from the agony.

[Updated on: Fri, 07 May 2010 12:29]

Report message to a moderator

Re: Restore backup to Fresh Database [message #454841 is a reply to message #454838]

Fri, 07 May 2010 12:53

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

Senior Member
Account Moderator

Mahesh, why don't you copy and paste the documentation here, don't you know that some are not even able to click on a link and read titles?

Regards
Michel

Report message to a moderator

Re: Restore backup to Fresh Database [message #454871 is a reply to message #454841]

Fri, 07 May 2010 22:30

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

RMAN> run {
2> SET UNTIL TIME 'May 7 2010 04:00:00';
3> restore database;
4> recover database;
5> }

executing command: SET until clause
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 05/08/2010 11:29:56
ORA-01858: a non-numeric character was found where a numeric was expected

Report message to a moderator

Re: Restore backup to Fresh Database [message #454872 is a reply to message #454871]

Fri, 07 May 2010 22:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-01858: a non-numeric character was found where a numeric was expected

1858, 00000, "a non-numeric character was found where a numeric was expected"
// *Cause: The input data to be converted using a date format model was
//  incorrect.  The input data did not contain a number where a number was
//  required by the format model.
// *Action:  Fix the input data or the date format model to make sure the
//  elements match in number and type.  Then retry the operation.

>SET UNTIL TIME 'May 7 2010 04:00:00';

In Oracle characters between single quote marks are STRINGS
'this is a string, 2009-10-02, not a Date'
When you need to convert STRING to DATE use TO_DATE() function.

Report message to a moderator

Re: Restore backup to Fresh Database [message #454873 is a reply to message #454872]

Fri, 07 May 2010 22:58

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Sorry to say, I'm not expert with database. I also don't have experience with database. Perhaps some expert here can show to use from link provide by Mahesh. Maybe some example.

Report message to a moderator

Re: Restore backup to Fresh Database [message #454874 is a reply to message #454873]

Fri, 07 May 2010 23:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Perhaps some expert here can show to use from link provide by Mahesh. Maybe some example.

If you can not understand the information in the manual, why should we spend our time to print the same information here & expect that you understand the same information here?

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10734/rcmrecov.htm#1009919

Report message to a moderator

Re: Restore backup to Fresh Database [message #454875 is a reply to message #454874]

Fri, 07 May 2010 23:18

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

From what i read, i need to use duplicate but it's explain detail the command and which command i need to use. I keep trying one by one and this is waste my time.

p/s: My database use ASM and backup to disk not tape.

[Updated on: Fri, 07 May 2010 23:19]

Report message to a moderator

Re: Restore backup to Fresh Database [message #454880 is a reply to message #454871]

Sat, 08 May 2010 01:06

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

Senior Member
Account Moderator

Quote:

SET UNTIL TIME 'May 7 2010 04:00:00';

Quote:

failure of set command at 05/08/2010 11:29:56

Maybe you should try the format RMAN uses?

Regards
Michel

[Updated on: Sat, 08 May 2010 09:14]

Report message to a moderator

Re: Restore backup to Fresh Database [message #454908 is a reply to message #454880]

Sat, 08 May 2010 07:00

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

If i want to export tablespace from Server A it it possible? Can i export using id SYS? I mean export using data pump.

Report message to a moderator

Re: Restore backup to Fresh Database [message #454920 is a reply to message #454908]

Sat, 08 May 2010 09:17

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

Senior Member
Account Moderator

If you have another question, create another topic above all when the topic does not belong to the same forum.
Now, because of your, this topic is locked but it does not matter as if you post a new question, this is because the previous one is solved.

Regards
Michel

Report message to a moderator

Previous Topic:	undo segment needs recovery
Next Topic:	How can I restore parameter file ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 04:29:36 CST 2025