Refresh database [message #212541] |
Fri, 05 January 2007 15:25 |
plshelp
Messages: 205 Registered: January 2007
|
Senior Member |
|
|
Hello all,
Happy New Year! I am working as a junior dba,I need some help in refreshing the database. I have googled it a bit but struggling to get the proper idea into my head.I would really appreciate if somebody could give me the steps involved to proceed further. Here is the process:
1. In a week or so, I will have to refresh the validation database with previous nights production data.
2. Perform pre-upgrade activities ( upgrade from 8.1.7.4 to 9.2.0.6).
3. Perform the upgrade.
4. Perform post-upgrade activities.
Please help me.
Thank you very much in advance.
|
|
|
|
|
Re: Refresh database [message #212804 is a reply to message #212541] |
Mon, 08 January 2007 07:38 |
plshelp
Messages: 205 Registered: January 2007
|
Senior Member |
|
|
Ebrian,
Thanks for your reply.I just started a week ago. So I am not pretty sure whats going on. All I know is I have to refresh the database and upgrade it.
As far as i know, you are right that the validation db is going to be a dup of prod database. And regarding the backups, its everynight full backup and weekend full cold backup. I would like to know the basic/general steps/procedures for refreshing the database. Please help. I really appreciate it.
Martjin,
Thanks for your reply. I will definetely look into the documents before proceeding the upgrade. Thank you very much.
Regards,
Geetha
|
|
|
|
Re: Refresh database [message #212820 is a reply to message #212541] |
Mon, 08 January 2007 08:05 |
plshelp
Messages: 205 Registered: January 2007
|
Senior Member |
|
|
Hi Taj,
As i mentioned previously, I am new to the company and I am still getting used to the environment here. So, I am not sure why they want to refresh the database. My imagination is, they might have had problems in the database, so they want to refresh
it now before doing the upgrade. I have to refresh the validation database from the backup. Everynight full backup is cold backup and its using the scripts.
I apologize that I am unable to provide you with the full information.
Thanks,
Geetha.
|
|
|
Re: Refresh database [message #212828 is a reply to message #212820] |
Mon, 08 January 2007 08:23 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
I have to refresh the validation database from the backup
You have cold backup of your production database and you want to valid your backup if yes then you can create new database with you cold backup of your production database.
1. take cold backup or ur database
sql>shutdown immediate;
sql>rem using OS copy cmd COPY all datafile files, redo log files, control files , spfile, password files, No need to archive log files.transter ur backup to another machine.on another machine install oracle software without database.and fellow below procedure.
C:\>set oracle_sid=orclC:\>orapwd file=d:\oracle\product\10.1.0\db_2\database\pwdorcl.ora password=oracle
C:\>d:\oracle\product\10.1.0\db_2\bin\oradim.exe -new -sid ORCL -startmode manual -spfile
Instance created.
C:\>d:\oracle\product\10.1.0\db_2\bin\oradim.exe -edit -sid ORCL -startmode auto
C:\>sqlplus/nologSQL*Plus: Release 10.1.0.2.0 - Production on Sat Dec 9 12:36:53 2006Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> conn sys as sysdbaEnter
password:
Connected to an idle instance.
note 1.paste all datafile , redo log file, control file, or spfile<sid>.ora in there location.
create folder in oraclehome/admin---bdump
or cdump
or udump
and
oraclehome/ordata--orcl (according to ur dbname)
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.Database altered.
SQL>
[Updated on: Mon, 08 January 2007 08:24] Report message to a moderator
|
|
|
Re: Refresh database [message #212830 is a reply to message #212541] |
Mon, 08 January 2007 08:35 |
plshelp
Messages: 205 Registered: January 2007
|
Senior Member |
|
|
Hi
Thanks for your reply Taj. Really appreciated. I believe the steps you mentioned are for refreshing the database.
Thanks very much
Geetha
|
|
|
|
|