| Restore from BAK file as a new database [message #61815] |
Tue, 01 June 2004 18:42 |
SasaN
Messages: 7
Registered: September 2002
|
Junior Member |
|
|
Hi,
I have done full database (9iR2) RMAN backup following user manual:
RMAN> shutdown immediate;
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount;
connected to target database (not started)
Oracle instance started
database mounted
RMAN> backup database;
Starting backup at 20/MAY/04
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00006 name=E:ORACLEORADATAUPTESTTREND.DBF
input datafile fno=00001 name=E:ORACLEORADATAUPTESTSYSTEM01.DBF
input datafile fno=00002 name=E:ORACLEORADATAUPTESTUNDOTBS01.DBF
input datafile fno=00003 name=E:ORACLEORADATAUPTESTINDX01.DBF
input datafile fno=00005 name=E:ORACLEORADATAUPTESTUSERS01.DBF
input datafile fno=00004 name=E:ORACLEORADATAUPTESTTOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 20/MAY/04
channel ORA_DISK_1: finished piece 1 at 20/MAY/04
piece handle=E:ORACLEORA92DATABASE 2FM7SJD_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
Finished backup at 20/MAY/04
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 400M DISK 00:00:51 20/MAY/04
BP Key: 1 Status: AVAILABLE Tag: TAG20040520T095700
Piece Name: E:ORACLEORA92DATABASE 2FM7SJD_1_1
SPFILE Included: Modification time: 14/MAY/04
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 455900 20/MAY/04 E:ORACLEORADATAUPTESTSYSTEM01.DBF
2 Full 455900 20/MAY/04 E:ORACLEORADATAUPTESTUNDOTBS01.DBF
3 Full 455900 20/MAY/04 E:ORACLEORADATAUPTESTINDX01.DBF
4 Full 455900 20/MAY/04 E:ORACLEORADATAUPTESTTOOLS01.DBF
5 Full 455900 20/MAY/04 E:ORACLEORADATAUPTESTUSERS01.DBF
6 Full 455900 20/MAY/04 E:ORACLEORADATAUPTESTTREND.DBF
RMAN> restore database validate;
Starting restore at 20/MAY/04
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: restored backup piece 1
piece handle=E:ORACLEORA92DATABASE 2FM7SJD_1_1 tag=TAG20040520T095700 params
=NULL
channel ORA_DISK_1: validation complete
Finished restore at 20/MAY/04
RMAN> alter database open;
database opened
RMAN>
Now when I have valid backup file I would like to restore it on another machine (Win2000 as original host) but can not find any instructions about it. In SQL Server I could use restore (GUI and it will create new db from backup) but in Oracle is a bit different story.
Any help would be much appreciated.
Thank you
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
