Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools
 

Topic:  >> Backup & Recovery

Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property. You may review the entire Oracle Certification Program Candidate Agreement online Here.



  


 Title: Backup & Recovery
 Aditya  Posted: Aug 30, 2003 12:00:00 AM

 Total Post: 32
 Joined: Jan, 2003






 

 triso
Posted: Jan 02, 2003 04:57:00 PM  

 Total Post: 1
 Joined: Jan, 2003






 
Hi Friends,
Can some one tell me use of CONSISTENT=Y in export?

Please try to answer ASAP?

Thanks,
Krity




 nocturnal
Posted: Dec 26, 2002 05:10:00 PM  

 Total Post: 11
 Joined: Jan, 2003






 
Hi All,

Is it possible to redirect exp/imp output into a file instead of screen? I am running a cron job for export and it not working as exp command is producing screen output. I tried to redirect it into a file but it does not work.

Any idea, or script that can run export backup..?

Thanks,
Puneet.

 uadmin
Posted: Feb 22, 2003 09:50:00 AM  

 Total Post: 6
 Joined: Jan, 2003






 
Hi Everybody,
Can you please send me some quick steps for RMAN configuration?

Thanks,
Rob


 uadmin
Posted: Mar 11, 2003 09:41:00 PM  

 Total Post: 6
 Joined: Jan, 2003






 
Hi Guys,

Can you please send me steps for Export/Import using pipes on Unix?

Thanks,
Rob

 vitthalm
Posted: Mar 13, 2003 10:39:00 PM  

 Total Post: 4
 Joined: Jan, 2003






 
Hi Guys,
How can I speed up my export/import? It is taking too long to export 10 GB database.

Thanks for your help.

Shaju.



 sumipal
Posted: Mar 26, 2003 11:13:00 PM  

 Total Post: 6
 Joined: Jan, 2003






 
Hello All,
I got the following error message when we tried to export a user.

EXP-00041: Export done in server's WE8ISO8859P1, different from user's character set US7ASCII
EXP-00000: Export terminated unsuccessfully

Can somebody explain this to me and tell me how to fix it?

Thanks!
Kris


 esmith
Posted: Apr 19, 2003 02:08:00 AM  

 Total Post: 1
 Joined: Jan, 2003






 
Dear sir,
I have a Question about to sending an attachment through PL/SQL. It is Possible to send the text .I got one Package through OTN, package name is UTL_SMTP but with that package Text is going. I am successful to send the Text only to CC: BCC etc.
My Question is: I have one simple file for e.g.
C:\My Documents\g1.doc. This file content text HELLO . Now I want to ATTACH this file to that code. How to attach this file that code. I dont know how to attach the file. Or is there any another Procedure to attach the file.

Sir Please solve my Problem.
I am trying this problem from 20 to 25 days. But I am successful to send text only.

Bye
Girish Dandge
Thank s and regards
Do mail


 dbapool Editor
Posted: Jun 14, 2003 08:07:00 PM  

 Total Post: 5
 Joined: Jan, 2003






 
Hi All,
I have been using following code for level0 archive log RMAN backup on Oracle 8.1.7.4. All archived log files are backing up on the disk. I would like to know the best way to delete them from the disk.

sql 'alter system archive log current';
backup
filesperset 20
format '/BACKUP/db1/rman/archive/db1_al_t%t_s%s_p%p'
archivelog all
delete input;

I tried following rman commands but these does not delete archive logs files from the disk or changed the status. List backup is showing all pervious backup with available status.

allocate channel for maintenance type disk;
crosscheck backupset of database;
delete expired backupset;
delete expired backup of archivelog all;
release channel;

Any suggestions?

Thanks,
Raj



 eye8urgrl
Posted: Aug 09, 2003 11:52:00 AM  

 Total Post: 1
 Joined: Jan, 2003






 
Can a dropped partition be recovered ?
What is the best way to backup partitions ? tablespace ?


 Pat
Posted: Nov 04, 2003 10:26:48 AM  

 Total Post: 8
 Joined: Jan, 2003






 
Hi,

can i import an Oracle full dump make on a windows 2000 database on a Unix Oracle database?


 naivedya
Posted: Nov 20, 2003 05:56:04 AM  

 Total Post: 14
 Joined: Jan, 2003






 
If Database is in Non-Archive mode and no Backup (DMP files)is available & Redolog files are lost, how do one get DB back ??

The following INIT.ora parameter may be required if your current redologs are corrupted or blown away.
_allow_resetlogs_corruption = true

PLEASE CONTACT ORACLE SUPPORT BEFORE USING IT.

 P
Posted: Nov 28, 2003 02:14:06 PM  

 Total Post: 7
 Joined: Nov, 2003






 
hello dba's !
iam new to dba admin..
i took export of my database which it is working on RH linux AS 2.1. i tried to import on windows Xp..
during this i got errors ....
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by DOTSOFT, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
. importing FRS's objects into FRS
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'FRS', export_db_name=>"
"'APADB1.US.ORACLE.COM', inst_scn=>'1767299344');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "AREA_TRANSFER" ("AREA_TFR_SNO" VARCHAR2(5), "FROM_EXCHANGE_CO"
"DE" VARCHAR2(6), "ITEM_FLAG" VARCHAR2(1), "UNIQUE_ID_NO" VARCHAR2(17), "OLD"
"_PHONE_NO" VARCHAR2(12), "NEW_PHONE_NO" VARCHAR2(12), "OLD_EQUIPMENT_NO" VA"
"RCHAR2(12), "OLD_VERTICAL_NO" VARCHAR2(10), "OLD_DP_TAG" VARCHAR2(13), "OLD"
"_CABINET_IN" VARCHAR2(5), "OLD_CABINET_OUT" VARCHAR2(5), "OLD_PILLAR_IN" VA"
"RCHAR2(5), "OLD_PILLAR_OUT" VARCHAR2(5), "NEW_EQUIPMENT_NO" VARCHAR2(12), ""
"NEW_VERTICAL_NO" VARCHAR2(10), "NEW_DP_TAG" VARCHAR2(13), "NEW_CABINET_IN" "
"VARCHAR2(5), "NEW_CABINET_OUT" VARCHAR2(5), "NEW_PILLAR_IN" VARCHAR2(5), "N"
"EW_PILLAR_OUT" VARCHAR2(5), "REMARKS" VARCHAR2(50)) PCTFREE 40 PCTUSED 60 "
"INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 983040 FREELISTS 2 FREELIST GROUPS "
"1) TABLESPACE "FRS" LOGGING NOCOMPRESS CACHE"
IMP-00003: ORACLE error 922 encountered
.....
....
...."NO_PARSE=>TRUE); END;"
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_JOB", line 97
ORA-06512: at line 1
Import terminated successfully with warnings.
...
please helpme in this regard.
just tell me how i can migrate my database from
linux to windows XP...please tell me in steps...
thank u rajamahender
my mail id : rajamahender231@yahoo.com


 T
Posted: Dec 04, 2003 11:02:10 AM  

 Total Post: 1
 Joined: Dec, 2003






 
I am using EXP to save database from 9i to load using IMP on new machine's 9i: in the DMP file, table definitions end: 'logging nocompress' - IMP wont load the dmp file - the problem is the nocompress option - if i delete it, tables create ok in the new database - however, i cant edit the whole dmp file like this (as this invalidates a hash in its header I think). ANY ideas anyone?

 Stan
Posted: Dec 09, 2003 11:13:51 AM  

 Total Post: 2
 Joined: Dec, 2003






 
Whenever I try to enable the RESOURCE_MANAGER_PLAN I get the following error messages:

ORA-02097 Parameter cannot be modified because specified value is invalid
Cause: Though the initialization parameter is modifiable, the modified value is not acceptable to the parameter.
Action: Check the Oracle9i Database Administrators Guide for range of acceptable values for this parameter.

ORA-00439 Feature not enabled: string
Cause: The specified feature is not enabled.
Action: Do not attempt to use this feature.

I am trying to do exports of certain users (parameter supplied). Prior to executing the export I am trying to run the following command:

alter system quiesce restricted

To temporarily halt any updates to the database, so that I may export the requested data.

I get an error message telling me that the RESOURCE_MANAGER_PLAN is not on:

ORA-29373 Resource manager is not on
Cause: An attempt was made to execute an operation that cannot be executed with the resource manager being off.
Action: Turn on the resource manager and try again.

According to the Admins Guide it says that the RESOURCE_MANAGER_PLAN can be enabled one of two ways:

With Enterprise Manager

Click on Activate This Plan

ALTER SYSTEM SET resource_manager_plan = 'CCC_DOE'
ALTER SYSTEM SET resource_manager_plan = 'SYSTEM_PLAN'

Or

By issuing the alter system command

alter System set resource_manager_plan = ' CCC_DOE '
alter System set resource_manager_plan = 'SYSTEM_PLAN'


This is a valid plan that has been created.

I have tried both ways and received the error messages noted above. In all cases I was logged on as either SYS or SYSTEM as SYSDBA.

Database Information: Oracle 9i Release 9.0.1.1.1 Production with the Objects option
Restricted Mode = NO
Archive Log Mode = ARCHIVELOG

Operating System: Windows NT Version: 5.0


 Stan
Posted: Dec 09, 2003 02:24:44 PM  

 Total Post: 2
 Joined: Dec, 2003






 
Whenever I try to enable the RESOURCE_MANAGER_PLAN I get the following error messages:

ORA-02097 Parameter cannot be modified because specified value is invalid
Cause: Though the initialization parameter is modifiable, the modified value is not acceptable to the parameter.
Action: Check the Oracle9i Database Administrators Guide for range of acceptable values for this parameter.

ORA-00439 Feature not enabled: string
Cause: The specified feature is not enabled.
Action: Do not attempt to use this feature.

I am trying to do exports of certain users (parameter supplied). Prior to executing the export I am trying to run the following command:

alter system quiesce restricted

To temporarily halt any updates to the database, so that I may export the requested data.

I get an error message telling me that the RESOURCE_MANAGER_PLAN is not on:

ORA-29373 Resource manager is not on
Cause: An attempt was made to execute an operation that cannot be executed with the resource manager being off.
Action: Turn on the resource manager and try again.

According to the Admins Guide it says that the RESOURCE_MANAGER_PLAN can be enabled one of two ways:

With Enterprise Manager

Click on Activate This Plan

ALTER SYSTEM SET resource_manager_plan = 'CCC_DOE'
ALTER SYSTEM SET resource_manager_plan = 'SYSTEM_PLAN'

AND

ALTER SYSTEM SET resource_manager_plan = CCC_DOE
ALTER SYSTEM SET resource_manager_plan = SYSTEM_PLAN

Or

By issuing the alter system command

alter System set resource_manager_plan = 'CCC_DOE'
alter System set resource_manager_plan = 'SYSTEM_PLAN'

AND

alter System set resource_manager_plan = CCC_DOE
alter System set resource_manager_plan = SYSTEM_PLAN

This is a valid plan that has been created.

I have tried both ways and received the error messages noted above. In all cases I was logged on as either SYS or SYSTEM as SYSDBA.

Database Information: Oracle 9i Release 9.0.1.1.1 Production with the Objects option
Restricted Mode = NO
Archive Log Mode = ARCHIVELOG

Operating System: Windows NT Version: 5.0


 rosol
Posted: Jan 16, 2004 01:59:40 PM  

 Total Post: 4
 Joined: Jan, 2003






 
Hi All,

I am getting this error while trying to connect to the RMAN target database. Any idea?

rman catalog xxxx/xxxx@xxxx target xxxx/xxxx@xxxx

Recovery Manager: Release 8.1.7.0.1 - Production

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: ORA-01031: insufficient privileges



Thanks,
Rosol

 Vimal
Posted: Mar 08, 2004 10:45:29 AM  

 Total Post: 14
 Joined: Jan, 2003






 
Hi All,

I am trying to recover a database by creating new control file and getting this error.

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u02/oradata/prod/users_01.dbf'
ORA-27046: file size is not a multiple of logical block size

Do you have any idea?

Thanks,
Vimal

 du365
Posted: Mar 29, 2004 07:39:30 PM  

 Total Post: 6
 Joined: Jan, 2003






 
Hey guys, I need help on this.

I am using Oracle9i on Windows XP

I was using RMAN to backup my database in archive log mode and enter this command:

RMAN> run
2> {
3> allocate channel ch1 type disk;
4> backup database format db_%u_%d_%c_%s;
5> backup format log_t%t_s%s_p%p
6> (archivelog all);
7> }

Once I typed this in, I received this error message:

released channel: ORA_DISK_1
allocated channel: ch1
channel ch1: sid=9 devtype=DISK

Starting backup at 28-MAR-04
channel ch1: starting full datafile backupset
channel ch1: specifying datafile (s) in backupset
channel ch1: starting piece 1 at 28-MAR-04

RMAN-00571: ===================================================
RMAN-00569: ========ERROR MESSAGE STACK FOLLOWS=============
RMAN-00571: ===================================================
RMAN-00579: the following error occurred at 03/28/2004 19:02:03
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-12004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file db_4rfhqg98_RACLS_1_155
ORA-27044: unable to write the header block of file
OSD-04008: Writefile() failure, unable to write to file
O/S-ERROR: (OS 112) There is not enough space on the disk.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE


I need help in fixing this problem I have, please advise.

Thank you
du365


 Brad
Posted: Mar 30, 2004 12:33:27 PM  

 Total Post: 1
 Joined: Mar, 2004






 
i have a perl script that removes week-old archives logs physically from the disk. however, when i query the v$archived_log view, all of the archive logs that have been physically removed are still seen in the view. i read that the control_file_record_keep_time is supposed to manage the contents of the control file. in my case, this parameter is set to the default of 7 days. i have also read that the 'DELETED' column in the v$archived_log view is set to 'YES' if an RMAN delete command has been issued--i'm guessing that this does not apply to archive logs that have been removed from the OS level. how can i maintain the view to be up-to-date after an archive log is removed? thx

 Kris
Posted: May 19, 2004 11:54:47 AM  

 Total Post: 30
 Joined: Jan, 2003






 
Hello,
can you tell me how to check log mode in the database. what query? it is urgent.

thanks

 rob
Posted: Sep 01, 2004 05:29:33 PM  

 Total Post: 9
 Joined: Jan, 2003






 
Hello,

I am getting 'Exp-00091' error during export after upgrading oracle to 9.2.0.5.

EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.

export was working fine before upgrading. I dont have stats on the table.. I dont know what export is complaining for.

Can you please advise?

Thanks,
Rob



 prak
Posted: Nov 17, 2004 02:20:59 PM  

 Total Post: 2
 Joined: Nov, 2004






 
Hi i have a exp problem


i ran catexp.sql, catrm.sql on a 9.2.0.1.0 database running on a win2K server bcos i had to import on a 8i customer machine

then later again ran the latest catexp, catrm.sql from the ...rdbms/admin/ folder.

still i get this errror of questionable statistics error.

previously i never used to get.

any other cat* script needs to be run?

 jmiller
Posted: Jan 04, 2005 04:44:18 PM  

 Total Post: 3
 Joined: Jan, 2003






 
Hi All,

I am trying to rename a database using control file and getting following error.

ORA-01503: CREATE CONTROLFILE failed

ORA-01161: database name PROD01 in file header does not match given name of PROD

I generated following script from trace.

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 30
MAXINSTANCES 1
MAXLOGHISTORY 449
LOGFILE
GROUP 1 (
'/u02/oradata/PROD/log1a.log',
'/u03/oradata/PROD/log1b.log'
) SIZE 1M,
GROUP 2 (
'/u02/oradata/PROD/log2a.log',
'/u03/oradata/PROD/log2b.log'
) SIZE 1M
-- STANDBY LOGFILE
DATAFILE
'/u02/oradata/PROD/system_01.dbf',
'/u02/oradata/PROD/undotbs_01.dbf',
'/u02/oradata/PROD/rmandata_01.dbf',
'/u02/oradata/PROD/users_01.dbf'
CHARACTER SET US7ASCII
;

Can you tell me what is wrong here? This is very urgent so please reply asap.


Thanks
J

 nhan
Posted: Mar 04, 2005 05:11:39 AM  

 Total Post: 2
 Joined: Dec, 2004






 
Hi everyone,

I have a file .bak, and now I want to restore into a new database.
I did as below and unsuccessed :)
1. connect to RMAN
2. RMAN> configure channel 1 device type disk format
'/oradata/db1.BAK';
3.RMAN>restore database.
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/04/2005 15:24:32
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 11 found to restore
.....

pls help me, what'wrong and how to do it
Thanks a lot

 Steve
Posted: Apr 28, 2005 04:39:09 AM  

 Total Post: 1
 Joined: Apr, 2005






 
Hi ,

we have Veritas Backup Exec , would an Oracle Agent for linux be enough to use or should we go down the road of investing in Veritas Netbackup?

Any ideas?

Thanks!

Steve

 SreenivasaRao
Posted: May 25, 2005 08:11:55 AM  

 Total Post: 8
 Joined: Apr, 2005






 
Hi ALL
Iam working with oracle9i iam new for Oracle.i configured the OMS
1.in Orcle9i-->configuration managemant tools-->EM configuration assistant
doing all this,
in Enterprze console iam trying ot back is giveing error like this

"this wizard can only be lunched when the application is connected to the OMS.lunch the application and connect to the OMS before trying the wizad agian"

some body help me where iam mistake,
in services OMS service is also not starting

i try this thing different mechines ,but iam underastand what is mistake from myside


some body help me

 SreenivasaRao
Posted: Jun 02, 2005 05:30:29 AM  

 Total Post: 8
 Joined: Apr, 2005






 
HI
ALL I TAKEN BACKUP..OF ORACLEDB BY USING RMAN
RMAN> run{
Allocate channel s1 type disk;
Backup datafile c:\MY\system01.dbf format c:\MY\temp01.dbf;
}
Now i want restore this back what r the step needed to restore...
1.Can i create DB in Distination server or RMAN IT SELF CREATE DB
2.if suppose i create db that must be same structure of source db or simple format
3.what r the pre-caution i suppose to take while restoreing



 SreenivasaRao
Posted: Jun 02, 2005 06:31:27 AM  

 Total Post: 8
 Joined: Apr, 2005






 
Hi


all

One of my DB server crashed..but that server is noy much impartent.but ofcourse,

i got Datafiles,dat1.dbf,dat2.dbf
and control file control01.ctl
control02.ctl
control03.ctl

and redologs

and archivelog files


---my aim is i want instal oracle in other system or in same system by using above file i have to get data

for that what i have to do

pls explain me gurus


 Martyn
Posted: Jul 25, 2005 11:32:07 AM  

 Total Post: 1
 Joined: Jul, 2005






 
RMAN Release 9.2.0.6.0 on Redhat Linux.
Run RMAN Script fails with RMAN-06167: Already connected, but creates the backup files as if succeeded. I have tried logging into RMAN and pointing at a different target before logging back out again then running the backup again. Same result. Any help would be greatly appreciated.

 Deepak
Posted: Sep 02, 2005 02:48:02 AM  

 Total Post: 10
 Joined: Mar, 2005






 
Hi, all (specially VIGYAN )

i am in a great problm, some one has deleted 4 records from my database and i want them back right now. pls tell me how to know that who did this and how to recover them.


Plsssssssssss do it fast.

HOPING for my best

 taha
Posted: Oct 23, 2005 04:17:40 AM  

 Total Post: 4
 Joined: Oct, 2005






 
Hi All,

Any body can help me please,

I Have an Oracle Database on WIN2000 Server, the PC gets unproper shutdown, and after that, the databse never started, It's Giving Errors
ORA-01122 and ORA-01267

Please help me gitting My Database Up.

regards



 SHAKEEL
Posted: Nov 12, 2005 01:50:49 PM  

 Total Post: 4
 Joined: Nov, 2005






 

i take backp of Oracle 9i from one system installing Window XP 2004 and import that file in Oralce 9i second system having Window 2000, then i recevied that error


C:\>IMP
Import: Release 9.0.1.1.1 - Production on Fri Nov 4 02:44:04 2005

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Username: USER_NAME
Password: *********

Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

Import file: EXPDAT.DMP > D:\EXPORT_FILE.DMP

Enter insert buffer size (minimum is 8192) 30720>

IMP-00016: required character set conversion (type 178 to 871) not supported
IMP-00000: Import terminated unsuccessfully


so can u solve my problem. if i import that file in any system having window 2000. it import successfully but o


 arif
Posted: Dec 09, 2005 04:03:47 PM  

 Total Post: 3
 Joined: Dec, 2005






 
Hello,
I have a database with 30gb, and used 20gb.and it's noarchive mod. when i am taking a backup using export utility it took 8gb space. but when i am taking backup using Rman it took 20gb space. can someone tell why it's like that.I know there are lot of benifit with rman but why the space wise the rman take backup only used block up to 20gb. how about export backup take 8gb instead of 20gb.


 sasi
Posted: Dec 28, 2005 10:08:04 AM  

 Total Post: 59
 Joined: Nov, 2005






 

Hi,
what are differences between RMAN & Logical Backups.

venkat

 sasi
Posted: Dec 28, 2005 10:09:44 AM  

 Total Post: 59
 Joined: Nov, 2005






 
Hi,

What is Consistent backup & Inconsistent backup.

venkat sarath

 sasi
Posted: Jan 06, 2006 06:36:37 AM  

 Total Post: 59
 Joined: Nov, 2005






 

Hi,
suppose i am taking HOT BACKUP. i am giving BEGIN BACKUP mode.
At that time users can able access . they can able can select, insert or update?
plz mail me
venkat sarath

 sasi
Posted: Jan 07, 2006 09:11:19 AM  

 Total Post: 59
 Joined: Nov, 2005






 
Hi,

SUPPOSE i having port no 3000 in listener.ora file.
in os level how can i came to know ? PORT NO's

pls send me
venkat

 sasi
Posted: Jan 13, 2006 08:39:12 AM  

 Total Post: 59
 Joined: Nov, 2005






 
Hi ,

suppose i have 90 GB data.
if i take Logical Backup how much time to take that?
if i take Hot backup how much time to take that?

pls send me
venkat sarath

 sasi
Posted: Feb 04, 2006 02:31:11 AM  

 Total Post: 59
 Joined: Nov, 2005






 
Hi,

Suppose i am taking online Bkp at 5.00PM . I will backup mode.
At same time some users are updated a datafile,at 5.02PM one user is also updating same datafile.

In that backup i will update to that users data are not?
What is interally happening?

PLZ REPLY

sarath

 sasi
Posted: Feb 04, 2006 02:33:47 AM  

 Total Post: 59
 Joined: Nov, 2005






 
HI,

Suppose i am having the BACKUP in /dis2 . I want to copy in tape drives.
What are the steps in LINUX,SOLARIS.

plz Reply
sarath

 sudheer
Posted: Feb 06, 2006 08:10:08 AM  

 Total Post: 2
 Joined: Nov, 2005






 
I am Backing up my files to dat tape in fbackup mode.
How to find the Size of each file or particualr file from
the tape.
what command to use.



 sasi
Posted: Feb 13, 2006 07:18:41 AM  

 Total Post: 59
 Joined: Nov, 2005






 

Hi

I am installing oracle in linux m/c . i am setting kernel parameters ? it is mandatory or not?

sarath

 Kavitha
Posted: Mar 01, 2006 07:28:08 AM  

 Total Post: 6
 Joined: Feb, 2006






 
Hi Friends,

I tried to connect to RMAN from command line
with
rman target user/pwd@SID
but it says recover.bsq file is missing.
I installed Oracle 9i.
recover.bsq file should be present in this following path. but it is missing in that corresponding path.
How can i get recover.bsq file.

Kavitha

 nur
Posted: Mar 13, 2006 04:13:52 AM  

 Total Post: 2
 Joined: Mar, 2006






 
in my machine, when i login from sql*plus interfce then i can easily connected with my database server. But when i use any third party software interface then Error: Tns service name could not reslove
what can do i do?

 nur
Posted: Mar 14, 2006 02:19:52 AM  

 Total Post: 2
 Joined: Mar, 2006






 
Hello everybody,
I will face interview for Dba. So please send me some important question with answer.


 Rajinikanth
Posted: Mar 14, 2006 07:40:26 AM  

 Total Post: 2
 Joined: Mar, 2006






 
hi

i am trying to import a schema using impdp utility, i am getting following error, please help me.

this the command i executed

# impdp rajini1/rajini1@sales DIRECTORY=rajini dumpfile=EXPDAT01.DMP logfile=prd_imp_log.log

Import: Release 10.1.0.3.0 - Production on Monday, 13 March, 2006 22:25
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "/otb/prod_dir/EXPDAT01.DMP"

thanks

rajini.



 santhosh
Posted: Mar 20, 2006 09:09:19 AM  

 Total Post: 5
 Joined: Mar, 2006






 
hi all,

pls give step by step procedure how to take a backup using import/export .

 Susant Kumar
Posted: Mar 21, 2006 09:28:50 AM  

 Total Post: 1
 Joined: Dec, 2005






 
In my company we are going to implement a standby database.
so i need to know how to configure the standby server.
and i am interested to know how it works.
from susanta

 VIJAY
Posted: Mar 21, 2006 04:52:00 PM  

 Total Post: 7
 Joined: Nov, 2005






 
Hi all,

I am getting an error while creating table,
error-01552 : cannot use system rollback segment for non-system tablespace 'TABSP'
Description:
I have created a database with the database name 'testdba'
then I have created a tablespace 'tabsp' & a user 'vij'
then assigned the tablespace to the user 'vij' by doing...
SQL> alter user vij default tablespace tabsp;
then
SQL>connect vij
after connecting to user vij
tried to create a table by doing.......
SQL>create table sanjaytab(ename varchar2(10),eno number(5));
& GOT AN ERROR error-01552 : cannot use system rollback segment for non-system tablespace 'TABSP'

PLEASE TELL ME WHY I AM GETTING THIS ERROR & WHY I AM NOT ABLE TO CREATE TABLE UNDER THE USER NAME 'VIJ'

 Senthil Kumar
Posted: Mar 26, 2006 10:20:19 PM  

 Total Post: 5
 Joined: Jan, 2006






 
Hi
My database is running in archivelog mode.
my doubt is whether after taking online backup of all the tablespace,we need to maintain all the old archive log files?

 Ramesh Babu
Posted: Jun 19, 2006 01:13:58 PM  

 Total Post: 2
 Joined: Jan, 2006






 
Hi

I want to test backup and restore using RMAN can some one give a sample scenario of taking backup and restoring of oracle database on Linux.

Thanks in Advance,
Ramesh.


 Suresh
Posted: Jul 19, 2006 04:07:24 AM  

 Total Post: 2
 Joined: Jul, 2006






 
I tried to migrate the complete database from one compiuter to another.
It's on oracle 9i and need to imported on same oracle 9i,
I used exp utility to export it.
e.g exp system/<pass.> full=y file=c:\mydb.dmp

There is no problem while doing export, it prepares mydb.dmp on given location.
I have kept mydb.dmp in server and used imp utility to export.
e.g imp system<pass.> full=y
It has importyed successfully.

I got confusion with imp utility to get same database in destination computer.

I have found that there is mapping parameter with Oracle datapump in
10g. Now, in oracle 9i, didn't get the same database inside oradata
(Where the database resides) folder at server after doing import.

What additional work I should do to get exported same complete
database in oradata folder in oracle so that I can open it through
startup after changing ORACLE_SID, os environment variable in
destination computer.

I guess you came to know the scenirio, could you please guide me what
additional I should to get same exported database in destination using
imp utility.

I tried and even explore on net but not got the satisfied solution.


Suresh Gautam



 Suresh
Posted: Jul 23, 2006 02:50:15 AM  

 Total Post: 2
 Joined: Jul, 2006






 
I have three databases named xyz, pqr and mno in default location, oradata folder of oracle.
Let's say pqr would be loaded as a default one.
I need to work on windows environment:
Now I want to start the xyz database.

As I used to changed environment variable ORACLE_SID=xyz from command prompt before starting sqlplus in Linux and if started the sqlplus it could load the xyz database.

Suppose, all the services are running at the background in windows XP.
I have loaded the command prompt and issue set ORACLE_SID=xyz and started the sqlplus, still it loads same database mno.

Anybody, what's the step I missed here.
Suresh

 Fahad
Posted: Aug 10, 2006 04:00:34 AM  

 Total Post: 3
 Joined: Jan, 2006






 
I want to import data from .lst file to my oracle database, can any one tell me the procedure to accomplish this task. i tried UTL method but its not working.

here is the sample data that i want to import

01AUG2006|AKDITF|27500|||
01AUG2006|ABCF|200500|||
01AUG2006|AMMF|17000|||
01AUG2006|ATFF|63000|||
01AUG2006|BSBF|18000|||
01AUG2006|CPMFI|500|||
01AUG2006|GASF|349000|||
01AUG2006|PGF|4649000|||

 madhugp
Posted: Aug 10, 2006 11:14:10 AM  

 Total Post: 13
 Joined: Jul, 2006






 
hi friends, In getting auditing info from sys.aud$,
user_audit_trail etc.. views I am able to view session,
statement no, action number etc.. columns only in either DB type
audit or OS type audit.
how can i view the statment also.
for e.g
sql>audit alter on emp;
sql>alter table emp modify ename varchar2(30);

in audit info. i want to see the above statement also.

rememeber this is not in sys user.

thanks


 sridhar
Posted: Aug 19, 2006 02:32:30 PM  

 Total Post: 2
 Joined: Aug, 2006






 
hi ,
I am using oracle 9.2.0.6 RAC database on solaris 5.9.
I am trying to backup all the inactive archive logs from archive destination (say "/arc/") to tape(OMNIBACK) and
then to disk(say "/arch_disk").
Then delete all the archivelogs from ("/arc/*.arc") archive dest. that are just backedup.

Currently I am using the follwing script to achive this..,

rman << EOF
connect target rman/rman@mydb;
connect catalog rman/rman@mydb;
run {
allocate channel dev_1 type 'SBT_TAPE'
parms'ENV=OB2BARTYPE=Oracle8,OB2APPNAME=MYTEST,OB2BARLIST=ERSDEV_MYTEST_RMAN2)';
sql "alter system switch logfile";
backup archivelog all ;
release channel dev_1;
allocate channel dev_1 type disk
format '/u08/oradata/mdb/rmantest/%t_%s.arc';
backup archivelog all delete all input;
release channel dev_1;
}

I am not sure is it correct way of doing it.
I doubt that if there are any new archives created during the tape backup going on and it will be backed up to disk.
**can i have a script(or may be few changes in existing one) that can take the same copy of backup set both on tape and disk***
Thanks in advance.
sridhar

 vijay
Posted: Aug 24, 2006 02:32:56 AM  

 Total Post: 6
 Joined: Aug, 2006






 
How we know our hot backup is consistent.

 bond007
Posted: Oct 10, 2006 04:22:14 AM  

 Total Post: 6
 Joined: Jul, 2006






 
Hi all,

i am new to oracle.i want to take full database backup on oracle 9i. how can i do? how can i restore the database as it was before? if i restore the db, all the user permissions will be remains or i will have to assign it back. pls solve my problem ASAP. what is RMAN. since i am administrating remote oracle server, is it possible to do backup/restore from client pc using RMAN.

Thanks in advance,
Thaya

 PRANABH
Posted: Oct 16, 2006 01:31:16 AM  

 Total Post: 4
 Joined: Sep, 2006






 
I am finding reasons why in the database i am handling UNDO tablespace gets corrupted time and again so that i can rectify the
problem.

For this
1.I have shanged undo_retention parameter to 40 so
that there is not much undo retention required which
may have caused to break down of undo segments.Earlier
it was 10800.

2.I have added a datafile to undo tablespace with
autoextend on and checked parameter undo_management.It
is AUTo so that the error may not be becuse of less
undo space or expansion of undo previous datafile.

3.I have decreased fast_start_mttr_target from 300 to
50 so that checkpoint is fired after approx. so much
time and recovery time is reduced,causing less undo
utalization.

4.I am looking for any network errors which may have
caused distributed processing haults during updation
causing undo segment failures.I saw some warning
messages in windows server regarding network error.
Though if a transaction is breaked in between updation
without commit or rollback the Oracle background
processes should bring the same in consistent state
but I think that due to large updations there is some
problem with undo segments.This is under observation
and now i will be updating it under my supervision
and not by batch processing so that i can
know wether it is the root cause of problem.

Pls give your suggesions on above points.

Thanks and Regards
Pranabh


 Gaurav
Posted: Oct 16, 2006 08:06:45 AM  

 Total Post: 3
 Joined: Sep, 2006






 
Hi Everybody,
I had undergone an instructor led course for OCP (8i) several years back but i did not sit for the certification exam.Now i plan to undertake the OCP for 9i track. Can i use the already completed course as a fullfillment criteria for instructor led course for 9i track.
Any views on this from anybody??

 Noman
Posted: Dec 15, 2006 08:35:20 AM  

 Total Post: 14
 Joined: Dec, 2006






 
Dear Members,

I want to know is there any procedure to import oracle 9i DB to oracle 8i. I mean backword compatblity.

Thanks

Noman Nishat

 sathish
Posted: Jan 05, 2007 03:24:58 AM  

 Total Post: 47
 Joined: Mar, 2006






 
Good Doc on flashback

http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm

 kumar
Posted: Jan 09, 2007 03:33:39 AM  

 Total Post: 3
 Joined: Jan, 2007






 
we are using rman and policy for backup is

we are running hot backup daily
RMAN>backup database plus archivelog;
archivelog daily
RMAN>backup archivelog all;

controlfile backup is happening daily as i set
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Please suggest is this right method or needs to add something else
and cold backup we are taking on sunday without RMAN

Please suggest!

 SURESH
Posted: Jan 10, 2007 10:29:13 AM  

 Total Post: 10
 Joined: Jan, 2007






 
while exporting database schema i got error

EXP-00091: Exporting questionable statistics. error

is it error or warring plz tell that
is their any problem with that

plz tell the solution to avoid that

Thanks
suresh kumar
mail_suresh_dba@yahoo.co.in

 
Posted: Jan 18, 2007 10:34:11 AM  

 Total Post: 2
 Joined: Jan, 2007






 
Am planning to take the oracle 9i dba fund 2 (IZ0-032)paper on the 25th of this month. Can anyone send me the latest dumps to sabiuday05@yahoo.com

Thanks & appreciate your help
Sabi

 
Posted: Jan 20, 2007 07:39:55 PM  

 Total Post: 2
 Joined: Jan, 2007






 
Hi,

Am planning to take up dba fund 2 (IZ0-032) on the 25th.
Can anyone help me out with the CORRECT ANSWERS for the foll. Ques..

Thanks & appreciate your help.

1. Which phrase best describes RMAN multiplexed backup sets?

A. Stripes a single backup set across multiple channels.
B. Identical copies of backup pieces within a backup set.
C. Multiple backup sets with multiple channels configured.
D. Simultaneous reads from multiple files and writes into the same backup piece.
Answer: C

2.What does the Character Set Scanner command line utility do?

A. Reports only on any Unicode character conversions required.
B. Performs character set conversions to the new specified character set.
C. Scans on any character set conversion required, then converts the data.
D. Checks for any character definitions that will fail conversion to the new character set.
Answer: D

3. You need to import all definitions of objects belonging to the TS_EMPLOYEES
tablespace by using the export file expdat.dmp.
Which import statement is correct?

A. imp hr/hr TABLES=(ts_employees) rows=y
B. imp system/manager FROMUSER=hr file=expdat.dmp
C. imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmp
D. imp system/manager TRANSPORT_TABLESPACE=y
TABLESPACE=ts_employees
Answer: C

4. Your database runs in ARCHIVELOG mode, and is backed up every Sunday night
using RMAN scripts. On Friday your database crashes. Now you want to use the
backups from last Sunday night to restore your database. How can you do this?
A. You need to perform the restore manually, because your database was running in
ARCHIVELOG mode.
B. Issue the RECOVER command from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.
C. Issue the RESTORE and RECOVER commands from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.
D. Issue the RESTORE DATAFILES, RESTORE ARCHIVELOGS, and RECOVER
commands from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.
Answer: D

5.What is the purpose of importing from an export, and specifying that no rows be
imported and that the output goes to a log file?
A. To verify space requirements in the target database before importing.
B. To generate the SQL for the DDL operations that would occur during import.
C. To check character set compatibility between the export file and the target database.
D. To check for integrity constraint violations that would occur in the target database.
Answer: C

6. You notice that your RMAN script used to copy the datafiles, control files, and archived
redo log files is performing very slowly. Which two changes might you want to include in
your RMAN script to speed up the COPY commands? (Choose two)
A. NOCHECKSUM
B. MAXCORRUPT
C. CHECK LOGICAL
D. BACKUP INCREMENTAL
E. CONFIGURE DEVICE TYPE ... PARALLELISM
Answer: D, E

7.Assume your situation can be described as follows:
A full backup taken using RMAN is available on disk.
The current control files were NOT damaged and do not need to be restored.
All data files are damaged or lost.
The database is in NOARCHIVELOG mode.
Which RMAN command would be most appropriate to use in line 3 of the following
RMAN command set to restore and fully recover your database?
1. RMAN> STARTUP MOUNT
2. RMAN> RESTORE DATABASE;
3. RMAN> _________
4. RMAN> ALTER DATABASE OPEN;
A. RECOVER DATABASE;
B. SWITCH DATAFILE ALL;
C. RESTORE CONTROL FILE;
D. RECOVER DATABASE USING BACKUP CONTROL FILE;
Answer: D

8. Users in your production database complain that they are not able to access the data
from the CUSTOMERS table. On investigation, you find that the table is truncated
and you need to import the table using the Oracle Import utility. Which option must
you use to suppress the object creation error while importing the table?
A. LOG
B. IGNORE
C. DESTROY
D. COMPILE
E. TOID_NOVALIDATE
Answer: B

9.Which two statements are true regarding the Recovery Manager (RMAN)
CROSSCHECK command? (Choose two.)
A. It reports the statuses of the backups that are marked OBSOLETE.
B. It scans the complete RMAN repository and the contents of the backups to ensure that
both are synchronized.
C. It provides metadata information about the backups that are not yet registered in the
RMAN metadata repository.
D. It updates the metadata information of a backup to EXPIRED if the corresponding
backup is not found on the disk or media management catalog.
E. It ensures that the metadata of backups and image copies is synchronized with the
actual backups and image copies on the disk or media management catalog.
Answer:


 arshad
Posted: Jan 21, 2007 07:01:30 AM  

 Total Post: 1
 Joined: Jan, 2007






 
Hi...
this is arsahd going to attend oca exames next month
would any one plz post mock queries on sql at meraj_4u2005@yahoo.co.in
i would be thankful to U.

 ankur
Posted: Jan 22, 2007 06:11:31 AM  

 Total Post: 60
 Joined: Nov, 2006






 
I have taken hot backup of my database(Oracle9i) through Export Utility .



Now how can i restore my complete database from that export file....

I mean,Do i need to create the users/tablespaces etc....

If yes then from where can i get the comlete information about users/Tablespaces.................



 jagan
Posted: Jan 25, 2007 05:00:54 AM  

 Total Post: 2
 Joined: Dec, 2006






 
hai this is jagan.
question:can you explain the export database?but i had 50gb data in oracle when i exporting time each mount point in 20gb.3mount points.
how to export 50gb data into 3mount points.

mount point a:20gb
mount point b:20gb
mount point c:20gb
please tell to export commnad with example

 ankur
Posted: Jan 30, 2007 04:07:32 AM  

 Total Post: 60
 Joined: Nov, 2006






 
I am using Oracle9i Database.
My Database is in NOARCHIVELOG mode and this is a Testing database.

Which strategy should i follow to take backup of complete database so that minimum time and minimum Data loss occurs.


Before that i was using Export utility of whole database bus when it comes to recovery of that ,it is asking for the complete tablespace structure as well as the users info which i didnt back up while taking backup of database....


Plz tell me the solution in either case

either new Backup Strategy or recovery of whole database from complete database export

 Murtuja
Posted: Jan 30, 2007 08:30:17 AM  

 Total Post: 857
 Joined: Jan, 2006






 
Hii

I have Veritas Netbackup server on Windows 2003 and Oracle is on solaris 10.I have created oracle repository on another database.
I have generated template file using Backup wizard.then I have created policy for Oracle and try to take manual backup.But It's failed with status code 6. Please help me to troubleshoot this error
Now I want to backup Oracle Database.Can you send me script for backup.And also tell me where to save this file.
I am using Netbackup 6.0

Can you please send me detailed step by step material?

murtuja_oracle@yahoo.com

TIA

 ijd
Posted: Jan 30, 2007 09:38:38 AM  

 Total Post: 1
 Joined: Jan, 2007






 
Hi,
I have 2 servers:
server A where I've setup an Oracle database
Server B where i've installed Oracle and setup an RMAN catalog and registered the database that'srunning on Server A.

Problem i'm experiencing is that when i try to:
run{
backup database;
}
from Server B,
I get this error message:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/30/2007 06:31:57
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/30/2007 06:31:57
ORA-01580: error creating control backup file /rman/snapcf_TESTDB.f
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory

however, if i log into Server A and run RMAN locally, I am able to generate backups successfully, so this looks to me like a file-permissions issue; only thing is i cant figure out exactly what the solution is

on Server A, I have setup a password file with

remote_login_passwordfile=exclusive

From Server B, I am connecting upto Server A using the sys account (which should have all the permissions possible)...what am I missing here?

Any help would be greatly appreciated

 sudheer pai
Posted: Feb 01, 2007 10:59:59 PM  

 Total Post: 35
 Joined: Feb, 2007






 
hi dba's ..
i need an ebook on backup and recovery..
with real time problems and its solutions..


 master
Posted: Feb 03, 2007 03:28:14 AM  

 Total Post: 9
 Joined: Oct, 2006






 
Hi guys,

can any body tell me how to manually refresh materialized views,
this are all my jobs i want to refresh
QL> select job, what from dba_jobs where failures > 0;

Job WHAT
-------- ------------------------------------------------------------
1 dbms_refresh.refresh('"FROM_REP"."ADVERSE_EVENT"');
2 dbms_refresh.refresh('"FROM_REP"."MEDICATION"');
3 dbms_refresh.refresh('"FROM_REP"."SUBJECT"');
4 dbms_refresh.refresh('"FROM_REP"."DEATH"');

i want to refresh jobs, and what are all i need to check and how to do complete refresh manually. pls advice.


 nadeem
Posted: Feb 07, 2007 01:48:35 AM  

 Total Post: 15
 Joined: May, 2006






 

Hi!


someone guide me how can i recover / restore my oracle 9i database which is running in archiving mode and i want to know recovery through archiving log files.

Thanks in advance.




 nadeem
Posted: Feb 08, 2007 04:52:26 AM  

 Total Post: 15
 Joined: May, 2006






 

Dear Jayanta,

I am using Oracle 9i database on CentOS plateform as a testing server. So,I want to know that can i do the testing of dataguard / stand by on this single server?. If i can do this then tell me how can i do this?. I need standby/dataguard creation steps in Linux enviroment. Please help me.

regards,

nadeem


 sudheer pai
Posted: Feb 08, 2007 09:49:54 PM  

 Total Post: 35
 Joined: Feb, 2007






 
hi
i need a ebook with real time cenarios and case studies on backup and recovery

 nadeem
Posted: Feb 16, 2007 05:16:15 AM  

 Total Post: 15
 Joined: May, 2006






 
Dear All,

I am running an Oracle 9i database on CentOS 4.3.
Can any body tell me the exacts steps for creating standby database on same server.

Thanks and Regards

nadeem

 onkar
Posted: Mar 07, 2007 09:50:47 AM  

 Total Post: 1
 Joined: Mar, 2007






 
Hi,

I want to create sql statement in that i am calling one table via select 2 diffrent qry. i want to joint to diffrent select qry in one qry..


Kindly help me

 nar
Posted: Mar 13, 2007 03:53:56 AM  

 Total Post: 1
 Joined: Mar, 2007






 
show listener services r created to make communication possible between client and server for sharing the database;

 Tony
Posted: Mar 15, 2007 10:17:24 AM  

 Total Post: 26
 Joined: Dec, 2006






 
I was installing Oracle 10g on a linux Operating system (RHEL 3) and on successfull complete installation i realized that on the root command prompt of a user owning the database, the command SQLPLUS did not execute telling me that that is not a recognized command.

Now this happened when i specified where to install the oracle software i.e in a path with the root directory of /U01/app..... .I uninstalled the software and reinstalled it again. This time i let it installed in the default location whos directory was /home...... and on successful complete installation, i now executed the same command SQLPLUS in the same command prompt and everything was fine.

Now my question is, is there somewhere that has to be confugured to enable this executions of oracle commands. Or is the some statements has to be added to certain file in that linux machine to enable successful execution of these commands after you have specified the path except the default path where to install the oracle software?

Please if this is viable do send me a step by step procedure on how to go about it. Or if there is a path to type for that SQLPLUS command, i Do appreciate.

Please send to email address: tonygys@yahoo.co.uk

Thanks in advance



 Tony
Posted: Mar 15, 2007 10:32:26 AM  

 Total Post: 26
 Joined: Dec, 2006






 
I have a little doubt about a password.

This is how my doubts is and please help me to brush this doubt out.

When i was in school learning Oracle we were used to operate oracle using the priveldges of the SYS since every time execute execute for SQLPLUS command prompt interface we just entered as follows

"/as sysdba"

and we are in. Now how can you protect someone from performing administrative jobs with a SYS priviledge. I mean, we are supposed to enter a password for protection like as we do with other user like Scott with password tiger "Scott/Tiger". I might not be understanding well but i need a help to resolve this for me.

Please give me a step by step procedure to remove these doubt. I mainly concentrate on security in oracle database as my best prefered area.

Please send an email to address: tonygys@yahoo.co.uk

Thanks in advance.

 Tony
Posted: Mar 28, 2007 12:57:26 PM  

 Total Post: 26
 Joined: Dec, 2006






 
Hey There

I have a slight problem regarding the oracle flash recovery area. The problem is when I delete backup files from the flash recovery area and the command executes without any problem whatsoever but when I view the properties of this folder (flash recovery area) it shows that space is still being occupied.

What am I doing wrong?
tonygys@yahoo.co.uk

 Tony
Posted: Mar 28, 2007 12:58:44 PM  

 Total Post: 26
 Joined: Dec, 2006






 
Hey There

I have a slight query regarding the recovery catalogue. The question is I created a recovery catalogue and also a user to own the recovery catalogue with the required privileges I then went ahead and created a database where this catalogue was to reside. I then registered the target database to be backed up. I then logged in to RMAN using the user I had created who owned the catalogue I then specified the target database ID (dbID) and I ran my backup script but it was not successful. An error message indicating that the user was not created.

Whats the procedure in using the recovery catalogue or is the error occurring because I created a catalogue database and the target database in the same server machine?

tonygys@yahoo.co.uk

 Tony
Posted: Mar 28, 2007 12:59:49 PM  

 Total Post: 26
 Joined: Dec, 2006






 
Hey there

Does anyone know the complete path pointing to the sqlplus executable file? When you have created the database using the default location settings i.e. /home/
OR during database creation you have specified the location for the oracle software i.e. /ou1/app/product/ . I used a script to create this path

tonygys@yahoo.co.uk

 C2
Posted: Mar 29, 2007 05:33:18 AM  

 Total Post: 1
 Joined: Jun, 2006






 
Hi All,
I am Anup form Indian. I am Oracle APPS DBA working with Flex Industries.
I am working on my site www.indiandba.com. This site is dedicated to Oracle Dbas.
You can find lot of tutorials and tips related to Oracle DBA / APPS DBA.
Please visit my site and send me your comments and suggestion, which is valuable for my site and me.

Thanks
ANUP


 ajay
Posted: Mar 30, 2007 04:06:27 AM  

 Total Post: 24
 Joined: Mar, 2007






 
Dear DBA's

can anyone tell me hw to take automatic backup in oracle 9i.......is there any script....please help

 rsreddy28
Posted: Apr 01, 2007 02:55:34 PM  

 Total Post: 41
 Joined: Mar, 2007






 
Hi DBA's,

I'm working on 10g on my Linux AS4. Can somebody help me in doing an auto backp of both the cold and hot backup scripts using the CRON jobs.

Can you please send me the detailed scripts to take the Auto backup using the cron jobs to my email ID : rajreddy28@gmail.com.

Regards,

Raja

 Tony
Posted: Apr 03, 2007 07:13:16 AM  

 Total Post: 26
 Joined: Dec, 2006






 
how does one save a script to backup a database in both Red Hat Linux and windows? Please give me a number of procedures.

tonygys@yahoo.co.uk

 Tony
Posted: Apr 03, 2007 07:15:25 AM  

 Total Post: 26
 Joined: Dec, 2006






 
all The backup pieces are stored in c:\windows\system32 by default in windows. What is the default location in Red Hat Linux?

 Tony
Posted: Apr 03, 2007 07:18:30 AM  

 Total Post: 26
 Joined: Dec, 2006






 
What id the full path of sqlplus executable in Red Hat Linux. How can you grt this path If you installed oracle software in the default location i.e. /home/........

tonygys@yahoo.co.uk

 Tony
Posted: Apr 03, 2007 07:22:32 AM  

 Total Post: 26
 Joined: Dec, 2006






 
How can you ge the information about the contents of the password file e.g. as part of the information, users users who have remote passwords access.
tonygys@yahoo.co.uk

 Tony
Posted: Apr 03, 2007 07:23:04 AM  

 Total Post: 26
 Joined: Dec, 2006






 
How can you ge the information about the contents of the password file e.g. as part of the information, users users who have remote passwords access.
tonygys@yahoo.co.uk

 Tony
Posted: Apr 03, 2007 07:29:56 AM  

 Total Post: 26
 Joined: Dec, 2006






 
When using the ORAPWD utility, i understand about the other parameters associated with it.With Parameter password i have a problem with it. Is it a password to be used by all the admins who are connecting to the database remotely or what?

Please clarify for me with details.

tonygys@yahoo.co.uk

 Tony
Posted: Apr 03, 2007 07:32:34 AM  

 Total Post: 26
 Joined: Dec, 2006






 
When creating users to use the database, how do they connect to the database. Are they impacted by the password file. I mean, does the password file have an effect to them or what controls their accessibility to the database?

tonygys@yahoo.co.uk

 Tony
Posted: Apr 03, 2007 07:35:32 AM  

 Total Post: 26
 Joined: Dec, 2006






 
How do you determine the number of entries to enter in the parameter 'entries' of the database file? Is it the number od admins to have or both the admins and the non-admins?

tonygys@yahoo.co.uk

 Tony
Posted: Apr 03, 2007 07:37:48 AM  

 Total Post: 26
 Joined: Dec, 2006






 
How does the parameter REMOTE_LOGIN_PASSWORDFILE work in the init.ora file. What effects does it have on the security. Please clarify for me with details.

tonygys@yahoo.co.uk

 mit
Posted: Apr 21, 2007 04:52:12 AM  

 Total Post: 60
 Joined: Sep, 2006






 
Hi,

Please tell me how to take export for a single table.
Please send me reply on my id mitameet@gmail.com

Thanx
AMIT


 mit
Posted: Apr 22, 2007 03:29:11 AM  

 Total Post: 60
 Joined: Sep, 2006






 
Hi,

Can any one suggest what to do when all control files are lost,
please tell me what to do ,i do not have backup of control files.

Thanx
AMIT

 Swati
Posted: Apr 25, 2007 09:32:10 AM  

 Total Post: 2
 Joined: Mar, 2007






 
Hi all,

I am practising Oracle 9i Backup Recovery , can somebody suggest me script or tutorial for different types of backup/recovery especially incremental backup.

Regards,
Swati

 Muhammad
Posted: Apr 27, 2007 12:21:17 AM  

 Total Post: 2
 Joined: Mar, 2006






 
how can i import data and its associated schema into oracle 9i from Sql server?



 Neeraj
Posted: May 29, 2007 06:02:11 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
my database is on IBM\AIX linux machine. & i want to takew export backup on windows machine by windows shedular.
paramater file is working but not on shedular ,tell me how to do it.

 Ghulam
Posted: May 30, 2007 05:14:28 AM  

 Total Post: 8
 Joined: Feb, 2007






 
I got full database backup using RMAN. Being newbie I am little confused about how to recover it if there occurs instance failure as well as media failure. I think I should elaborate more as I am newbie to oracle dba.

1. I got full database backup on my CD drive. I need to install same database along with users' data on another machine.
2. I installed oracle software on my new windows 200 machine.

Now I am stuck up with how to recover my CDROM back on my new installed machine.

I home forum understand my requirement and would like to request a simple procedure to accomplish the task easily.


Note: Both the databases (Old and new) are archive log mode.

Best Regards

 puspita
Posted: Jun 07, 2007 11:19:50 PM  

 Total Post: 1
 Joined: Jun, 2007






 
While trying to connect with RMAN , the error message is coming as
" unknown command 'rman' - rest of line ignored ".

please help at your earliest to solve the problem.

 KS
Posted: Jun 20, 2007 11:19:27 AM  

 Total Post: 67
 Joined: Nov, 2006






 
Hi,

Try this,

Configure the Tns entry of the Database (Linux box) in Windows.
then take the backup.

Note : Assumed that Oracle Client installed on your Windows Box


-Sri



 Billy
Posted: Jun 24, 2007 04:48:10 PM  

 Total Post: 8
 Joined: Jun, 2007






 
How can I Perform Backup and Recovery through RMAN, I Need Scripts or Detail Information abt how to Take a Backup from RMAN.

 santhosh
Posted: Jul 23, 2007 05:17:33 PM  

 Total Post: 3
 Joined: Oct, 2005






 
hi everybody
i cloned the database. i tar all the files from source database when i untar the database in destination one file size is very less
example while tar the sa.dbf size 10 gb. while untar the it shows the size is 9.5 dbf. my database is in no archieve log mode. what isthe solution


Note: tar is one of linux command it zip all files






 asif
Posted: Jul 25, 2007 03:45:17 AM  

 Total Post: 4
 Joined: Jul, 2007






 
Hi All,

I am in crisis by taking to the printer through Oracle11i Application. On the server, HP-Lj4250 printer is installed. From the server, normal printing is ok but when I am trying to print through Oracle11i App, it is not printing even I took the printing option as --Pasta Universal Printer but nothing is printing.

Can anyone provide the best solution for the above thread.


 parveez
Posted: Aug 04, 2007 01:49:45 PM  

 Total Post: 38
 Joined: Aug, 2007






 
Hi,
I took backup of the database.Now a bought a new server and installed oracle 9i.I installed the backup as well.Now if the clients of this new server wants to enter data through a old front end which was designed for the old server of oracle 9i then how will i link up the new server to that front end.I mean both the old server and the new server are having oracle 9i installed.i took backup of the old server and installed in the new server.Now will i have to do with the database to link up the old front end.

 pandu
Posted: Aug 11, 2007 05:34:57 AM  

 Total Post: 7
 Joined: Aug, 2007






 
Hi,My database is in non archive log mode. I have the backup of all the datafiles, control files and redologs (cold backup). while my instance is running and when i entered some data into a table which is on a particular datafile which is lost physically by some mistake. i issued commit after entering data. when i tried to shut down normally i'm getting
error saying that unable to open the datafile.when i shut the instance forcefully(shut abort) and copied the lost datafile from backup to original location and tried to start the instance media recovery error is coming.what to do in this situation. please help me in his situation.
Thanks in advance
kvl narayana

 pandu
Posted: Aug 11, 2007 04:21:07 PM  

 Total Post: 7
 Joined: Aug, 2007






 
Hi,My database is in no archive log mode. and i have 2 groups of redologs with 2 members each. If all the members of 2 groups are missing how to restore my database.I have a backup of all data files and control files.They are safe. Please help me.
Thanks in advance,
KVL Narayana

 pandu
Posted: Aug 12, 2007 03:28:39 PM  

 Total Post: 7
 Joined: Aug, 2007






 
Hi, what is default of segment space management in 9i& and 10g.please help me.
Thanx in advance,
KVL Narayana

 pandu
Posted: Aug 12, 2007 03:33:27 PM  

 Total Post: 7
 Joined: Aug, 2007






 
Hi,My database is in archive log mode and is opened. i put a tablespace in offline mode and when trying to bring it online im getting media recovery error. what might be the problem?
Thankx in advance,
KVL Narayana

 msagnier
Posted: Aug 13, 2007 09:55:03 AM  

 Total Post: 1
 Joined: Aug, 2007






 
Hello,

I ask you some help because Oracle Support didn't give me a solution.

I'm currently work for a client to migrate his E-Businness Suite 11.5.8 to 11.5.10.2 (with database migration from 9.2.0.4 to 9.2.0.8).
During Maintenance Pack, a standard script fails with corrupted block message (on system01.dbf).

After stoped the DB, I'm running dbverify to check all datafiles and it appears that the tablspace SYSTEM have 4 corrupted blocks : 2 on system01.dbf, 1 on system02.dbf and 1 on system08.dbf.

Impacted objects are :
SOURCE$ (table)
IDL_UB1$ (table)
IDL_UB2$ (table)
I_SOURCE1 (index)

I try to apply the Oracle note 68013.1 and use th e package DBMS_REPAIR, successfully (blocks skiped and index drop/recreate) :

SQL> select owner, table_name from dba_tables where skip_corrupt= 'ENABLED';

OWNER TABLE_NAME
------- -------------------
SYS SOURCE$
SYS IDL_UB1$
SYS IDL_UB2$

But the script OKLPTAIB.pls doesn't work with again the same message :
CREATE OR REPLACE PACKAGE BODY OKL_TRX_AR_INVOICES_PUB AS
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 64623)
ORA-01110: data file 1: '/gaprod/gaproddata/sys/system01.dbf'

and alert.log file contains the same corruption messages.

Moreover, I can't recover the database because there are no backups without these corrupted blocks, I've already try to clone them but corrupted blocks re-appear, even on an other host destination...

Maybe somebody has a solution for me ?

Thanks a lot.

 Navi
Posted: Aug 21, 2007 10:13:03 AM  

 Total Post: 60
 Joined: Jun, 2007






 
Hi,
I got stuck up when i was doing recovery. Please help me.
I took backup of all the datafiles,redogfiles and controlfiles.
I opened the database and created table called student. After that I inserted values to it and purposely made log switch. So that when alter database recover command is given it should prompt the archive log file.

insert into student values(101);
alter system switch logfile;
insert into student values(102);
alter system switch logfile;
insert into student values(103);
alter system switch logfile;
Three Archived log files got generated:-
1) ARC00001.001 2) ARC00002.001 3) ARC00003.001

After that I shutdown the database and opened the database and I got the following error:-
SQL> startup;
ORACLE instance started.

Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted.

ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\KARTHIK\NAVDBF.DBF'

After that I restored the datafile to its original location and when I gave alter database recover command I got the following error:-

SQL> alter database recover;
alter database recover
*
ERROR at line 1:
ORA-00279: change 271469 generated at 08/21/2007 18:05:51 needed for thread 1
ORA-00289: suggestion: C:\ORACLE\ADMIN\KARTHIK\ARCH\ARC00001.001
ORA-00280: change 271469 for thread 1 is in sequence #1

After that I gave the archived log name as follows and I got following error:-
SQL> ARC00001.001
SP2-0734: unknown command beginning "ARC00001.0..." - rest of line ignored.

What should I enter when it prompts for Archive files? Please guide me.

Regards,
Naveen


 Navi
Posted: Aug 22, 2007 01:14:14 PM  

 Total Post: 60
 Joined: Jun, 2007






 
Hi,
I got stuck up when i was doing recovery. Please help me.
I opened the database in noarchivelog mode and inserted 5 records and made logswitch purposely but I dint gave any DML statements so that SYSTEM datafile gets affected. After that I shutdown the database and before starting the database I corrupted the datafile for which I inseted the records but I dint corrupt SYSTEM file.

After that when I tried to start the database I got the following error:-
SQL> startup;
ORACLE instance started.

Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted.

ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\KARTHIK\NAVDBF.DBF'

After that I restored the datafile to its original location and since I had started the database in noarchive mode I gave the following command:-
ALTER DATABASE RECOVER UNTIL CANCEL;

After that it gave
Warning: RECOVER succeeded but must use RESETLOGS or NORESETLOGS option for database open

After that I gave following command:-
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\KARTHIK\SYSTEM01.DBF'

But I dint gave any DML statements so that SYSTEM datafile gets affected when database was up and running in noarchivelog mode before recovery.

Please guide me.

Regards,
Naveen


 jothi
Posted: Aug 22, 2007 02:22:50 PM  

 Total Post: 33
 Joined: Aug, 2007






 
Can any one explain me abt the Export & Imports parameters
1)Consistent
2)STATISTICS
3)RESUMABLE
4)RESUMABLE_NAME
5)RESUMABLE_TIMEOUT
6)COMPILE
7)STREAMS_CONFIGURATION
8)STREAMS_INSTANITATION
Thanks, in advance

 Navi
Posted: Aug 23, 2007 01:38:24 PM  

 Total Post: 60
 Joined: Jun, 2007






 
Hi,
I started the database in ArchiveLog mode and i took a datafile offline after that when i tried to take datafile online it gave following error:-

SQL> alter database datafile 'C:\oracle\oradata\Venkat\navdbf.dbf' online;
alter database datafile 'C:\oracle\oradata\Venkat\navdbf.dbf' online
*
ERROR at line 1:
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\VENKAT\NAVDBF.DBF'

After that when i gave "recover database" command i got the following error:-

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\VENKAT\SYSTEM01.DBF'

Before taking datafile offline i dint took any backup and when it asked for media recover i dint had any backup to restore just i gave
"RECOVER DATABASE"

1) Before taking Datafile or tablespace offline whether i need to take backup of all the files?
2) Why i am getting this error? Just i took datafile from offline to online?
Please guide me.

Regards,
Naveen





 jitender
Posted: Aug 24, 2007 12:15:51 AM  

 Total Post: 1
 Joined: Aug, 2007






 
We have got oracle 9i on linux. Our database is having three control files control01.ctl,control02.ctl, control03.ctl. In morning, when we checked the system, oracle is not starting. It is giving error message error in reading control file control02.ctl. As per Oracle documentation, we copied control03.ctl to control02.ctl, we also commented the control02.ctl line in our init.ora file. We cannot copy this control02.ctl file also.
When we run the oracle service, it is showing the error, ora-00333. What is this. We want to take the backup of our data, it is very important, it is showing the error oracle initalization or shutdown in progress. Same is coming for sqlplus.
What to do ?
Help, it is urgent..

 rk
Posted: Aug 25, 2007 01:23:56 AM  

 Total Post: 17
 Joined: Aug, 2007






 
Hi,

while taking cold and hot backup, which are the optional files ?

regrds
ram

 Navi
Posted: Aug 26, 2007 07:48:03 AM  

 Total Post: 60
 Joined: Jun, 2007






 
Hi,

When database gets started how can we know instance recovery has taken place?

Regards,
Naveen

 Navi
Posted: Aug 29, 2007 01:57:23 PM  

 Total Post: 60
 Joined: Jun, 2007






 
Hi,

I have created a table by name "Student".

SQL> select * from Student;

ID City
---------- ----------
301 Bangalore
302 Mangalore
303 Bangalore
304 Mysore
305 Bangalore


I am using Parameter file and i am trying to export only who are living in "Bangalore" to a dump file and the parameter file contains following parameters:-

File=F:\Backup_Venkat\Extonly.dmp
tables=nav.descrp
query=select * from Student where City='Bangalore'

But when i type the following command i am getting errors:-

C:\>exp nav/aaa parfile=F:\Backup_Venkat\Extonly.dmp
LRM-00112: multiple values not allowed for parameter 'query'
LRM-00113: error when processing file 'F:\Backup_Venkat\Extonly.dmp'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

Please guide me.

Regards,
Naveen

 Navi
Posted: Aug 30, 2007 07:25:51 AM  

 Total Post: 60
 Joined: Jun, 2007






 
Hi,

I am studying Backup and Recovery I am doing user-managed Backup and Recovery since i have not yet learnt RMAN.

My database is running in Archive Log mode and i have all the archives.
I came across a scenario of "Recreating DATAFILE" and deleted one non-system datafile and i tried this command:-

Alter database create datafile 'C:\ORACLE\ORADATA\VENKAT\Nav01.DBF';

It worked, but i deleted SYSTEM datafile purposely and when i tried to recreate it gave error:-

SQL> Alter database create datafile 'C:\ORACLE\ORADATA\VENKAT\SYSTEM01.DBF';
alter database create datafile 'C:\ORACLE\ORADATA\VENKAT\SYSTEM01.DBF'
*
ERROR at line 1:
ORA-01180: can not create datafile 1
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\VENKAT\SYSTEM01.DBF'

Question:-
1) I searched on net and i came to know we cannot recreate SYSTEM datafile but i was not able to get information why we cannot recreate SYSTEM datafile but only we can recreate Non-SYSTEM datafile.
2) What should be my next step to solve this problem.

Please guide me.

Regards,
Naveen

 rk
Posted: Aug 31, 2007 07:55:34 AM  

 Total Post: 17
 Joined: Aug, 2007






 

How to perform Instance Recovery ? plz give me syntax

 Neeraj
Posted: Aug 31, 2007 08:13:22 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
as per my knowlage i can take export backup of full database & backup of some files.
but can anybody tell me how to take backup of all database(300 tables ) but want to avoid backup of some tables.
send me script if its possible.
thxs

 sai
Posted: Sep 02, 2007 05:42:48 AM  

 Total Post: 14
 Joined: May, 2007






 
What is the difference between coldbackup and level 0 backup?

 sai
Posted: Sep 02, 2007 05:43:51 AM  

 Total Post: 14
 Joined: May, 2007






 
What is name of controlfile in RMAN backup?

 sai
Posted: Sep 02, 2007 05:46:02 AM  

 Total Post: 14
 Joined: May, 2007






 
Suppose if i have more than 50 tablespaces, three of them were in backup mode and my server got crashed. When the server came up i have to bring my database up, what is the approach?

 sai
Posted: Sep 02, 2007 05:48:30 AM  

 Total Post: 14
 Joined: May, 2007






 
I have 100 datafiles with me i forgot to copy one datafile and tried to open the database using cmd ALTER DATABASE OPEN RESETLOGS! How would you go about bringing the database up?

 rahul
Posted: Sep 08, 2007 11:44:51 AM  

 Total Post: 16
 Joined: Feb, 2007






 
Dear Friends

Please Tell me that question answer-

Suppose A data file is lost and our database is in Archive log made we perform User Managed Recovery and check the status of Deleted datafile that offline , and simple restore the datafile from previous cold backup and simply give RECOVER DATAFILE command , but any one tell me when our datafile is in offline mode how can oracle server applied online redolog and archive log files. because when our datafile is in offline mode we can't perform any operation on that .


so please tell me the actual background process ...............


thnaks



 Vikas
Posted: Sep 17, 2007 12:24:38 AM  

 Total Post: 1
 Joined: Aug, 2007






 
When we take the tablespace in backupmode why more redos are genereated?


 indra
Posted: Sep 17, 2007 05:13:57 AM  

 Total Post: 26
 Joined: Jan, 2007






 
DEAR FRIENDS,
I HAVE TAKEN A RMAN BACKUP OF MY DATABASE WHILE IT WAS OPEN BY WRITING THE CODE
run
{
allocate channel c1 type disk;
backup database format 'db_%u_%d_%s';
release channel c1;
}

BUT WHILE I AM TRYING TO RESTORE AND RECOVER THE DATABASE WHILE IT IS OPEN USING RMAN IT IS GETTING FAILED.THE DATABASE IS IN ARCHIVE LOG MODE.
PLEASE HELP.WHAT SHOULD I DO?


 Tony
Posted: Sep 18, 2007 08:43:43 AM  

 Total Post: 26
 Joined: Dec, 2006






 
Hi, i have a little proble about the password file. It have made my database to be in mess in that, i cannot open my database.

This is what happened. Am running oracle on a linux operating system. I tried to open the enterprise manager console and tried to login as normal i.e username: sys, Password: Oracle, as a SYSDBA. It was doing well before. This time its not opening. I try to start it up using that the console and on logging in it refuses.

NB: When in command prompt the database is opening very well and everything is running as usual. I understand that the console uses the password file for authentication and so i decided to shutdown the database and recreate the password file using the orapwd utility and it execute very in the same location where it was and the same name.

Now here comes the mess, that even the database that was running in the command prompt is no longer running and now giving an error that the database cannot be opened due to an invalid password file.

Remember my oracleSID is traindb and the owner is user ORACLE with password ORACLE. I have never recreated the password file before. It was in its default form.
Whaen i recreated it i specified the number of entries being 20 and the password as syspass and now the file to the exact location with the same name as it was.

What should i do. Pliz with all your kind assist.

Thanks in advance.


 jothi
Posted: Oct 04, 2007 02:47:22 PM  

 Total Post: 33
 Joined: Aug, 2007






 
Iam working in Oracle9i on windows.After a media failure i recovered the database with resetlogs.After 2 days again i lost one datafile.But i dont have backup of my database after issuing resetlogs.How can i recover my database.
Thanks in advance

 indra
Posted: Oct 09, 2007 11:53:43 AM  

 Total Post: 26
 Joined: Jan, 2007






 
HI,
I WANT TO KNOW WHAT TYPE OF CHANGES DOES AN ONLINE REDO LOG FILE RECORD?
ARE CHANGES DUE TO INSERTION OF NEW DATA,UPDATION OF EXISTING DATA ARE RECORDED IN THE REDO LOG FILES?

 rahul
Posted: Oct 10, 2007 12:07:59 PM  

 Total Post: 16
 Joined: Feb, 2007






 
Dear Friends

i have a question related to backup . if any one know the answer of this question then please give reply soon.

Q1 :- Can we take Incremental Logical Backup? Yes or No , If Yes then how ?

I waited for soon reply.


thanks
amit kumar bhatnagar


 Neeraj
Posted: Oct 17, 2007 01:13:04 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
i have arround 400 tables & i dont have enough space to run my database on archive mode .
so i want to take incremental backup of arround 10 tables no full tables.
so tell me how can i take incremental backup only linited tables in tha database.
is it possible ?

if yes so plz wreite me complete script & process

 raj
Posted: Oct 17, 2007 07:52:00 AM  

 Total Post: 15
 Joined: Aug, 2007






 

hi,
im doing rman im trying drop my catalog im not able to drop my catalog
im geting some errors



RMAN> drop catalog;

error occurred in source file: krmk.pc, line: 7176
text of failing SQL statement: @
ORACLE error from recovery catalog database: ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty

error occurred in source file: krmk.pc, line: 7176
text of failing SQL statement: @
ORACLE error from recovery catalog database: ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06434: some errors occurred while removing recovery catalog


 chinna
Posted: Oct 18, 2007 12:16:03 AM  

 Total Post: 28
 Joined: May, 2007






 
hi friends,

this procedure contains the dynamic creation of table and inserting data through a dynamic procedure.
when i compile it is giving no errors
but when i am executing it it is giving insufficent privileges.

CREATE OR REPLACE PROCEDURE EXECPROC
AS
VSQLSTMT VARCHAR2(4000);
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE SAMPLE1(VNO1 NUMBER,VNO2 NUMBER)';
VSQLSTMT := 'CREATE OR REPLACE PROCEDURE SAMPLE1
AS
BEGIN
INSERT INTO SAMPLE1 VALUES(12,''SRAWAN'');
INSERT INTO SAMPLE1 VALUES(26,''SKUMAR'');
END;';
EXECUTE IMMEDIATE VSQLSTMT;

END;

looking forward for reply....

Thanks & Regards
srawan

 nick
Posted: Oct 18, 2007 04:49:20 PM  

 Total Post: 30
 Joined: Sep, 2007






 
The client has sent us one .dmp file which has the complete database backup. We know that the username was admin and we have password for it.
The version of oracle being used was 9i and here we are using 10.2.0.
We have created a database using DBCA and wish to recover the database.

Command ran....
c:/> imp <system/pwd> file ='path' full = y

got an error that : Import terminated successfully with warnings.

suggest/...

 csf
Posted: Oct 20, 2007 08:06:36 AM  

 Total Post: 1
 Joined: Feb, 2007






 
I am using Oralce10gR2 on windows2003, I have setup a standalone serverTEST it works fine with all the default setups & configuration.
EM also works fine, db in Archivelog, Ram works, able to connect from remote as well.

Now since this is a test server, I have restored the proddb datafiles(system,sysaux,user,temp),controlfile,pfile I able to create a copy of the proddb and it works well except for the EM console.

I have lost the Enterprise Manager can anyone guide me how to restore without losing Enterprise Manager.

Thanks.



 Neeraj
Posted: Oct 24, 2007 08:09:58 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
i m working on oracle 10g , but when i shutdown my database with command "SHUTDOWN IMMEDIATE" it gets down properly but when i want to up my my databse with commant "STARTUP" i get error
ORA-01041:INTERNAL ERROR.HOSTDEF EXTENSION DOESNT EXIST
but it gets start when i restart my server.

so tell me wts the problem w/ it & how can i solve it permanantly.bcoz i dont want to restart my machine again & again.
thxs

 santhanam
Posted: Nov 02, 2007 01:35:26 PM  

 Total Post: 13
 Joined: Nov, 2007






 
can anyone of u explain recovery using hot backup,
oracle 8i & windows NT
NOT A 24/7 DATABASE

 vikas
Posted: Nov 05, 2007 07:03:08 AM  

 Total Post: 5
 Joined: Aug, 2007






 
Hi,

while opening the database I am getting following error message

ORA-01092: ORACLE instance terminated. Disconnection forced

after analyzing alert file found below error message

ORA-30012: undo tablespace 'UNDO' does not exist or of wrong type.

How should I check the same.

In pfile undo parameter is set to undo_tablespace=UNDO

please help me resove this issue.

Thanks in advance.

Regards,

Vikas J

 rsreddy28
Posted: Nov 05, 2007 09:47:53 AM  

 Total Post: 41
 Joined: Mar, 2007






 
Hello Sir,

This is Raj from Hyd, India.Actually I;m trying to write a shell script using SQL.But when I'm setting up a crontab , all that is going to
/var/spool/mail/rsreddy.

Actually what I'm looking is , I want to run any SQL command at the linux level and that too with a crontab.

So, can you please help me out.

--
Cheers,

Rajasekhar Reddy.A

 jimroy
Posted: Nov 07, 2007 12:18:32 AM  

 Total Post: 2
 Joined: Nov, 2007






 
Hi,

I am new to Oracle so be patient please.
I am trying to restore a database, but unfortunately the former dba did not backup the redo log files. I have all the files except the redo ones.
Is it possible to still restore the database?

Thanks,
Jim

 Sanjay
Posted: Dec 03, 2007 04:50:43 PM  

 Total Post: 3
 Joined: Feb, 2007






 
Hi All,

I am relatively new to Oracle and now I have to devise a strategy for backups and recovery. My objective is to backup the production database regularly in such a way that one month down the line I am able to load it on another instance. I have been trying to read up on the subject, but looks like it can be loaded only on the same instance.
Any thoughts how can this be achieved.

Thanks
Sanjay

 Neeraj
Posted: Dec 05, 2007 12:02:28 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
i hav set up a job sheduling on windows 2000 using bat file , it starts at 2 am ,it runs all the day ,but i want to stop it at 1 am then again starts 2 am .
so is ther any facility on windows to set its time, or i hav to use bat file.


 Neeraj
Posted: Dec 11, 2007 12:43:46 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
i want to take export backup but want to avoid a particular user , so is it possible.if yes so tell me about the process & script

 jothi
Posted: Dec 15, 2007 12:51:40 PM  

 Total Post: 33
 Joined: Aug, 2007






 
hi,
I have exported a table from one database(oracle 9i).It is possible to import that table to one particular tablespace.


 ramesh
Posted: Dec 26, 2007 08:36:49 AM  

 Total Post: 82
 Joined: Dec, 2006






 
i use import/export utility for daily backup.
and i found that some synonyms are missing from the backup,using the direct path.
what might be the problem..?
should i use the conventional path.?

help me..
..ramesh

 ramesh
Posted: Dec 27, 2007 04:41:55 AM  

 Total Post: 82
 Joined: Dec, 2006






 
we hav databases located in different states.
in which 2 databases the dmp file size created with import/export
is 8 GB each.

but the backup time taken in one is 1hr while other takes nearly 175 mins.
i hav checked the configurations they are nearly same.(P4 with 512 RAM)

how can i over come the backup time.

..ramesh


 indra
Posted: Dec 28, 2007 02:20:09 AM  

 Total Post: 26
 Joined: Jan, 2007






 
Can anyone please explain Block Recovery in oracle 9i and how to do it?

 vikas
Posted: Dec 28, 2007 02:23:57 AM  

 Total Post: 5
 Joined: Aug, 2007






 
Hi All,

I am receiving follwoing error in alert log

ARC0: Media recovery disabled

please suugest how to resolve the same.

Thanks in advance.

Regards,

VJ




 ramesh
Posted: Dec 28, 2007 08:12:02 AM  

 Total Post: 82
 Joined: Dec, 2006






 
In Export utility at user mode

does it export the synonyms which are only public.?

..ramesh

 ramesh
Posted: Jan 01, 2008 06:17:08 AM  

 Total Post: 82
 Joined: Dec, 2006






 
I hav a table which contains historical data,
and is not needed frequently, but is important
i contains some 21540894 rows which consists data from last 12 years.
so dont want to hav all the data in the backup,
so can i store this table in seperate tablespace(datafile) and hav the copy on the pc. and take a copy of it,

all i want to do is that i dont want such a big table in daily backup bcos it consumes a lot of time.
i use the imp/exp utility.

can anyone help me.

..ramesh

 Vish
Posted: Jan 01, 2008 07:35:25 AM  

 Total Post: 414
 Joined: Jan, 2007






 
I want trying import export though .ini file paramenter.
can any one help me how to do? Giving step by step


 Kunal
Posted: Jan 02, 2008 06:44:56 AM  

 Total Post: 2
 Joined: Jul, 2007






 
Hi,

I have a .dmp file placed in my c: and i wanted to use the "imp" utility to import it to a newly created 10g XE database.

I wrote the following lines on the SQL command prompt

SQL>connect system/oracle
SQL>imp system/oracle file=c:\master.dmp full=y log=imp.log

However this command fails and prompts an error SP2-734. (i tried the same on the web interface, and get the ora-900 error)

I guess, i am going wrong in accessing the path (c:\master.dmp).

Can anyone please advise me on the same.

Regards,

Kunal


 vikhardba
Posted: Jan 04, 2008 12:11:37 AM  

 Total Post: 124
 Joined: Apr, 2007






 
Hi to One and All,

Installed Oracle 10g on Win 2003 server.
version : 10.2.0.1.0

Can anyone let me know how to take full database cold backup on windows 2003. Also please let me know how to set job scheduler specific for taking database backup.

I also know the location of C/R/D and Archive files, but don't know how to set scheduler for taking this backup.

Regards,
Vikhardba

 ramesh
Posted: Jan 07, 2008 12:09:11 AM  

 Total Post: 82
 Joined: Dec, 2006






 
can anyone help me
i hav found this problem many a times, i hav enough of space in the disk then too,

. . exporting table TAXMETHOD 3 rows exported
. . exporting table TAXRATE 55414 rows exported
. . exporting table TAXSET 55420 rows exported
. . exporting table TAXTRAN
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully


 vishal
Posted: Jan 09, 2008 04:53:00 AM  

 Total Post: 7
 Joined: Jan, 2008






 
hi all
i am takin export of a owner and getting this error.


EXP-00008: ORACLE error 4020 encountered
ORA-04020: deadlock detected while trying to lock object SYS.CDC_ALTER_CTABLE_BEFORE
EXP-00000: Export terminated unsuccessfully


what steps should i take?

 viral
Posted: Jan 09, 2008 08:19:14 AM  

 Total Post: 8
 Joined: Jun, 2007






 
hii everyone..
here im facing a very serious problem wid my control files... my files are lost... then how to recover it.. i hav no bckup.......
seekin for the best n satisfied answer....

......urs friendly.....
bye....

 viral
Posted: Jan 11, 2008 06:48:15 AM  

 Total Post: 8
 Joined: Jun, 2007






 
hii every one....
im facing problem in importing n exporting tablespaces....& database...
kindly.. help me out.. with proper commands..
hoping for the best...answers...

bye....

 vikhardba
Posted: Jan 11, 2008 10:23:55 AM  

 Total Post: 124
 Joined: Apr, 2007






 
Can anyone give me complete information about different parameters used in exp and imp or any web link?

In-short i would like to know the mechanism of all the parameters.

For example:
------------
exp scott/tiger file=exp1.dmp log=exp1.log direct=y compress=y consistent=n buffer=102354

imp scott/tiger file=exp1.dmp show=y fromuser=a touser=b

So likewise they are many parameters which can be known using c:\>exp help=y and imp help=y

Anticipating your response at the earliest!!
Regards,
Vikhar

 rachit
Posted: Jan 11, 2008 11:44:35 AM  

 Total Post: 5
 Joined: Nov, 2007






 
Actually i am gettin errors in the SQL2000 saying could not find the worker thread.
How can i solve this issue and what can be the effects of increasing the max worker threads ????

 seema
Posted: Jan 12, 2008 01:42:15 AM  

 Total Post: 83
 Joined: Jan, 2008






 
Please tell me how to export full database and how to import the same.
Kindly send me procedure.



 vikhardba
Posted: Jan 12, 2008 05:02:05 AM  

 Total Post: 124
 Joined: Apr, 2007






 


One question - while export is going on at schema/tablespace/objects/row level, how and where should i check "How much of time is required to exp/imp db/tablespace" and also "How much of time is left to complete the exp/imp task"


Do we check in v$session view. Can you please give me complete query.

 ramesh
Posted: Jan 14, 2008 02:30:34 AM  

 Total Post: 82
 Joined: Dec, 2006






 
how can i get the information
data, time and time required for the export.

can we set it in the log file
how..??
.ramesh




 seema
Posted: Jan 15, 2008 05:46:42 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How to use isqlplus?

 seema
Posted: Jan 17, 2008 02:32:20 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How to get pl/sql book from internet.

 sus
Posted: Jan 18, 2008 12:15:04 AM  

 Total Post: 3
 Joined: Jan, 2008






 
Hi all,


I am using oracle 9i in solaris 8.
I have two servers one target(dol) and one catalog(acrab).
I want to take backup of target by using catalog.
My question is can give the backup destinations of the backupsets in catalog server.
When i am doing the same it shows error that 'no such file or directory'

plz suggest me

Regards,
Susheel



 sus
Posted: Jan 19, 2008 12:36:46 AM  

 Total Post: 3
 Joined: Jan, 2008






 
Hi all,

I am using oracle 9i in solaris 8.
I have two servers one catalog and one target.
During configuration of RMAN(with catalog) I had given a wrong path for snapshot controlfile.
It was showing error that no such file or directory.
When I am trying to reconfigure it with a valid path I am getting following error.
It is connecting to target database without any problem.
Every command in RMAN prompt shows the similar error.
Plz suggest me how to reconfigure it.



RMAN> crosscheck backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 01/19/2008 09:29:10
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/19/2008 09:2 9:10
ORA-01580: error creating control backup file /disk1/oradata/rman/rman_bkup/dolp hin/snapcf_dolphin.f
ORA-27040: file create error, unable to create file
Error: 2: No such file or directory

RMAN> show all
2> ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/19/2008 09:45:25
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/19/2008 09:4 5:25
ORA-01580: error creating control backup file /disk1/oradata/rman/rman_bkup/dolp hin/snapcf_dolphin.f
ORA-27040: file create error, unable to create file
Error: 2: No such file or directory

RMAN> report need backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/19/2008 09:54:14
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/19/2008 09:5 4:14
ORA-01580: error creating control backup file /disk1/oradata/rman/rman_bkup/dolp hin/snapcf_dolphin.f
ORA-27040: file create error, unable to create file
Error: 2: No such file or directory


Regards
Susheel

 sus
Posted: Jan 19, 2008 12:39:54 AM  

 Total Post: 3
 Joined: Jan, 2008






 
Hi all,

I am using oracle 9i in solaris 8.
I have two servers one catalog and one target.
During configuration of RMAN(with catalog) I had given a wrong path for snapshot controlfile.
It was showing error that no such file or directory.
When I am trying to reconfigure it with a valid path I am getting following error.
It is connecting to target database without any problem.
Every command in RMAN prompt shows the similar error.
Plz suggest me how to reconfigure it.



RMAN> crosscheck backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 01/19/2008 09:29:10
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/19/2008 09:2 9:10
ORA-01580: error creating control backup file /disk1/oradata/rman/rman_bkup/dolp hin/snapcf_dolphin.f
ORA-27040: file create error, unable to create file
Error: 2: No such file or directory

RMAN> show all
2> ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/19/2008 09:45:25
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/19/2008 09:4 5:25
ORA-01580: error creating control backup file /disk1/oradata/rman/rman_bkup/dolp hin/snapcf_dolphin.f
ORA-27040: file create error, unable to create file
Error: 2: No such file or directory

RMAN> report need backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/19/2008 09:54:14
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/19/2008 09:5 4:14
ORA-01580: error creating control backup file /disk1/oradata/rman/rman_bkup/dolp hin/snapcf_dolphin.f
ORA-27040: file create error, unable to create file
Error: 2: No such file or directory


Regards
Susheel

 CN
Posted: Jan 19, 2008 09:30:07 AM  

 Total Post: 12
 Joined: Jul, 2007






 
pls anyone suggest me what are the procedure of statement tuning in oracle 9i & what will we do if block curruption found in database ?

 ramesh
Posted: Jan 20, 2008 11:58:45 PM  

 Total Post: 82
 Joined: Dec, 2006






 
Hi..mohammed no "date" variable found in the imp/exp utility..

 ram
Posted: Jan 22, 2008 02:44:33 AM  

 Total Post: 5
 Joined: Jan, 2008






 
hi GUYS,

I HAD DONE HASH PARTITIONING FOR MY TABLES IN MY DATABASE AND WHEN I RUN THE QUERIES IT IS USING FULL TABLE SCAN INSTEAD OF INDEXES.


CAN ANYBODY HELP ME OUT IT'S URGENT.

 ramesh
Posted: Jan 24, 2008 12:45:25 AM  

 Total Post: 82
 Joined: Dec, 2006






 
i'm using oracle on linux and having some 4-5 clients with XP.
when ever i try to use export usermode it takes 90 mins in server,
and when i tried it from the client it takes only 40.
what might be the logic behind this..
now i user the export form the client.

help me..

 Ajith
Posted: Jan 24, 2008 10:00:10 AM  

 Total Post: 4
 Joined: Jan, 2008






 
Hi,

I'm getting the message "Checkpoint not complete" in the alert log of my database ,could somebody explain the reason for this plz
Thread 1 advanced to log sequence 248
Current log# 2 seq# 248 mem# 0: /ajith/oradata/logs/redologs02.log
Thread 1 cannot allocate new log, sequence 249
Checkpoint not complete

Regards,
Ajith

 seema
Posted: Jan 25, 2008 05:22:15 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How to deallocate channel in RMAN?

 shilpa
Posted: Feb 13, 2008 04:29:24 AM  

 Total Post: 6
 Joined: Feb, 2008






 
what are the steps for database cloning???

 joshi
Posted: Feb 16, 2008 08:17:21 AM  

 Total Post: 24
 Joined: Apr, 2007






 
I HAVE TABLESPACE XXX.BUT PRESENT TIME I HAVE NOT XXX TABLESPACE .BUT MY DATABASE START. WHEN I WRITE SELECT NAME FROM V$TABLESPACE .THEN IT SEEN XXX MY TABLESPECE .

 seema
Posted: Feb 19, 2008 11:18:55 PM  

 Total Post: 83
 Joined: Jan, 2008






 
Please help me..............

I need latest dump for backup and recovery(f2) paper in oracle 9i.

thank you



 seema
Posted: Feb 20, 2008 05:12:52 AM  

 Total Post: 83
 Joined: Jan, 2008






 
Please help me..............

I need latest dump for backup and recovery (f2) paper.

my eMail id is seemahasp@yahoo.co.in

 
Posted: Feb 21, 2008 05:16:50 AM  

 Total Post: 46
 Joined: Sep, 2007






 
Hi all,

i had more 20 tables in my database, but i deleted 3 tables yesterday.how i will recover those 3 tables using RMAN.


 
Posted: Feb 21, 2008 05:20:23 AM  

 Total Post: 46
 Joined: Sep, 2007






 
Hi all
my oracle version is oracle 9i. I deleted some rows from a particular table and commited it.
Now i want to retrieve those datas after some days which includes several shutdown of the server machine.

can i able to recover those data?

Thanks in advance

 
Posted: Feb 22, 2008 12:10:49 AM  

 Total Post: 46
 Joined: Sep, 2007






 
Hi all,

while i m taking the user managed hot backup ,i write the sysntax

SQL>ALTER TABLESPACE X BEGIN BACKUP

SQL>HOST COPY c:\...dbf d:\...dbf

SQL>ALTER TABLESPACE X END BACKUP

but my question is that, what is the actual meaning of the
1. ALTER TABLESPACE X BEGIN BACKUP?
2. ALTER TABLESPACE X END BACKUP?

plz tell me as soon as possible.

 CN
Posted: Feb 23, 2008 09:25:40 AM  

 Total Post: 12
 Joined: Jul, 2007






 
pls any one tell me what is required percentage score for passing oracle 9i funda-I certification exam .
waiting for reply

 Napster
Posted: Feb 28, 2008 12:31:56 AM  

 Total Post: 6
 Joined: Jan, 2008






 
Hi all,

I'am new to oracle 9i. i've a mock database in my personal comp(just for practising). i'm trying to work on backup and recovery scenario's.

i have a backup of all my datafiles,controlfiles and redologs.
my database was in archive log mode.
the scenario was as follows
1) i did alter system switch logfile; (3 times)
2) and the shutdown the db
3) deleted one of the datafiles
4) tried to start the db but it gave me an error
5) restored the datafile to it's location and the did
recover datafile '/..path/ ...dbf';
6) still got an error asking for some archive file
{ plz note in pfile i'd given
log_archive_dest_1='.....'
log_archive_dest_2='.....'
log_archive_dest_3='.....' }
7) also in the different locations of archive file it shows different format even though i haven't set the log_archive_format parameter
8) Now what i tried to do is restore all files with the cold backup but after i do this i get the following error at mount stage

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/oracle/home/testdb/data/system01.dbf'
ORA-01207: file is more recent than controlfile - old controlfile

9) i guess this means that my old backup is not consistent hence the error!!!!!
10) can anyone help me with this and provide any solution (if applicable), also plz tell me things that i have to be very carefull about to avoid such a scenario

regards
Suraj M.

 ramesh
Posted: Feb 29, 2008 04:50:53 AM  

 Total Post: 41
 Joined: Aug, 2007






 

Hi One & All,

The database was ubruptly shutdown i dont no why, while we are opening the database it is showing the error in log files so we tried to add a new redolog file for the existing group it is added,and we are not able to switch the database because we are at mount stage,and even we use the command to clear the logfile with "alter database clear unarchived logfile group 4" even it is not clearing the group nor the database is switching because at mount stage, the database is in hang postion. The database will open if we offline & drop that redolog file but we will loose Some data. To overcome from this type of errors what Precautions should we take at this movement could there is any other process for this........

Thanks in Advance.


 
Posted: Mar 06, 2008 02:59:02 PM  

 Total Post: 46
 Joined: Sep, 2007






 
hi

all plz help me to slove this prob.


i m using oracle 9i.

my prob is recover the droped tablespace.

my steps as folows:

1. CREATE TABLESPACE xyz
DATAFILE 'd:\oracle\oradata\AIDS\TEST.dbf' SIZE 500M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
SEGMENT SPACE MANAGEMENT AUTO
PERMANENT
ONLINE;

2. i have created a table on that table space
3. and i have inserted few row.
4 then,

connect to the rman

RMAN> CONNECT CATALOG RMAN/PASSWORD@RMAN
RMAN> CONNECT TARGET SYSTEM/MANAGER@AIDS
RMAN>REGISTER DATABSE
RMAN>RESYNC CATALOG

RMAN> BACKUP TABLESPACE XYZ FORMAT 'C:\XYZ.DBF'

THEN,
SQL> DROP TABLESPACE XYZ

But now i m trying to recover the xyz tablespace through RMAN, i could not do that ,
error occured

RMAN> restore tablespace xyz

its saying that tablespace does not exit.


plz help me how to recover the tablespace.


tell me the steps by step

thnks in avance

Dwaipayan das
------------------

 Neeraj
Posted: Mar 10, 2008 08:01:43 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
i m running my data on archiving mode, can i get the dump of my database on another machine, but can i start my data till a given date.
means i want to up that dump b4 2 days back ,is it possibe that i can get all the datafile that was till 2 days back.i dont want all work i done within 2 days.
i want to up my database on same senario that was b4 2n days back.
thxs

 Ajith
Posted: Mar 10, 2008 09:26:08 AM  

 Total Post: 4
 Joined: Jan, 2008






 

All,

Could somebody explain me whether the hash values differ during execution of the same SQL with diffrent variables and during the execution with a bind var.

Thanks in advance
Ajith

 ramesh
Posted: Mar 11, 2008 03:12:34 AM  

 Total Post: 41
 Joined: Aug, 2007






 

Hi All,

If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import ? where as Oracle 10g has defaultly 8kb block size and Oracle 8i has 2kb Block size so it can import 8i database to 10g without any problem or we have to create additional 2kb block size duringthe time of Database creation of Oracle10g.If anybody had these type of problem solved iam very thankful............



 Neeraj
Posted: Mar 14, 2008 06:42:20 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
i have onl;y dbf files of my oracle 9i database(not redo & control files) so is it possible i can up my this database on 10g somehow.
if yes then tell me how ? if not then also tell me y not.
thxs

 Prashant
Posted: Mar 15, 2008 05:03:30 AM  

 Total Post: 23
 Joined: Oct, 2007






 
Error:RemoteOperationException: ERROR: Wrong password for user.

I am getting above error while connecting to host credentials.I would like to know what is this host credentials and what is the OS username and password?Please guide me through....

 Prashant
Posted: Mar 15, 2008 05:17:56 AM  

 Total Post: 23
 Joined: Oct, 2007






 
What do I need to do if my undo tablespace needs media recovery???
Pls help me.

 jothi
Posted: Mar 17, 2008 10:46:02 PM  

 Total Post: 33
 Joined: Aug, 2007






 
Im trying to import a table with indexfile parameter and no matter
what I do, my table is skipped, but there are no errors
produced by imp, and there are also no errors in alert_SID.log and
SID_ora_*.trc.The command is used and the output is

C:\>imp 'sys/sys as sysdba' fromuser=sys touser=sys tables=emp indexes=y indexfile=c:\index.sql file='c:\file1.dmp'

Import: Release 9.2.0.1.0 - Production on Tue Mar 18 07:52:02 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via direct path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. . skipping table "EMP"

Import terminated successfully without warnings.

I used oracle 9i on windows.The index(index.sql) file has

REM CREATE TABLE "SYS"."EMP" ("NAME" VARCHAR2(20), "ID" NUMBER, "PHONE"
REM NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL
REM 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "RMAN" LOGGING
REM NOCOMPRESS ;
REM ... 50 rows
CONNECT SYS;
CREATE INDEX "SYS"."ID_IND" ON "EMP" ("ID" ) PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE "SYSTEM" LOGGING ;

Can anyone help me to solve this.
Thank you


 
Posted: Mar 20, 2008 04:39:20 AM  

 Total Post: 46
 Joined: Sep, 2007






 
hi

i lost Lost all the member of Current Redo log group.
i m trying to recover this way.
1.Shutdown immediate
2. startup mount
3. RMAN> restore database until SCN 180067
then getting error because of no database back up was there.
i cant open my database up.
i know i will lost all the transaction which belongs to current log group.
even i dont have database backup.
i m worried that how can i open my database.
plz tell me the steps:

Thanks & Regards
Dwaipayan Das

 viral
Posted: Mar 23, 2008 05:59:47 AM  

 Total Post: 8
 Joined: Jun, 2007






 
hello everyone,
plz can anyone suggest me how to restore database from recovery catalog when our control file of target database has lost.
plz verify the steps...
waiting for reply.....
thanking uuu...

 tillu
Posted: Mar 24, 2008 12:08:25 PM  

 Total Post: 1
 Joined: Jul, 2007






 
can anybody tell me
what is process of autoback up and compress.

 uk
Posted: Mar 29, 2008 07:11:12 AM  

 Total Post: 3
 Joined: Mar, 2008






 
My os is crush then. What can it do when we reload Os and Oracle 9i.
My database in D: drive.

Plz help me.


 CN
Posted: Mar 30, 2008 12:54:49 AM  

 Total Post: 12
 Joined: Jul, 2007






 
pls any one tell me ,
what is the prcodure
if i want to generate auto backup at night(about at 2.30am) when database is at lowest transaction activity ??
backup should be generated automatically.
waiting for reply..........

 
Posted: Apr 01, 2008 09:37:57 AM  

 Total Post: 46
 Joined: Sep, 2007






 
Hi
I have taken user managed cold backup of the following datafiles.
1.Tools01.dbf
2.Users01.dbf.

but my prob is that i want to integrity check of these two datafile using the DBverify utility.
my Block size :8192
but while run the command getting error.
C:\Documents and Settings\dwaipayan>DBV FILE='H:\BCK\USER\TOOLS01.DBF'

DBVERIFY: Release 9.2.0.1.0 - Production on Tue Apr 1 18:23:45 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


DBV-00103: Specified BLOCKSIZE (2048) differs from actual (8192)

----------------------------------
But While i run the another coomand also getting error.


C:\>DBV FILE='H:/BCK/USER/TOOLS01.DBF' BLOCKSIZE=8192;

DBVERIFY: Release 9.2.0.1.0 - Production on Tue Apr 1 18:41:30 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

LRM-00104: '8192;' is not a legal integer for 'blocksize'

DBV-00001: Illegal command line syntax - parse error = (104)

Plz give me the solution

How i will check ,,my OS is Windows XP with SP2 and Oracle version is :9i


Waiting for the best answer.

 Irfan
Posted: Apr 04, 2008 07:20:50 AM  

 Total Post: 30
 Joined: Nov, 2005






 

Hi All,

I have Oracle7 on SCO Unix platform. The rollback segment datafile
is corrupted and no archivelogs are present. I tried to delete the file/
made another file/putting it in offline mode and recover but all in vain.

Any suggestions?



 ramesh
Posted: Apr 10, 2008 02:39:53 AM  

 Total Post: 82
 Joined: Dec, 2006






 
i'm using oracle 9i on linux
i hav tablespace with 3 datafiles on the 1st partition,
and due to insufficient space in the tablespace and partition,
i added a datafile to it with the datafile on the 2nd partition,
now the tablespace show free space but the partition space is still full
it means the data is shared with the datafiles on the 1st partition.

what i want is to move some data from the 1st 3 datafiles to the 4th

so that the partition size will be freed.

..ramesh

 dougiez
Posted: Apr 17, 2008 01:15:40 AM  

 Total Post: 7
 Joined: Aug, 2007






 
Hi

I have three databases on one server. i want to configure rman to backup all databases at once, like when i issue command backup database, all the three databases are backed up.

i'm using rman with recovery catalog database.

 shipon
Posted: Apr 20, 2008 01:04:18 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear friends ,

Is it necessary to take Redo log backup ?
Normally when we take a database backup then we dont take the redo log file backup ? Can anyone plz explain me why we do this ?

And If I want to take redo log file backup then using which command I can take it (both in RMAN backup and export backup utility) ?

 shipon
Posted: Apr 20, 2008 09:34:09 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear Friends,

I have a little question .

In my Oracle10g database , I run RMAN script for backup purpose daily .For testing purpose I have to delete HR user . Now I cannot return back HR user when I 'restore database' from the RMAN backup ?

Can anybody plz tell me , why RMAN cannot restore a database user ?

waiting for ur kind reply ... ...

 Amjad Ali
Posted: Apr 21, 2008 12:21:26 PM  

 Total Post: 24
 Joined: Apr, 2008






 
Dear Friends,
OS - XP, ORACLE 9i, Both 10g and 9i install on same pc...
C:\documents and settings\amjad ali> set oracle_sid=db1;
C:\documents and settings\amjad ali>rman
Recovery Manager: Release 10.2.0.1.0-Production on ..
RMAN>connect target / as sysdba;
RMAN-00571:
RMAN-00569:
RMAN-00571:
RMAN-00558:error encountered while parsing input commands
RMAN-01009:syntax error : found "as":expecting one of:"newline,;"
RMAN-01007:at line 1 column 18 file: standard input
When I tried to connect in another way....I am getting this error....
RMAN> connect target sys/saherdb1@db1;
RMAN-00571:
RMAN-00569:ERROR MESSAGE STACK FOLLOWS
RMAN-00571:
ORA-12154: TNS :could not resolve the connect identifier specified
RMAN>
Thanks and Regards



 shipon
Posted: Apr 22, 2008 05:06:50 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear friends ,

I have two Questions regarding RMAN :

1) I have to run RMAN script in my Oracle10g based Production server . Every night I take RMAN backup into my storage . Now My question is :
Is it possible to take my database 7 days ago using my lastday backup of RMAN ? i,e, Can RMAN take my database before 6/7 days ago , where my last RMAN backup is taken yesterday ?

2)

My 2nd question is :

In nomount stage when I m going to take RMAN level0 backup using follwoing script :

run
{
allocate channel t1 type disk;
backup incremental level 0
format 'F:\rman_backup\bak_%s_%T_level0.bak'
database include current controlfile plus archivelog;
}

It shows the following error :


using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=156 devtype=DISK


Starting backup at 22-APR-08
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 04/22/2008 14:55:59
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2008_04_22\O1_MF_1_1_40V98OWS_.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Here I dont understand why it searches for O1_MF_1_1_40V98OWS_.ARC archive log ? I think, I delete it in my absent mind . Plz help me in this moment how can I run level 0 backup now ?

Waiting for ur reply .. ...




 Deep
Posted: Apr 24, 2008 01:28:40 AM  

 Total Post: 10
 Joined: Aug, 2006






 
Hii all DBA's

I'm facing a problem with configuring a target database in the catalog, ishall explain you in steps wat i hav done

1. I have registered my target database & modified the configuration parameters as required.
Ex: CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk2/oradata/deepsdb/rman_bkp/%U.bkp';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/disk2/oradata/deeps/rman_bkp/snapcf_cvsw.f';


(My directory of database i mentioned as 'deepsdb',but actually it was 'deeps')

Now my problem is i want to reconfigure the target database and set the correct folder as 'deeps'.But i'm not able to do tht even though i tried to do Unregister database in RMAN ...it is still having the parameters of old configuration..can any one plz giv any solution to it

Thanks in advance to all DBA's..

 Deep
Posted: Apr 28, 2008 01:50:53 AM  

 Total Post: 10
 Joined: Aug, 2006






 
Hello all

Can any one suggest me best way to handle the database restore using RMAN, ie.
I have two backup level Zero backup of RMAN. Example, one is taken on April-25 and last one is taken on April -28. I would like to restore my database from April-25 ........is tht possible in tht way.

plzzz suggest me the solution for this query


Thanks to all

 seema
Posted: May 01, 2008 02:58:20 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How to do export and import in two different system in the same network.

 Monu
Posted: May 01, 2008 04:13:06 AM  

 Total Post: 26
 Joined: Jan, 2008






 
Hi all,

When I run RMAN script for database backup(Oracle 9i) it works fine but whenever I schedule the same through crontab it shows an error.

"/home/oracle/rman_amrdb.sh: line 5: rman: command not found"

In script I have set PATH,ORACLE_HOME and ORACLE_SID env variables.

My crontab entry is :
35 13 * * * sh /home/oracle/rman_amrdb.sh >> /data1/amrdb/rma_amrdb.log 2>&1



 Mehul
Posted: May 01, 2008 08:02:33 AM  

 Total Post: 1
 Joined: May, 2008






 
I have two different database running simultaneously on a server with SCO Unixware 711 and Oracle 8.0.4. The two databases are not inter-linked. Both database are Identified by two different ORACLE_SID, say SALARY and ACCOUNTS.

The Database is always left running by the users at night though not required . I have another server with similar setup. I want to write an sql script that can shutdown any open database and transfer all database files to another server through ftp. This activity can be carried out at night unattended, thus requiring cron usage.

Can anyone guide me? I need to write an SQL script, ftp script and an cron configuration.

Thanks.

 Taqi
Posted: May 05, 2008 04:01:43 PM  

 Total Post: 6
 Joined: Apr, 2008






 
Hi,
I lost system datafile of my prod DB, I tried recovering it through RMAN, I have two databases one is tha prod and the other is catalog. I was connected to rman at the time when the database was running fine, suddenly I got the error at the prod database regarding the lost datafile. So, first I tried to shutdown the databse from rman, it got down, then when I tried to startup the database in nomount stage I got this error...
ORA-03002: failure of startup command at 05/05/2008 and the time,
ORA-28547: connection to server failed, probable Oracle Net admin error
then I exited from RMAN...
Again tried to connect to rman using this..
rman catalog user_rman/passwd target sys/passwd@to_rman and got the following errors

RMAN-00554:initialization of internal recovery manager package failed
RMAN-04005:error from target database
ORA-28547: connection to server failed, probable Oracle Net admin error

PLEASE help me guys...

Thanks and Regards
Taqi


 yogi
Posted: May 06, 2008 04:57:36 AM  

 Total Post: 9
 Joined: Apr, 2008






 
hi all,
day before yesterday i configuared RMAN in one of test database,
configured all parameter, default device type to disk later i changed to default device type to SBT_TAPE, back device type to disk .iam not able to perform restore n recovery operation. here is the script which is giving me the error

[oracle@nisi-dba-122 ~]$ rman target sys/sys@sir catalog rman/rman@catdb

Recovery Manager: Release 10.2.0.3.0 - Production on Tue May 6 02:08:16 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: SIR (DBID=1074185434)
connected to recovery catalog database
RMAN> backup database;

Starting backup at 06-MAY-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/d04/stony/system.dbf
input datafile fno=00004 name=/d04/stony/sysaux.dbf
input datafile fno=00003 name=/d04/stony/undo.dbf
input datafile fno=00005 name=/d04/stony/tools.dbf
input datafile fno=00002 name=/d04/stony/usr04.dbf
channel ORA_DISK_1: starting piece 1 at 06-MAY-08
channel ORA_DISK_1: finished piece 1 at 06-MAY-08
piece handle=/d04/stony/recover/SIR_DB_39jflhts_105_1 tag=TAG20080506T020900 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
Finished backup at 06-MAY-08

Starting Control File and SPFILE Autobackup at 06-MAY-08
piece handle=/d04/stony/control/c-1074185434-20080506-03 comment=NONE
Finished Control File and SPFILE Autobackup at 06-MAY-08
RMAN> restore database;

Starting restore at 06-MAY-08
using channel ORA_DISK_1
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/06/2008 02:10:08
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 9



RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO NONE;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/d04/stony/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '/d04/stony/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/d04/stony/recover/%d_DB_%u_%s_%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/d04/stony/RMAN';

how to activate restore n recover command

 sandy
Posted: May 10, 2008 03:48:51 AM  

 Total Post: 1
 Joined: May, 2008






 
I was doing coldbackup but forget to shut down the database and took the backup , now i am getting the error for my system.dbf file how to recover it

my database is running in archive log mode.
I used following commands but yet cant recover my file;

alter database recover automatic using backup controlfile until cancel;
recover cancel; // here i am getting system.dbf file error
alter database open resetlogs;


after this i am trying to recver the file like this
(// i am thinking the backup is waste after applying resetlogs can i still recover my file then how?)

alter database datafile 1 offline; //1 -->fileid of system.dbf
alter database recover automatic datafile 1;
error(user backup control file)

please help me how to recover the file.

 shipon
Posted: May 14, 2008 02:42:04 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear Friends ,

I have two database in windows and linux RHEL5 platform .

1) TESTDB : in windows platform
2) ORCL : in Linux platform

 shipon
Posted: May 14, 2008 02:48:00 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear Friends ,

I have two database in windows and linux RHEL5 platform .
databases are:
1) TESTDB : in windows platform
2) ORCL : in Linux platform

Now I have the following questions :

1) I want to copy a database from windows to linux or vice-versa . Firstly when I take full export from TESTDB then which informations of the database exported , here i use FULL=Y ?
and if I import this "testdb export dump" to "linux ORCL Database" then is it work ?

2) If I want to copy all datafile, control file and redolog files from windows(TESTDB) to Linux (ORCL) , then is it work properly ? Here I want to copy full database from windows to linux ?

3) Can anyone plz tell me simply , "what is metadata" and "Data Definition" ?

Waiting for ur kind reply .. ...

 GOPU
Posted: May 14, 2008 08:02:54 AM  

 Total Post: 367
 Joined: Apr, 2008






 
If there is hard disk crash on target db(prod db), also on rman catalog db

you are left with only backup piece of rman bkp operation

can we recover the oracle db from that? if yes how ?? in 9i also in 10g??



 simoh
Posted: May 15, 2008 06:51:02 PM  

 Total Post: 4
 Joined: May, 2008






 
Hi,

i am new into this..so please help

here is the situation:
we have a 9i RAC env (production we dont have a dev env.). that holds alot of applications...today morning, one of the application with in 15 min lost a portion of the data (i dont really know how)...the database was running fine and no errors where generated....all other applications are running fine with no problem and nothing was lost(except for that one)...

i need to know how i can restore that portion...please note that i tried to use logmnr but i couldnt as to set the UTL_FILE_DIR parameter i need to bounce the database which is not acceptable(as it will affect the other application)...
so is there any other way???

i have a backup which i am tried to validate....if i need to use the recovery is there any suggested strategies...

please help
thank u in advance

 rajesh
Posted: May 17, 2008 02:18:20 AM  

 Total Post: 26
 Joined: May, 2008






 
Hai,

I want to export particular data from a table (ex. Ename='Sangit'. I used query option in Export. But it is giving following error.

ORA-00904 - 'sangit' invalid identified. If I given deptno=10. no error. that means how to query strings.

Can any one help me.

Rajesh






 rajesh
Posted: May 17, 2008 02:54:42 AM  

 Total Post: 26
 Joined: May, 2008






 
Hai,

I want to export particular data from a table (ex. Ename='Sangit'. I used query option in Export. But it is giving following error.

ORA-00904 - 'sangit' invalid identified. If I given deptno=10. no error. that means how to query strings.

Can any one help me.

Rajesh






 rajesh
Posted: May 17, 2008 03:00:44 AM  

 Total Post: 26
 Joined: May, 2008






 
Hi,

Can any one help in this issue.

I am practising RMAN at my home PC on linux. I opened a terminal and open a target database. and opened another terminal and changed sid name and opened catalog database. I configured listener and tnsnames.ora properly. By using Rman I have taken backup.

After that I removed Controlfiles, Redolog Files, and Datafiles in Target Database. Now I tried to recover from catalog database. When I tried to open the Target Database in nomount state at RMAN prompt in catalog database. I have given the following errror.

ORA-12505 : TNS listener does not currently know of SID given in Connect Descriptor.

What mistage I have done. Can any one tell me.

Rajesh


 simoh
Posted: May 20, 2008 05:54:45 PM  

 Total Post: 4
 Joined: May, 2008






 
Hi,

We are taking a backup for 9.2.0.5.0 database through RMAN.
There are no error messages in the log file.
However, when I try to run restore database validate I am getting
ORA-06510: PL/SQL: unhandled user-defined exception

I checked the alert log file it turned out that there is a corrupted block:

corrupt block 17130422 found during reading backup piece,file=/racdb1/orabackup/RACDB1_hmjgqen9_1_1.bkup, corr_type=-2
dump corrupted block

Does that mean this backup is not restorable?

Please help

Thank you


 priya
Posted: May 21, 2008 01:02:20 AM  

 Total Post: 9
 Joined: Mar, 2008






 

Can any one tell me
the import/export parameter rows,consistent,stat... etc what purpose

 sam
Posted: May 26, 2008 04:43:49 AM  

 Total Post: 13
 Joined: May, 2008






 
hi
my database is in archive logmode i have no any type of backup and my controlfile is corrupt.
i want to recreate controlfile so is it possible to create controlfile
without any type of backup if yes
so plz help me
thanks
Regards
samir amin

 mcdon
Posted: May 26, 2008 08:20:09 AM  

 Total Post: 14
 Joined: May, 2008






 
Hi,

How can one import DB objects (procedures, functions, views, sequences, DB links, directories etc) other than table, from a full export dump, using import utility?

 balaji
Posted: May 27, 2008 01:15:54 AM  

 Total Post: 321
 Joined: May, 2008






 
hi all,

we take increemental backup at weekdays and full backup at weekends.If suppose my datafile is corrupted .how to recover the corrupted file using RMAN ?



Kindly revert me with the steps.


 fozturk
Posted: May 27, 2008 01:59:26 AM  

 Total Post: 69
 Joined: Sep, 2007






 
hi all,
i have "Concurrent Sessions (Per User) is set to 2 " in the profile and i assigned this profile to my user then restarted the db, but still i can open 3 or more sessions. I could not understand why does not it work, do you have any idea? By the waay, it is 10g release 2 on windows 2003 64 bit host.
thnks

 saza
Posted: May 29, 2008 03:51:15 AM  

 Total Post: 13
 Joined: Apr, 2008






 
I hope someone can help me.
and problam is that I have a running database YUPL1 on server1 and YUPL2 on server2. YUPL2 do we use as a testdatabase. YUPL1 is in production and is uppdated. I need too uppdate YUPL2. How will I do soo ??


Can I export the YUPL1 and import that in to YUPL2??

what will the syntex be?

somthing like this?

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=<Database Name>
filename='FULL_'
v_date="`date +%Y%m%d`"


${ORACLE_HOME}/bin/exp <userid>/<password> full=y file=${filename}${v_date}.dmp log=${filename}${v_date}.log

ORRRRRRRRRR

Find thet when the last YUPL2 uppdated?
(how..)

and take the Cumulative export from YUPL1 and uppdate the YUPL2?


will that worked??

what will the syntex be?




Thanks in advansd!






 muna
Posted: May 30, 2008 01:59:37 AM  

 Total Post: 14
 Joined: Jul, 2007






 
any one can send me oca sql 9i question

 muna
Posted: May 30, 2008 02:00:37 AM  

 Total Post: 14
 Joined: Jul, 2007






 
any one can send me oca sql 9i question
sanjeev.cummins@yahoo.co.in

 seenu
Posted: Jun 12, 2008 12:45:12 AM  

 Total Post: 106
 Joined: Apr, 2008






 
In RMAN Backup we store control file information in RMAN Catlog.Why we are storing control file information in the RMAN Catlog.

What is the concept behind in it?

what is the purpose?

Pls clear the doubt?



 Samz
Posted: Jun 18, 2008 01:07:13 AM  

 Total Post: 24
 Joined: Sep, 2007






 
Hi Everyone....

I have exported full database in oracle 9i using traditional exp utility n i got a test.dmp file.Now i want to import it into oracle 10g. Import has been done sucessfully without any warning but i couldn't find any imported file. I want to access the same database that has been exported from 9i into 10g.
Please guide me step by step.


samz

 Samz
Posted: Jun 18, 2008 01:11:54 AM  

 Total Post: 24
 Joined: Sep, 2007






 
I want to export a tablespace users.dbf from oracle 9i to oracle 10g.How this can be done.

samz

 Monu
Posted: Jun 20, 2008 08:19:28 AM  

 Total Post: 26
 Joined: Jan, 2008






 
Hi everyone, I've problem with Rman backup. I've two databases i.e. target database and recovery catalog database on the same windows system. When I run below mentioned rman script i get error which is also mentioned below. Kindly helpme out.....

RMAN> run {
2> allocate channel t0 type disk;
3> allocate channel t1 type disk;
4> shutdown immediate;
5> startup mount;
6> backup full database
7> filesperset 4
8> format 'd:\ebstest_%U.bak';
9> release channel t0;
10> release channel t1;
11> }

allocated channel: t0
channel t0: sid=14 devtype=DISK

allocated channel: t1
channel t1: sid=15 devtype=DISK

database closed
database dismounted
Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 06/20/2008 17:37:14
ORA-03113: end-of-file on communication channel


 
Posted: Jun 24, 2008 02:35:01 AM  

 Total Post: 46
 Joined: Sep, 2007






 
dear all,

i want to write some RMAN script into a text file, and want run it through RMAN.plz tell me the steps.

and also how to write RMAN script into .rcv file and how to run it.

i know only rman script like
crate script xyz
{
backup database;
}

and i know how to run this.

but my prob is that except writing this way rman script i want to write script into text file and .rcv .plz tell me the details steps.

i searched lots docs, but i did not get proper answer.plz help me.

oracle version: 9i
O.S: Win XP with sp2
Recovery catalog and target database resides in same machine.


regards
dwaipayan

 amjad
Posted: Jun 24, 2008 06:37:09 AM  

 Total Post: 24
 Joined: Feb, 2008






 
Dear experts please Help
As my co is opening one new small comapny they want to create a new database on windows 2003 server with oracle 8i running on it . the company requirments is to have only tables of the acc,inv,hr schema not the records in this new database .
please can any one help me to how should i proceed

 seema
Posted: Jun 26, 2008 02:18:28 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How can i get the size of the tablespace !

 mms
Posted: Jun 26, 2008 07:30:50 AM  

 Total Post: 6
 Joined: Apr, 2008






 
hi,
oracle 9i, OS linux 9
1.how can i apply a particular archive log on a database? i dont want to apply all my archive logs.
also i dont know the last SCN. what should i do in that situation?

2.how to do archiving on remote location?
any prompt response and help will b highly appreciated.

mms


 muna
Posted: Jun 28, 2008 10:49:49 AM  

 Total Post: 14
 Joined: Jul, 2007






 
what type privileges we need for import , export

 eyecycas
Posted: Jul 03, 2008 07:37:24 AM  

 Total Post: 15
 Joined: Nov, 2007






 
Hallo,

meine RMAN-Backups werden immer unter $ORACLE_HOME/dbs abgelegt (s. output filename).

Starting backup at 01-JUL-08
channel d1: starting datafile copy
input datafile fno=00001 name=...
output filename=/global/ora-dg/oracle-vol/product/10.2.0/dbs/data_D-TECRBR_I-935235287_TS-SYSTEM_FNO-1_9ajkd53s tag=TAG

Das RMAN-Skript soll aus einem anderen Skript aufgerufen werden.
Bei der Angabe "backup format" im CMD-File fr RMAN, schreibt RMAN zwar an den richtigen Speicherort, wrde aber bedeuten, da ich bei 8 Instancen, immer das CMD-File dynamisch erzeugen und ausfhren mte, da die Zielverzeichnisse bei jeder Instance anders liegen.
Mein Ziel ist die Konfiguration ber die Instance mit CONFIGURE.
Leider bleibt der Befehl

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/global/.../%U.bkp';

wirkungslos.

Derzeit sieht mein Skript so aus (mit backup format):

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
backup
format '/global/.../%U.bkp'
database plus archivelog;
release channel d1;
release channel d2;
}

Meine RMAN-Einstellungen sind:
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/global/.../%F.bck';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COPY;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/global/.../%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/global/.../snap_tecrbr.f';


Wie kann ich ber die Instance-Einstellungen!! (Default Permanent Settings mit CONFIGURE) erreichen, da RMAN den richtigen Speicherort whlt?

Kann mir jemand weiterhelfen?

 tush
Posted: Jul 03, 2008 08:22:44 AM  

 Total Post: 5
 Joined: May, 2008






 
Hi,

I have 100GB of DB on Oracle 9i.
I am using following method for RMAN Backup
Plan - 1
--------
Sunday-Level 0
Monday to Saturday - Differential Incremental Level 1

Plan - 2
--------
Once a month - Level 0
Cummulative - Every Sunday
Differential Incremental - Monday to Saturday

Which plan is better and why? Also which level should I use for cummulative and incremental plan 2?

Regards,
Tushar


 eyecycas
Posted: Jul 04, 2008 04:21:24 AM  

 Total Post: 15
 Joined: Nov, 2007






 
Hello,

my RMAN-Backups are always listed in $ORACLE_HOME/dbs (see output filename).

Starting backup at 01-JUL-08
channel d1: starting datafile copy
input datafile fno=00001 name=...
output filename=/global/ora-dg/oracle-vol/product/10.2.0/dbs/data_D-TECRBR_I-935235287_TS-SYSTEM_FNO-1_9ajkd53s tag=TAG

But I want to give RMAN a new location (storage place) , where he can write to.

The RMAN script is startet out of another script.
With the command "backup format" in my RMAN cmd-file, RMAN writes it's output to my given storage place. Unfortunately this would have the disadvantage that, because of 8 instances, I have to create and execute my cmd-file for each instance dynamically, because every instance has another storage place for it's backups.
My intention is to configure RMAN through the instance with CONFIGURE!

Unfortunately the command below doesn't work

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/global/<another_storage_place>/%U.bkp';

At the moment my cmd-File looks like this (with backup format):

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
backup
format '/global/.../%U.bkp'
database plus archivelog;
release channel d1;
release channel d2;
}

My RMAN settings are:

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/global/<another_storage_place>/%F.bck';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COPY;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/global/<another_storage_place>/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/global/<another_storage_place>/snap_tecrbr.f';

How can I achieve through the instance !! (Default Permanent Settings mit CONFIGURE), that RMAN would write to the new storage place.

Can s.o. help me plz?



 balaji
Posted: Jul 08, 2008 04:48:03 AM  

 Total Post: 321
 Joined: May, 2008






 
How to determine datafile is corrupted or missing and how to recover the missing datafile using RMAN??

 imran
Posted: Jul 08, 2008 09:10:32 AM  

 Total Post: 3
 Joined: Jul, 2008






 
I have three controlfiles in my database,one of the controlfile is corrupted during database is in functional,
suddenly my database is shutdown,during next startup oracle send me the error,i have the old backup of controlfile that is taken before one week,my database is running in archivelog mode and no datafile is added yet but i added five tables this week,how could i recover the database.

 imran
Posted: Jul 08, 2008 09:12:39 AM  

 Total Post: 3
 Joined: Jul, 2008






 
I have three controlfiles in my database,one of the controlfile is corrupted during database is in functional,
suddenly my database is shutdown,during next startup oracle send me the error,i have the old backup of controlfile that is taken before one week,my database is running in archivelog mode and no datafile is added yet but i added five tables this week,how could i recover the database.

i am working in oracle 9i

 imran
Posted: Jul 12, 2008 10:11:06 AM  

 Total Post: 3
 Joined: Jul, 2008






 
hi

how to recover datafile. if database is not run in archive mode and if there is no backup.



 Deepakkumar
Posted: Jul 15, 2008 07:50:12 AM  

 Total Post: 86
 Joined: Dec, 2007






 
hi, i am facing one problem .when i used to take a export back up its size was nearly 20 mb but now a days it shriks to 12 mb.i have not deleted any data,table,tablespace or anything .can anybody tell me how come it automatically shrink?

 Deepakkumar
Posted: Jul 18, 2008 07:55:56 AM  

 Total Post: 86
 Joined: Dec, 2007






 
i am getting the following error messege while taking up export backup
EXP-00091: Exporting questionable statistics.

 sallu
Posted: Jul 18, 2008 09:18:42 AM  

 Total Post: 24
 Joined: Jul, 2008






 
Hi,
Can u please tell me how to apply pathches and in what cases they apply patches.pls give me example and the procedure to apply a patch

 sallu
Posted: Jul 18, 2008 09:22:02 AM  

 Total Post: 24
 Joined: Jul, 2008






 
what are the critical errors we monitor in the alert log,pls give me 5 to 6 errors description and how to solve them. i have gone throgh the ora-related errors which are available in google,but i am unable to understanc.


 sallu
Posted: Jul 18, 2008 09:24:00 AM  

 Total Post: 24
 Joined: Jul, 2008






 
what type of issues dba faces in the real time environment,pls give me some examples and how to solve those issues

THANKING U
IRFAN

 shipon
Posted: Jul 20, 2008 07:23:44 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear Friends ,

I want to take my RMAN backup into "D:\RMAN_back" directory , not in the Default location .I use the following script , but it does not take the backup user defined area , it goes to the default location . Following the result :

RMAN> run
2> {
3> ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'D:\RMAN_back\%U';
4> backup format 'df_%T_%s_%p'
5> (database);}

released channel: ORA_DISK_1
allocated channel: disk1
channel disk1: sid=154 devtype=DISK
Starting backup at 20-JUL-08
channel disk1: starting full datafile backupset
channel disk1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\SYSTEM01.DBF
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\SYSAUX01.DBF
input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\EXAMPLE01.DBF
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\UNDOTBS01.DBF
input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\USERS01.DBF
channel disk1: starting piece 1 at 20-JUL-08
channel disk1: finished piece 1 at 20-JUL-08
piece handle=C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\DF_20080720_17_1 tag=TAG20080720T162317 comment=NONE
channel disk1: backup set complete, elapsed time: 00:00:56
Finished backup at 20-JUL-08

Starting Control File and SPFILE Autobackup at 20-JUL-08
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\RND\AUTOBACKUP\2008_07_20\O1_MF_S_660587053_4864LGH4_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 20-JUL-08
released channel: disk1


Now Plz tell me, using RMAN backup,How can I take my backup into another location , not it's default location ? Waiting for ur kind reply .. ..

 shipon
Posted: Jul 20, 2008 07:24:46 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear Friends ,

I want to take my RMAN backup into "D:\RMAN_back" directory , not in the Default location .I use the following script , but it does not take the backup user defined area , it goes to the default location . Following the result :

RMAN> run
2> {
3> ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'D:\RMAN_back\%U';
4> backup format 'df_%T_%s_%p'
5> (database);}

released channel: ORA_DISK_1
allocated channel: disk1
channel disk1: sid=154 devtype=DISK
Starting backup at 20-JUL-08
channel disk1: starting full datafile backupset
channel disk1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\SYSTEM01.DBF
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\SYSAUX01.DBF
input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\EXAMPLE01.DBF
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\UNDOTBS01.DBF
input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\USERS01.DBF
channel disk1: starting piece 1 at 20-JUL-08
channel disk1: finished piece 1 at 20-JUL-08
piece handle=C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\DF_20080720_17_1 tag=TAG20080720T162317 comment=NONE
channel disk1: backup set complete, elapsed time: 00:00:56
Finished backup at 20-JUL-08

Starting Control File and SPFILE Autobackup at 20-JUL-08
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\RND\AUTOBACKUP\2008_07_20\O1_MF_S_660587053_4864LGH4_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 20-JUL-08
released channel: disk1


Now Plz tell me, using RMAN backup,How can I take my backup into another location , not it's default location ? Waiting for ur kind reply .. ..

 seema
Posted: Jul 21, 2008 02:35:09 AM  

 Total Post: 83
 Joined: Jan, 2008






 
If my database in archive mode the how can i change that in noarchive mode.

 seema
Posted: Jul 22, 2008 01:13:37 AM  

 Total Post: 83
 Joined: Jan, 2008






 
When we change noachive to achive why we open database in mount stage ?????? why not we do that in open stage ????????

Also one more thing i want to know how to identify that when we have to open database in mount stage or when we have to open database in open stage???????????

 max
Posted: Jul 24, 2008 01:46:25 AM  

 Total Post: 14
 Joined: Feb, 2008






 
how to take back up in oracle 8i doing export and import
tell me urgent


command

 max
Posted: Jul 24, 2008 03:29:57 AM  

 Total Post: 14
 Joined: Feb, 2008






 
i want to to do export as well as import database in oracle 8i,how wud i do??
along wid d syntax plzzzzzz
its urgent

 tush
Posted: Jul 25, 2008 01:11:09 AM  

 Total Post: 5
 Joined: May, 2008






 
Hi,

We have a 150GB Database. We would be using following RMAN Backup Strategy for 9.2.0.6.

Once a month--> Level 0 Differential Incremental
Every Sunday ---> Level 1 Cummulative Incremental
Mon to Saturday ----> Level 2 Differential Incremental.

Will this strategy work during recovery.

Regards,
Tushar

 Samz
Posted: Jul 28, 2008 05:14:14 AM  

 Total Post: 24
 Joined: Sep, 2007






 
Hi

i've two databases prac which is running on 192.168.2.187 and tech which is running on 192.168.2.188.
I want to create a database link between both the databases
please explain the step by step procedure to create datbase link

 seenu
Posted: Aug 04, 2008 06:17:28 AM  

 Total Post: 106
 Joined: Apr, 2008






 
run
{
backup database plus archivelog;
delete noprompt obsolete;
}

Why i want to use "delete noprompt obsolete"?

What is the purpose of using this command i.e(delete noprompt obsolete)

 Siddique_Oracle
Posted: Aug 05, 2008 01:08:05 AM  

 Total Post: 8
 Joined: Aug, 2008






 
Hi Friends
I am new on the Forum
will any one pls guide me the complete process of RMAN Back n Recovry

I took ref from different books but they are not easy to implement

 Siddique_Oracle
Posted: Aug 05, 2008 02:32:19 AM  

 Total Post: 8
 Joined: Aug, 2008






 
Hi All ,

I want to Configure Database Server and Application Server on Seperate Machines. I Have Installed Windows xp server edition on both machines.
Moreover I installed 10g Database on 1st Machine which is working.
Now I want to configure Application Server on 2nd Machine but This is my first time and I am confused because I have no idea to make it functional with 10g database. I need some guideline steps and how to congigure Port no to access it from simple Internet Exprorer.

I wish I will be guided soon as I am new on this group with many axpectaions.
With Best Regards

 seenu
Posted: Aug 06, 2008 03:35:30 AM  

 Total Post: 106
 Joined: Apr, 2008






 
How to recover system tablespace if they corrupted?

issues:
In which mode i have to recover cold backup or hotbackup?
Also archive log mode or noarchive log mode?




 Azaz
Posted: Aug 06, 2008 06:51:52 AM  

 Total Post: 108
 Joined: Mar, 2008






 
When I run 10g EM it gives message
Internet Explorer cannot display the webpage

I am able to connect database thru SQLPlus
Can anyone say what is the problem


 muna
Posted: Aug 08, 2008 09:50:38 AM  

 Total Post: 14
 Joined: Jul, 2007






 
we export table from oracle enterprise managent console administration
:sysman management selver : localhost
but status failed
login normal dba and sysdba both case
what can we do

 balaji
Posted: Aug 10, 2008 11:51:52 AM  

 Total Post: 321
 Joined: May, 2008






 
Begin backup is not advisable in company environments whereas RMAN backup is suggested for all the databases.

can anybody tell me why it is so?

Thanks in advance




 aliai
Posted: Aug 11, 2008 01:56:37 AM  

 Total Post: 18
 Joined: Apr, 2008






 
can anyone tell me the way to connect ORACLE DEVELOPER APPLICATION WITH
ANY OTHER DATABASE????

 Monu
Posted: Aug 12, 2008 06:52:27 AM  

 Total Post: 26
 Joined: Jan, 2008






 
Hi everyone,
In case i've lost all the datafiles pfile, controls, redolog files and we have full database backup including pfile, control file etc. through RMAN, how can we restore and recover? Can anyone please advise me in short what are the steps we'll follow to up our database.
Thanks in advance.

 darshi
Posted: Aug 15, 2008 02:14:44 AM  

 Total Post: 75
 Joined: Aug, 2008






 
how 2 create auxilury database?
i face the problem in catalog database so i want ti transfer the target database from old catalog to new.
i know this is possible by import-export but i want to do by auxilury database.


 parveez
Posted: Aug 20, 2008 03:58:49 AM  

 Total Post: 38
 Joined: Aug, 2007






 
HI everybody

Kindly suggest all the instance failure situations and their solution faced in a real time environment. For example instance failure due to deletion of spfile and no pfile is present due to security reasons. Now how to make the database online. Give all the situations not only deletion of spfile. Or deletion od redo files. By doing so in only one thread we will get a detailed descriptions of the problems faced in day to day activities.

Thank you all for the support

 Deepakkumar
Posted: Aug 22, 2008 03:13:56 AM  

 Total Post: 86
 Joined: Dec, 2007






 
i want to transfer a export back up on the tape drive. i am using linux operating system.please tell me the command line and procedure for the same
thanx n regards

 muna
Posted: Aug 24, 2008 09:50:20 AM  

 Total Post: 14
 Joined: Jul, 2007






 
how to solove error vni-2015 in xp

 Neeraj
Posted: Aug 25, 2008 05:35:03 AM  

 Total Post: 262
 Joined: Jan, 2007






 
hi,
my database is on oracle 10g rac , i want to take cold backup on tap drive .but i dont know where to get datas files bcoz they r on SAN storage.
so tell me how to get cold backup on tap drive.

thxs

 matine
Posted: Aug 26, 2008 07:17:15 AM  

 Total Post: 2
 Joined: Aug, 2008






 
Hi all
Now I need backup to tape.but I don't know how to configure RMAN.

Can anybody tell me detail?


Thanks

 adi
Posted: Aug 29, 2008 01:05:48 AM  

 Total Post: 1
 Joined: Aug, 2008






 
hii!
please can any one send the procedure to recover dropped tablespace with the help off auxiliary database(RMAN).....

 seema
Posted: Sep 01, 2008 01:30:10 AM  

 Total Post: 83
 Joined: Jan, 2008






 
After issuing archive duplex command can i rollback that command.

 seenu
Posted: Sep 02, 2008 07:29:09 AM  

 Total Post: 106
 Joined: Apr, 2008






 


Is it true RMAN recovery catlog records informations concerning backup and recovery activities performed on the target?

pls explain how???

 Avnish
Posted: Sep 02, 2008 11:57:00 PM  

 Total Post: 155
 Joined: Dec, 2007






 
Hi,

Can we recover dual table (Real Time Table) in oracle database.If yes, then how it manage its timestamp?

Thanks & Regards
Avnish Yadav

 seenu
Posted: Sep 04, 2008 03:31:47 AM  

 Total Post: 106
 Joined: Apr, 2008






 
In RMAN what is meant by level 0,1,2,3 database backup?


 seema
Posted: Sep 04, 2008 06:27:08 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How to create password file and which parameter i have to set in PFILE????



 seema
Posted: Sep 05, 2008 01:23:12 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How to create two instance of one database ??????/

 Mahendra Rathod
Posted: Sep 05, 2008 08:23:42 AM  

 Total Post: 136
 Joined: May, 2008






 
hi masters,

what is similar utility of SQL's manintanance plan in oracle?

thanks in advance

 Mahendra Rathod
Posted: Sep 05, 2008 12:01:06 PM  

 Total Post: 136
 Joined: May, 2008






 
hi masters,

is it true that, when u take backup of transactions log in SQL 2005, it automatically cleans up the space it occupied .\

thanks in advance

 Mahendra Rathod
Posted: Sep 07, 2008 07:30:25 AM  

 Total Post: 136
 Joined: May, 2008






 
hi masters

what has to be done manually/saperately on the standby database ?

thanks in advance



 seema
Posted: Sep 09, 2008 01:01:46 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How to take incremental backup?????

 seema
Posted: Sep 09, 2008 01:03:54 AM  

 Total Post: 83
 Joined: Jan, 2008






 
How to see the currupt block and how to recover them using block media recovery????????/

 seema
Posted: Sep 09, 2008 01:27:25 AM  

 Total Post: 83
 Joined: Jan, 2008






 
can you please tell me the step of creating standby database????????

 seenu
Posted: Sep 09, 2008 03:36:19 AM  

 Total Post: 106
 Joined: Apr, 2008






 
Pls tell me we take RMAN cold backup and RMAN Hot backup in realtime scenario?

I am getting confused....





 Babu
Posted: Sep 10, 2008 07:21:48 AM  

 Total Post: 31
 Joined: Aug, 2008






 
Hi,
Can anyone help me to explain about Backup from remote system. If we have servers in USA, Is it possible to take back up from India by logging into remote system? and tape drives also in USA. If possible please explain me how?

Thanks in advance,
Babu.

 seenu
Posted: Sep 11, 2008 02:28:28 AM  

 Total Post: 106
 Joined: Apr, 2008






 
Dear All,

According to MNC what are all the backups u guys take in the realtime scenario?

Explain what type of backups u are using in the realtime scenario?







 ramesh
Posted: Sep 11, 2008 08:58:56 AM  

 Total Post: 82
 Joined: Dec, 2006






 
Hi.
My dbase is not configured in archive mode,
and i found data block corruption in a specific datafile while starting up the database.
so created new control file using "backup control file" cmd
and using no-restlogs option is started tried to start database,
but this did not worked and oracle was searching for some archive dbf files
following error occured

ORA-00279: change 41465640 generated at 09/11/2008 14:16:02 needed for thread 1
ORA-00289: suggestion : /oracle/oracle9i/dbs/arch1_3290.dbf
ORA-00280: change 41465640 for thread 1 is in sequence #3290

ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

and in case any input it throws out and says
media recovery incomplete .

can anybody tell me where i'm going wrong.


 seenu
Posted: Sep 12, 2008 01:54:01 AM  

 Total Post: 106
 Joined: Apr, 2008






 
Reports generated in the statspack report are dynamic or static?

Version:9i


 seema
Posted: Sep 13, 2008 12:43:22 AM  

 Total Post: 83
 Joined: Jan, 2008






 
In Oracle we have three option -:

Alter system
Alter database
Alter session

Now i just want to know that at what time we will use which alter command is there any specific time ...???

 seema
Posted: Sep 13, 2008 01:54:04 AM  

 Total Post: 83
 Joined: Jan, 2008






 
I lost my control file now how to create new control file...?

 seema
Posted: Sep 13, 2008 03:02:39 AM  

 Total Post: 83
 Joined: Jan, 2008






 
I just want to know that why oracle recommends that all group be the same size????

 MSB
Posted: Sep 15, 2008 07:20:31 AM  

 Total Post: 30
 Joined: May, 2008






 
How to find out the SGA size?

 seenu
Posted: Sep 15, 2008 08:04:53 AM  

 Total Post: 106
 Joined: Apr, 2008






 
How to take RMAN backups on tapes??

version:Oracle 9i
OS:Linux 5.5




 seema
Posted: Sep 19, 2008 12:51:42 AM  

 Total Post: 83
 Joined: Jan, 2008






 
can you please tell me about pctfree,pctused and freelist with good example????

 seema
Posted: Sep 20, 2008 03:09:27 AM  

 Total Post: 83
 Joined: Jan, 2008






 
What is the difference between instance and database can both have the same name?????

 seema
Posted: Sep 23, 2008 04:48:37 AM  

 Total Post: 83
 Joined: Jan, 2008






 
Please tell me row migration and chaning is done by the dba or oracle itself???

If that work is done by dba then how to do this???

 seema
Posted: Sep 23, 2008 05:50:23 AM  

 Total Post: 83
 Joined: Jan, 2008






 
Please tell me when we truncate a table will it release the space in memory???

 balaji
Posted: Sep 23, 2008 11:33:03 AM  

 Total Post: 321
 Joined: May, 2008






 
I removed old password file and recreated new password file to connect to database as sys user with different password ( as oracle) .Below is the command for creating password file on windows.

orapwd file=D:\oracle\product\10.2.0\db_1\database\PWD.ora password=oracle entries=5

When i connect using sys as sysdba and password as sysdba i was still able to connect to the database after recreating password file . But i dont want that to happen. I want sys user to connect only using 'oracle' as password.(which i have set it in the password file creation)

can anybody tell me how to do that??

Regards,
Balaji

 seenu
Posted: Sep 24, 2008 05:45:02 AM  

 Total Post: 106
 Joined: Apr, 2008






 
I have restored my corrupted datafiles?

but still database is not able to up?

what are the steps need to be check from my end?

pls help.....

Version:Oracle 9i
OS:Linux 5.5

 seema
Posted: Oct 08, 2008 02:49:38 AM  

 Total Post: 83
 Joined: Jan, 2008






 
whenever i fire a command -

Recover managed standby database;

the system will hang.......?

Can you please tell me why we use this command ??

 seema
Posted: Oct 10, 2008 01:18:37 AM  

 Total Post: 83
 Joined: Jan, 2008






 
Insert /** parallel(tablename,1) * / into tablename select * from tablename;

I just want to know that why we write 1 in this command what is that????

 nethu
Posted: Oct 10, 2008 01:02:04 PM  

 Total Post: 2
 Joined: Oct, 2008






 
what is next extent?
could any one explain me in brief?

 seema
Posted: Oct 11, 2008 02:21:15 AM  

 Total Post: 83
 Joined: Jan, 2008






 
Plz tell me step by step procedure for full database export import???

 mit
Posted: Oct 16, 2008 12:40:56 AM  

 Total Post: 60
 Joined: Sep, 2006






 
Hi,


In my setup Recovery catalog is on server'A'
traget databse is on server 'B'
I want to take backup on server'C'
Pleas guide me how to do it,so that my RMAN backup should go to server'C'
in windows environment.


 darshi
Posted: Oct 16, 2008 09:07:13 AM  

 Total Post: 75
 Joined: Aug, 2008






 
my database is running in shared server mode but i want that to perticular 1 user who can connect to database as dedicated mode,means that user has not wait for resources then what to do when we create listener?
plz send me the ans as soon as possible....

 newbiedb
Posted: Oct 18, 2008 12:34:01 PM  

 Total Post: 3
 Joined: Oct, 2008






 
hi guys, it is posible to backup by any method up to a point in past? for eg. if today is monday, can i backup up to last saturday? of course we alwayys backup up to current time. pls tell. tnx

 sam
Posted: Oct 23, 2008 12:37:54 PM  

 Total Post: 13
 Joined: May, 2008






 
HI

i want to know that when we fire this command than what happen internally

alter database begin backup;


one of person asked to me this question during interview
so anybody tell me pls wht haapen?

thanks and regards
samir amin

any help appriciate

 matine
Posted: Nov 07, 2008 01:12:21 AM  

 Total Post: 2
 Joined: Aug, 2008






 
I have 2 server. I want to duplicate database from server 1 to server 2.

I don't know how to configure listener.ora and tnsnames.ora on both servers.

Can you help me to do? and Including all the step for doing duplicate.

Thank

 ramesh
Posted: Nov 10, 2008 04:58:19 AM  

 Total Post: 82
 Joined: Dec, 2006






 
hi all
i use 9i dbase on linux as server,
i hav many windows clients connected to it,
when ever i try to take a full export in server(linux) it take long time
but when i take export from the client machines, it completed with the half time taken by server.
what must be the reason..

..ramesh

 dd
Posted: Nov 10, 2008 07:48:28 AM  

 Total Post: 15
 Joined: Jan, 2007






 
How to configure standby server on a single machine (both primary and standby on the same machine). Please guide me in this regard


 jothi
Posted: Nov 25, 2008 07:23:37 PM  

 Total Post: 33
 Joined: Aug, 2007






 
Hi
Im using Oracle 9i on Windos.When i was performing Clone database using cold backup i'm getting the following error

SQL> alter database recover using backup controlfile;
alter database recover using backup controlfile
*
ERROR at line 1:
ORA-00279: change 193666 generated at 11/26/2008 01:27:08 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\ORADATA\NEWCLONE\ARCHIVE1_1.DBF
ORA-00280: change 193666 for thread 1 is in sequence #1

how can i recover my database?

 kittu
Posted: Dec 01, 2008 03:49:19 AM  

 Total Post: 23
 Joined: Sep, 2008






 
i am exporting data to a dump file using exp command from the command prompt on windows Xp,Oracle 10g. I get a message export terminated successfully.
But when i import this dump using import command in a different database but to the same usr/schema i found some of the procedures are missing(not present at all).What could be the reason behind this?

Is there any other effective way of taking a backup.Please let me know


Thanks & Regards,

Krishna

 khubeb
Posted: Dec 02, 2008 12:20:56 AM  

 Total Post: 137
 Joined: Apr, 2007






 
hi gurus, how we drop the database manually in oracle 10g.

 sundy
Posted: Dec 09, 2008 05:47:29 PM  

 Total Post: 1
 Joined: Dec, 2008






 
hi,
could someone help me get a script/instructions for doing RMAN restores on windows 2003 server for oracle 9i databases?

 khan
Posted: Dec 14, 2008 12:58:37 AM  

 Total Post: 3
 Joined: Dec, 2008






 
what is trim

 khan
Posted: Dec 14, 2008 01:08:40 AM  

 Total Post: 3
 Joined: Dec, 2008






 
what is the like operator?

 balaji
Posted: Dec 17, 2008 01:33:07 AM  

 Total Post: 321
 Joined: May, 2008






 
In Rman backup and recovery,

Can anybody say , what type of questions will be asked from rman backup and recovery in interview ??

If anybody have faced some questions in interview regarding rman backup and recovery, kindly post it here.


Oracle 9i,10g
PLatform --- solaris,unix etc...

Thanks and Regards,
Balaji



 balaji
Posted: Dec 17, 2008 02:01:25 AM  

 Total Post: 321
 Joined: May, 2008






 

What is the purpose of the below setting enviroments?

PATH=
export PATH
ORACLE_BASE=/oracle/home
export ORACLE_BASE
ORACLE_HOME=/oracle/home/Oracle10g
export ORACLE_HOME
ORACLE_SID=orcl
export ORACLE_SID

Software --Oracle 10g
Platform --Solaris

Please revert me with the answer?

Thanks and Regards,
Balaji



 seenu
Posted: Dec 25, 2008 03:44:22 AM  

 Total Post: 106
 Joined: Apr, 2008






 
In RMAN how do we find if blocks are corrupted?

pls explain step by step?




 seenu
Posted: Dec 25, 2008 03:44:26 AM  

 Total Post: 106
 Joined: Apr, 2008






 
In RMAN how do we find if blocks are corrupted?

pls explain step by step?




 susk
Posted: Dec 29, 2008 12:21:48 AM  

 Total Post: 57
 Joined: Jan, 2008






 
Hi

I had question tht ; while performing incomplete recovery using UNTIL SEQUENCE method we query to v$log_history view & performs recovery giving sequence & thread . But i don't how to determine tht from which sequence & thread i hv to perform recovery is there any method to tht ? plz guide me how to determine sequence & thread no .


thnx in advance

 gaurav
Posted: Dec 29, 2008 02:11:05 AM  

 Total Post: 5
 Joined: Dec, 2008






 
please give the main points of differenciate between oracle 10g & oracle 9i

 colors
Posted: Dec 29, 2008 02:40:59 AM  

 Total Post: 21
 Joined: Oct, 2008






 
HI Gurus,

I'm practicing oracle9i on Linux platform.I have configured rman with 3 servers like Target - Rman utility - catalog (3 different ip address).

But now i would like to configure for my home(single) system,Can u plz suggest me the steps need to do and the configuration.



Thanks in advance

 chow
Posted: Jan 02, 2009 08:23:57 AM  

 Total Post: 9
 Joined: Dec, 2008






 
gurus n frnds plz suggest me n guide me in preparation of dba,
desperately needed somebodys great advices,
even though 'm taking the oracle dba classes,
'm not able to get the things in dba,,,,
'm just muggingup the concepts not able to get the concepts,,,
as the time instructor explaining ,it seems to be clear ,when it comes to practice, forgetting everything,,,,, things seemingly weired to me...
but 'm planning to 've attempt for my oca certification by the february end
guys plz plz help me out,,,,
i know that no one discuss these sort of issues here,,,,, with tis u can understand my saddened things....
'm fixed mentally to become a good dba ,,,, but in real 'm helpless
not only that things making me deppressed,,, can i be able to geton in dba
. ll it be possible to take certification for oca in TWO months... explain me the procedure........ the best way of regular practice...
plz plz guide me

urs
needy


 Srinivas
Posted: Jan 09, 2009 02:19:50 AM  

 Total Post: 3
 Joined: Dec, 2008






 
HI All,

While i am sending mail from $ prompt in linux(DB and applications are up and runnin g),Not able to receive the mail.

After shutting the DB and applications the mail is comming to my Inbox.

Please let me know any server ports i need to open or tune applications.

our applications and DB are in same server single node installation.

Thanks in advance,
Sreenivas.

 balaji
Posted: Jan 09, 2009 11:00:58 AM  

 Total Post: 321
 Joined: May, 2008






 
Hi,

How to backup and restore files to tape from os level(operating system).

Please revert me with the answer.

Product -- Oracle10g
platform -- solaris


Regards,
Balaji

 eyecycas
Posted: Jan 28, 2009 11:24:12 AM  

 Total Post: 15
 Joined: Nov, 2007






 
Hello,

I have a problem with the right syntax of RMAN RESTORE command, perhaps s.o. can help me?

I have 2 backups of my database:
-- backup1 from Monday
-- backup2 from Thuesday

Now 1 datafile of my database is corrupt.

For Recovery I wanna tell RMAN just to apply the Datafile-Backup of backup1, not 2 !!
The command should be
restore from backupset | datafilecopy

So my command is:
restore datafile 5 from datafilecopy '<imagecopy-backup-file>';
restore datafile 5 from backupset '<backupset-file>';

But this doesn't work. Am I have the wrong syntax?

Thanks for helping me.

eyecycas


 Kenny
Posted: Jan 29, 2009 09:24:39 AM  

 Total Post: 7
 Joined: May, 2008






 
Hi DBA's

I wish to know whether it is possible to migerate the database from dedicated to shared server mode and vice-versa ?

What will be the overall impact?

Can this be done while the database is open and operational?


Would appreciate to have your responses.

Thanks

Kunal



 seema
Posted: Feb 06, 2009 12:30:49 AM  

 Total Post: 83
 Joined: Jan, 2008






 
can you please send me link for datapump

export/import

Usermode
tablemode
tablespacemode
databasemode

all export/import commands???????? i want to know please help me.

 Kenny
Posted: Feb 07, 2009 08:02:19 AM  

 Total Post: 7
 Joined: May, 2008






 
Hi DBA's

Can you please answer as why it is strongly recommended of not to backup online redo log files incase of using RMAN.

I have read it on several forums and discussions board but not getting a justified answer.

Would appreciate if you can provide your views on it.

Thanks



 sonu
Posted: Feb 13, 2009 05:12:58 AM  

 Total Post: 53
 Joined: Feb, 2009






 
what are the utilities used to improve the performance of export/import?

 sonu
Posted: Feb 13, 2009 05:18:48 AM  

 Total Post: 53
 Joined: Feb, 2009






 
how we take hotbackup if our database is very big like 300gb or in tb?

 eyecycas
Posted: Feb 18, 2009 01:16:50 PM  

 Total Post: 15
 Joined: Nov, 2007






 
Hello folks!

I have a question about RMAN recovery.
I wanna do an incomplete recovery (set until time, set until scn, set until sequence#) and then open the database in READ ONLY mode to see if I got the right time, scn, sequ#.
I don't wanna use RESETLOGS on that time, just READ ONLY.
But the command "alter database open read only" doesn't work there. I always get an syntax error.
So can anyone tell me the right syntax?

RMAN>
run {
set until time '2009-02-17 15:22:10';
restore database;
recover database;
}
alter database open read only;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "resetlogs, ;"
RMAN-01008: the bad identifier was: read
RMAN-01007: at line 1 column 21 file: standard input


Thanks for help!

eyecycas.


 chini
Posted: Feb 20, 2009 12:24:08 AM  

 Total Post: 106
 Joined: Feb, 2009






 
can we import oracle 10g dump file to oracle,if it's possible how?

 Deepakkumar
Posted: Mar 09, 2009 05:48:22 AM  

 Total Post: 86
 Joined: Dec, 2007






 
can anybody tell how to recover system using cold backup.
using oracle 9i on rhel 3

 Avnish
Posted: Mar 12, 2009 03:33:04 AM  

 Total Post: 155
 Joined: Dec, 2007






 
Hi,

What is Incarnation? & How RMAN attached with that? Please suggest.

Thanks
Avnish

 sonu
Posted: Mar 16, 2009 03:51:41 AM  

 Total Post: 53
 Joined: Feb, 2009






 
what are parameters used in export/import and how we can improve the performance of export/import?

 sonu
Posted: Mar 16, 2009 03:52:40 AM  

 Total Post: 53
 Joined: Feb, 2009






 
what are parameters used in export/import and how we can improve the performance of export/import?

 sonu
Posted: Mar 16, 2009 03:54:56 AM  

 Total Post: 53
 Joined: Feb, 2009






 
what are parameters used in export/import and how we can improve the performance of export/import?

 sonu
Posted: Mar 16, 2009 04:00:55 AM  

 Total Post: 53
 Joined: Feb, 2009






 
how we run the backup script and other scripts?

 Deepakkumar
Posted: Mar 19, 2009 01:08:16 AM  

 Total Post: 86
 Joined: Dec, 2007






 
i am having two databases. one is sam and second is ram. can i import sam's export database in ram.or the database name should be same.

 Deepakkumar
Posted: Mar 19, 2009 01:10:34 AM  

 Total Post: 86
 Joined: Dec, 2007






 
can i import the export file of the database having different name.or the database name should be same for import.

 Deepakkumar
Posted: Mar 19, 2009 01:23:51 AM  

 Total Post: 86
 Joined: Dec, 2007






 
can i import in the database having different name from which the export has taken.or the database name should be same.

 Deepakkumar
Posted: Mar 19, 2009 01:27:14 AM  

 Total Post: 86
 Joined: Dec, 2007






 
can i import in the database having different name from which the export has taken.or the database name should be same.

 Azaz
Posted: Mar 23, 2009 02:41:12 AM  

 Total Post: 108
 Joined: Mar, 2008






 
I have created following table in 10gR2 on Windows

CREATE TABLE SERVICE_REQUESTS (
SVR_ID NUMBER(8,0) NOT NULL,
STATUS VARCHAR2(20) NOT NULL,
REQUEST_DATE TIMESTAMP(6) NOT NULL,
PROBLEM_DESCRIPTION VARCHAR2(4000) NOT NULL,
PROD_ID NUMBER(8,0) NOT NULL,
CREATED_BY NUMBER(8,0) NOT NULL,
ASSIGNED_TO NUMBER(8,0),
ASSIGNED_DATE TIMESTAMP(6)
)
NOLOGGING
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645);
when i do
1)desc service_requests
2) do select
i get error message ORA-03115 unsupported network datatype or representation
can anyone tell whats the problem and how to resolve it


 Azaz
Posted: Mar 25, 2009 03:54:20 AM  

 Total Post: 108
 Joined: Mar, 2008






 
I have Win2k3 64 bit.
I have installed Oracle 10gR2

I get this error
ora-12516 message 12516 not found
when i see in alert_log
it says
Process <process number> died, see its trace file

can anyone tell me what is this all about

 Deepakkumar
Posted: Mar 25, 2009 06:04:00 AM  

 Total Post: 86
 Joined: Dec, 2007






 
i want to import on oracle 9i 64 bit from oracle 9i 32 bit export backup.
what will be the procedure,as usaual or some another way.

 Deepakkumar
Posted: Mar 30, 2009 05:59:11 AM  

 Total Post: 86
 Joined: Dec, 2007






 
i am using statistics=none parameter while taking export. will there be any problem while importing database?
plz clarify.

 tonybank
Posted: Apr 09, 2009 02:15:16 PM  

 Total Post: 11
 Joined: Apr, 2009






 
P/s, can anyone help me on how to create a database to be used as the catalog for RMAN? Is it the same way to create the target database using DBCA or is it different. Need your help!!!

 ghani
Posted: Apr 13, 2009 01:07:07 AM  

 Total Post: 3
 Joined: Mar, 2009






 
how i convert numbers into words in oracle report.

like 23 to twenty three

 Deepakkumar
Posted: Apr 13, 2009 07:21:44 AM  

 Total Post: 86
 Joined: Dec, 2007






 
suddenly on one fine day i observed that the size of the back up decreased.(normally it increases) and from next day it starts increasing. i did not delete any rows or did delete any objects. i do not come to know how this happened.
for your reference i am giving every days back up size .
2.4.2009 146833408

3.4.2009 150560768

6.4.2009 157245440

7.4.2009 155246592

9.4.2009 151322624

10.04.2009 152371200

plz tell me about this variation.what factor might have effected.

 ghani
Posted: Apr 16, 2009 10:27:05 AM  

 Total Post: 3
 Joined: Mar, 2009






 
how i can convert number into words in oracle report.

When we create a certain amount invoice.like 5000 Rs. we want to print on this invoice at runtime "FIVE THOUSAND RUPEES"

Please give me the soultion.



 gopal
Posted: Apr 29, 2009 03:03:48 AM  

 Total Post: 7
 Joined: Mar, 2009






 
I am having HotBackup of my Database(datafiles and controlfile trace)server(1).
(flash recovery area is in storage box)
Using that backup am recreating the same database(using controlfile trace)
in another server(2), also placed the backup of datafiles to the correct location.
i set the db_recovery_dest as the old flash recovery area(storage box). can i
recover the database in that server(2)??

 balaji
Posted: Apr 29, 2009 06:02:52 AM  

 Total Post: 321
 Joined: May, 2008






 
Hi all,

I have configure rman backup and if i want to change the configuration settings how to do that?


Thanks in advance




 balaji
Posted: Apr 29, 2009 06:05:32 AM  

 Total Post: 321
 Joined: May, 2008






 
Hi all,

I have configured rman backup and if i want to change the configuration settings how to do that?


Thanks in advance

 chow
Posted: Apr 29, 2009 07:46:47 AM  

 Total Post: 69
 Joined: Apr, 2009






 
wats the difference btn 10g n 11g dba....
wat r the extra features added to 11g......
which is good to be trained in....
i'm alreay trained in 10g....
one of my frnd wants to join for dba training.....
which i can suggest him with ur suggestion.....
which is good ....which has more scope of job availability...
and also plz let me know...
which is the successful one inbetween them.....


 shivu
Posted: Apr 29, 2009 12:25:29 PM  

 Total Post: 71
 Joined: Nov, 2007






 
Hi,
How can we know that the Network architecture is 2-tier or 3-tier as a CLIENT MACHINE point of view????

Thanks in adv........

 Ahmed
Posted: May 02, 2009 06:11:36 AM  

 Total Post: 4
 Joined: Apr, 2009






 
Hi

I'm using Oracle 9i on Solaris 9. I'm taking hot backup through Rman.
I want to test Rman backup & restore on Test environment.


The test server having Oracle10g on solaris 10x86.

thanks in advance....!!!!!!!!!!!




 balaji
Posted: May 06, 2009 10:55:00 AM  

 Total Post: 321
 Joined: May, 2008






 
Hi all,

Is it necessary that recovery catalog schema must be stored separately from target database or it can be in target database.

Any specific reason?


Regards,
Balaji

 Ahmed
Posted: May 11, 2009 04:10:22 AM  

 Total Post: 4
 Joined: Apr, 2009






 
Hi all,

Production DB 9i
Solaris 9
Veritas 6.5
We backup our Oracle production database using Veritas Netbackup 6.5 with RMAN integration to tape.

Is it possible to perform a restore of a production db to a test server (new host) without having any affect upon the production db or the RMAN catalog.
Can the RMAN backup set for a particular db be restored at file level? If so then I could copy the RMAN files to test server and perform an RMAN recover using nocatalog.

Test Server Oracle10g on Solaris 10.

I bit confuse how to restore spfile & contrl file from auto backup.
I trying .......!!!!!!!!!!!

I copied pfile,spfile,control file move to new host on different directory & I already change the path of directories in pfile.

Test Server

--------------------------------------------------------------------------------
RMAN> target / nocatalog
RMAN> startup nomount pfile='/export/home/oracle/initpfile.ora'; ---DB started nomount mode.

Q. How I restore spfile & control file from autobackup? I have to connect Target DB with or wihtout Recovery Cat DB....and restore spfile & controlfile does it any affect on production db?

Has anyone performed anything similar and have a list of steps they could share with me.

Thanks


 sonu
Posted: May 11, 2009 09:11:37 AM  

 Total Post: 53
 Joined: Feb, 2009






 
what is the meaning of ignore=y in export/import?

 Deepakkumar
Posted: May 27, 2009 02:30:45 AM  

 Total Post: 86
 Joined: Dec, 2007






 
in my datbase there are three users. now i want to import the schema of two users only.which parameter i should use while exporting and inporting.

 oracleuser111
Posted: Jun 01, 2009 07:55:02 AM  

 Total Post: 2
 Joined: Jun, 2009






 
I created table mytable in oracle 11g in database Mydb1;
then,
performed following steps for cold backup on remote Share using rman commands.
I) Connect target /
II) shutdown immediate
III) startup nomount;
IV) sql 'alter database mount';
V) backup full tag full_offline_backup format '\\Machine_IP\Share_Name\%d_%U_%T'(database);
VI) sql 'alter database open';

After completing the backup ,i truncated the mytable. now i want to restorethis table from the backup i have taken so i performed following steps for restore,recovery using remote backup
I) startup mount
II) restore database;
III) recover database;
IV) alter database open;

but i m not getting my records in the table back.
What should i do to get mytable data.

can anyone help me please...
waiting for the reply...thanx in advance.

 Guddu
Posted: Jun 01, 2009 08:15:26 AM  

 Total Post: 18
 Joined: May, 2009






 
sir, kindly send me step by step command for import and export in oracle 9i and also send me step by step command for data pump in oracle 10g.

 sonu
Posted: Jun 04, 2009 08:07:16 AM  

 Total Post: 53
 Joined: Feb, 2009






 
how to verify the success of database backup???

 sonu
Posted: Jun 04, 2009 08:08:36 AM  

 Total Post: 53
 Joined: Feb, 2009






 
how to verify success of database archiving to tape???

 Deepakkumar
Posted: Jun 07, 2009 07:10:38 AM  

 Total Post: 86
 Joined: Dec, 2007






 
1 how to check if the database is in archive mode or not
2 please clarify if the database is in non archive mode the cold backup is useless.

 shivu
Posted: Jun 14, 2009 11:58:03 AM  

 Total Post: 71
 Joined: Nov, 2007






 
Hi Experts,
What is the difference between Oracle Net Services and Oracle Net???

thanks in adv....


 Guddu
Posted: Jun 15, 2009 05:59:06 AM  

 Total Post: 18
 Joined: May, 2009






 
i am using win. xp and when i write a query for export in 10g , i am connect as sysdba i will face this problem:


C:\>expdp 'system/sys' directory=datapump dumpfile=expdp_hr.dmp logfile=expdp_hr
.log schemas=hr;

Export: Release 10.2.0.1.0 - Production on Monday, 15 June, 2009 15:27:27

Copyright (c) 2003, 2005, Oracle. All rights reserved.

UDE-00008: operation generated ORACLE error 1017
ORA-01017: invalid username/password; logon denied

Username: system
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39170: Schema expression 'hr;' does not correspond to any schemas.




please solve this :

 sabari
Posted: Jun 17, 2009 04:23:29 AM  

 Total Post: 8
 Joined: Jun, 2009






 
Oracle DBA 9i/10g Real Time Oriented Training Course
available near at CHROMPET Railway Station, Chennai
by Working experieced DBA.

Contact : sabaridba@gmail.com

 Guddu
Posted: Jun 20, 2009 10:26:31 AM  

 Total Post: 18
 Joined: May, 2009






 
hi,


give me step by step for sql* loader.how can i implement sql * loader.

 sivakumar
Posted: Jun 26, 2009 11:50:05 PM  

 Total Post: 18
 Joined: Jan, 2009






 
in our production database, we have 5 tablespace, in that 2 tablespace are stored in SAN disk, rest of the three T.S are stored in local server, the problem is when i take backup of entire DB using RMAN the T.S stored in SAN disk RMAN takes used and unused blocks from the T.S in SAN disk.
but the rest of 3 T.S (which stored in local server) RMAN performs backups of used blocks only.

i would appreciate, if somebody could help me in this regard.



 soku
Posted: Jul 03, 2009 07:50:47 AM  

 Total Post: 35
 Joined: Nov, 2007






 

My production database(Oracle 10g) is on RHEL AS 4.0 64bit

My Newiable server is same as Proudction(same directory structure)

I am trying to restore latest Production cold backup in another newiable machine same as production.




When I tried to start Oracle, I got the following error:

ORA-00205: error in identifying controlfile, check alert log for more info.

Actually, there are three control files in the file, spfile$ORACLE_SID.ora. So, I do not know why this error should arise. I also checked the control files in the appropriate directory and they do exist,

In alret log file I have get the following errors
ORA-00202: control file : '/usr/oracle/oracle/product/10.2.0/oradata/proddb/control01.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information : 3

I am a newbie to Oracle and DBA in general.

Here is the procedure I used to connect in detail:



 sabari
Posted: Jul 14, 2009 03:39:10 AM  

 Total Post: 8
 Joined: Jun, 2009






 
Oracle DBA 9i/10g Project Oriented and RealTime Training Course
available near at CHROMPET Railway Station, Chennai
by Project Working excellent professional DBA.

Contact : 9994408197 EMailID: sabaridba@gmail.com

 karash
Posted: Jul 17, 2009 02:07:09 AM  

 Total Post: 45
 Joined: Dec, 2008






 
hi friends...

how much time will take for Rman full backup of 400gb database,data size may be nearly 300gb. And how much time will take for increamental backups?

 karash
Posted: Jul 17, 2009 02:08:53 AM  

 Total Post: 45
 Joined: Dec, 2008






 
hi friends...

how much time will take for Rman full backup of 400gb database,data size may be nearly 300gb. And how much time will take for increamental backups?



 karash
Posted: Jul 17, 2009 02:16:03 AM  

 Total Post: 45
 Joined: Dec, 2008






 

How to recover the table by using full rman backups and archive file backups.....

 karash
Posted: Jul 17, 2009 02:22:32 AM  

 Total Post: 45
 Joined: Dec, 2008






 


hi friends....
My production machine is running in archive log mode... suppose one of my archive file is missing while recovery of datafile. but recovery need that archive files how to recovery this problem?

 Guddu
Posted: Jul 20, 2009 12:15:15 PM  

 Total Post: 18
 Joined: May, 2009






 
sir,

kindly tell me if in my database some data are corrupt. how we get it.Is there any commnad for this. or can we do it by RMAN.Please give answers.

 Deepakkumar
Posted: Jul 25, 2009 12:52:58 AM  

 Total Post: 86
 Joined: Dec, 2007






 
in my database there are 3 user which belongs some tables.i am taking back up using syatem/manager .if i want to import the database and want the objects created by all user which command shall i give because if i use fromuser touser only the objects of that perticular tables will be imported then what about the objects,tables of another user?
plz clarify my doubt.

 karash
Posted: Jul 27, 2009 02:01:20 AM  

 Total Post: 45
 Joined: Dec, 2008






 

hi friends.....

In my production server one of the table was corrupted or dropped. how to restore the table ,while i have all backups and archive files.......

 mubs
Posted: Jul 30, 2009 12:44:14 AM  

 Total Post: 6
 Joined: Jul, 2009






 
can anybody please tell where i can find free books and tutorials on ORACLE Data WareHousing?

its urgent please..........

 mubs
Posted: Jul 30, 2009 01:50:57 AM  

 Total Post: 6
 Joined: Jul, 2009






 
Hi i need to set up new oracle lab for my college
I want to have one oracle server and 20 other clients .... i want to set it up for Data Warehouse practicals ...................... please post all the procedure..

 Ahmed
Posted: Aug 05, 2009 12:28:59 PM  

 Total Post: 4
 Joined: Apr, 2009






 

Dear All,

I have Oracle 9i DB on Solaris 9. I have cold backup of production DB. I want to restore that backup on different platform like windows 2003 server. Any help me out....!!!!

Thanks in advance...



Regs


Asif


 Prashant
Posted: Aug 10, 2009 06:41:21 AM  

 Total Post: 23
 Joined: Oct, 2007






 
Hi,

I would like to know that "How do i HIDE a particular column in a table ?".

E.g. I have one table called security_users and there is a column called password.I have encrypted password column But instead of that i would like to hide password column that no one could see it.

If it is possible then please let me know...
Prashant.

 Prashant
Posted: Aug 10, 2009 09:36:13 AM  

 Total Post: 23
 Joined: Oct, 2007






 
Hi guys,

Please provide me dump of IZO-007,IZO-031,IZO-032,IZO-033.

If it is possible then please send them to my mail id deprashant@rediffmail.com.

Your help will be incredibly appreciated.

Thanks in Advance.

Prashant.



 MSB
Posted: Aug 17, 2009 04:28:17 AM  

 Total Post: 30
 Joined: May, 2008






 
DBA's,

I moving around 22g of files from PROD to standby using scp. These are AIX server and are in two different countries. as a result it is taking long time.
Right now it's coping 15MB of data in every 1min. so according to my calculation it gonna take 25 hrs.

Can you give me some suggestion so that I can boost up this copy process. Its very urgent..

Thanks in advance.

 sabari
Posted: Aug 31, 2009 02:53:23 AM  

 Total Post: 8
 Joined: Jun, 2009






 
Oracle DBA 9i/10g New Features / RAC / DataGuard, Project Oriented and RealTime Training Course available near at CHROMPET Railway Station, Chennai by Project Working excellent professional DBA.

New Week end Batch Starts on 19-Sep-2009 Saturday
Contact : 9994408197 EMailID: sabaridba@gmail.com



 Deepakkumar
Posted: Sep 22, 2009 06:07:19 AM  

 Total Post: 86
 Joined: Dec, 2007






 
i am presently working on rhel3 32 bit oracle 9i. i have created one server with rhel4 64 bit oracle 9i.
now i want to restore the data file from rhel3 32 bit server to rhel4 64 bit server.
can i replace the datafile as it is from one server to another?
please clarify

 hassu
Posted: Oct 07, 2009 07:56:55 AM  

 Total Post: 2
 Joined: Nov, 2008






 
oracle RAC

 Deepakkumar
Posted: Oct 08, 2009 02:01:59 AM  

 Total Post: 86
 Joined: Dec, 2007






 
can we import from 9.2.0.4 (source) to 9.2.0.1(destination)

 RareDBA
Posted: Oct 20, 2009 08:24:37 AM  

 Total Post: 27
 Joined: Sep, 2007






 
Hello All,

I have a request from the client that they want to restore a database at a certain point like say Sep09,17th.

I have a fullbackup and incremental starting from Sep13 to Sep19.

All the backup were moved to tape and i had downloaded it all files starting from Sep13 to Sep17.

But the i do not have the backup controlfile, the auto backup controlfile was configured to default i.e ?/dbs/c-******-date.

As i did not have backup controle file i am unable to restore the database.

I had recreated the control file after taking the backup controlfile, but this request the recent fullbackup instead which was generated on 13th of Sep.

I have these backup files in my RMANDIR

-bash-3.00$ ll /rman/sten6/S20J05VA2/STEN6/
total 7635744
-rw-r----- 1 oracle dba 284200960 Sep 14 01:39 arch_696_1_697509408
-rw-r----- 1 oracle dba 744790528 Sep 15 01:05 arch_701_1_697593616
-rw-r----- 1 oracle dba 775003136 Sep 16 01:04 arch_706_1_697679957
-rw-r--r-- 1 oracle dba 61468 Sep 14 01:39 dbreport.S20J05VA2.STEN6.log
-rw-r----- 1 oracle dba 5688311808 Sep 14 01:36 full_693_1_697505415
-rw-r----- 1 oracle dba 1261568 Sep 14 01:36 full_694_1_697509392
-rw-r----- 1 oracle dba 206602240 Sep 15 00:59 incr_698_1_697591806
-rw-r----- 1 oracle dba 1261568 Sep 15 00:59 incr_699_1_697593592
-rw-r----- 1 oracle dba 71180288 Sep 16 00:58 incr_703_1_697678206
-rw-r----- 1 oracle dba 1261568 Sep 16 00:59 incr_704_1_697679942
-rw-r--r-- 1 oracle dba 23844 Sep 14 01:39 rmanFullBackup.S20J05VA2.STEN6.log
-rw-r----- 1 oracle dba 4608 Sep 13 17:23 spfileSTEN6.ora

After recreating the control files i tried to restore but received the below error
channel ORA_DISK_1: reading from backup piece /rman/sten6/S20J05VA2/STEN6/full_851_1_700615817
ORA-19870: error reading backup piece /rman/sten6/S20J05VA2/STEN6/full_851_1_700615817
ORA-19505: failed to identify file "/rman/sten6/S20J05VA2/STEN6/full_851_1_700615817"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup

Can anyone help me how to restore and recover the database without backup controlfile?

 nami
Posted: Oct 29, 2009 03:39:51 AM  

 Total Post: 1
 Joined: Dec, 2008






 
Hi,

I have a query regarding exporting data from oracle9i and importing to oracle8i and vice versa.

As per my findings:

1. The above is possible from oracle9i to oracle8i(please let me know how?).
2. The above is not possible from oracle8i to oracle9i(please lt me know the exact reason)?

Also correct me if i am wrong in above 2 scenarios.

Regards,
Aakriti

 sabari
Posted: Nov 02, 2009 11:07:17 AM  

 Total Post: 8
 Joined: Jun, 2009






 
Sabari - 9994408197 - Chennai

Oracle DBA - Database Administration in Oracle 9i DBA / Oracle 10g DBA New Fetures / RAC 10g / Dataguard 10g, Providing effective Training with Project Oriented and Real time focus with live scenario by excellent working DBA professional.

Located Near CHROMPET Railway station - Chennai

Post Oracle DBA Training

1. You can work in Oracle DBA project in MNC confidently
and professionally without fear.

2. You will be definite succeeded while doing your OCA or OCP Certifications.

3. You will be definite appointed while doing interview with you
on your Orcale DBA Career.


If you have any doubts or clarifications or any further details, do call me. Contact : 9994408197


Regards
Sabari, Chennai
sabaridba@gmail.com

Contact : 9994408197




 indra
Posted: Nov 03, 2009 04:21:16 AM  

 Total Post: 26
 Joined: Jan, 2007






 
Hi,
After daily Rman full backup there are a lot of hung Rman processes in the database everyday. Please help to get rid of the problem. My database is 10.2.0.1.

 indra
Posted: Nov 16, 2009 12:54:22 AM  

 Total Post: 26
 Joined: Jan, 2007






 
I am using Oracle 10.2.0.4 on RHEL AS5.

The following error occured when submitting
the job 'Bkp_Mgmt_orcl_000303': ORA-20900: Could not find credential
set DBHostCreds for target type oracle_database ORA-06512:
at "SYSMAN.MGMT_CREDENTIAL", line 649 ORA-06512: at
"SYSMAN.MGMT_CREDENTIAL", line 1309 ORA-06512:
at "SYSMAN.MGMT_JOBS", line 263 ORA-06512:
at "SYSMAN.MGMT_JOBS", line 48 ORA-06512: at line 1

Thanks in Advance


 BBC
Posted: Nov 16, 2009 02:08:31 AM  

 Total Post: 2
 Joined: Nov, 2009






 
Hi,
I am Java developer with SCWCD certified.
Now I am planning to shift to Oracle, for that I need a bit help from you people.
Can you guide me which oracle certification will be good for me as I am from Java background with 3 years of experience.

Awaiting for prompt response.

Regards,
Bhushan


 indra
Posted: Nov 25, 2009 05:47:09 AM  

 Total Post: 26
 Joined: Jan, 2007






 
Is it possible to take an Export from 10.2.04 and Import the data to 10.2.0.1 ? Please help.

 tak
Posted: Nov 26, 2009 09:32:01 AM  

 Total Post: 4
 Joined: Nov, 2009






 
Dear Database Support Professional,

I am Database Administrator and I am writing to ask for your help in responding to a 10-12 minute survey for a degree requirement on relational database support professionals in the USA. Please note that the respondent is completely anonymous. If I dont get this portion of my degree completed by the end of this semester, then I would have to wait for another year which entails additional costs and time on me. By completing the survey, you will be contributing to research in our field and also there is the satisfaction of having helped a fellow professional and a fellow human being attain his goals. I believe a good turn always bring another in some way in our lives. I therefore kindly beg for your help to a fellow database professional by completing this survey. The link to the survey is provided below. If possible please forward to other database professionals or groups:
http://www.surveymonkey.com/s.aspx?sm=a1JqU7GVt1g6rCkIPyL23w_3d_3d

Thank you earnestly for your kindness.

 snsatheesh
Posted: Nov 27, 2009 07:03:01 AM  

 Total Post: 1
 Joined: Nov, 2009






 
A rman full backup strategy is running in my database 10g. I need to configure it to rman incremental level 1 backup.
I am confused how to write the script. bcos first incremental level0 and then incremental level 1. kindly advice on dis

 shipon
Posted: Jan 10, 2010 09:58:25 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear Friends ,

I have two types of backup tape ,

1) HP DAT 72 SCSI tape drive (72 GB)

2) Ultrium 3 LTO tape drive (400GB)

Now For rman backup to HP DAT drive , I just run the below script :


run
{
allocate channel c1 type sbt_tape;
Backup as compressed backupset incremental level 0 database;
}

And its working fine .

But For 2nd One (Ultrium 3 LTO tape drive (400GB)) , I dont understand how can I recognize the LTO tape for RMAN . i.e.,

I want to create a script where RMAN take backup directly to the 2nd mentioned tape drive (Ultrium 3 LTO tape drive) , Would anybody plz help me ?

Waiting for kind reply ... ...


 sanuj
Posted: Feb 02, 2010 07:14:15 AM  

 Total Post: 4
 Joined: Jul, 2008






 
Hi All,

I am almost new to this forum.:)
I am using oracle 10g, I have a tablespace which contains 4 necessary files and 1 file got corrupted.
how can I restore that file without taking that tablespace offline?

 karash
Posted: Feb 05, 2010 02:41:52 AM  

 Total Post: 45
 Joined: Dec, 2008






 

Hi,

i did all the necessary steps needed to create duplicate db or clone using Rman Backups. But still i got this error......


C:\>RMAN TARGET SYS/SYS@ORACLE AUXILIARY SYS/SYS@CLONE

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Feb 5 12:30:53 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORACLE (DBID=1575844854)
connected to auxiliary database: CLONE (not mounted)

RMAN> DUPLICATE TARGET DATABASE TO "CLONE";

Starting Duplicate Db at 05-FEB-10
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=158 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/05/2010 12:31:02
ORA-01405: fetched column value is NULL

RMAN>



Give Solution to this problem.

 Sherlock
Posted: Feb 23, 2010 05:07:28 AM  

 Total Post: 1
 Joined: Feb, 2010






 
Hi

I have been doing some DRP testing & I have the backup set for a database. The test server has since been rebuilt. I have re-installed Oracle and now want to create a database using my backup set created by EM. Could anyone point me in the right direction to do this?

Thanks in advance!

 sabari
Posted: Mar 04, 2010 12:21:08 PM  

 Total Post: 8
 Joined: Jun, 2009






 
Oracle DBA - Database Administration in Oracle 9i DBA / Oracle 10g DBA New Features / RAC 10g / DataGuard 10g, Providing effective Training with Project Oriented and Real time focus with live scenario by an excellent working DBA Lead professional.

Located Near CHROMPET Railway station - Chennai

For complete details:

Visit: http://an-oracle-dba-training-portal.blogspot.com


Post Oracle DBA Training

You can work as Oracle DBA in Oracle DBA project in MNC with very good confident level and professionally without anxieties or doubts.

You will be definite succeeded while doing your OCA or OCP Certifications.

You will be definite appointed while doing interview with you on your Oracle DBA Career.



If you have any doubts or clarifications or any further details, do call me
Contact : 9994408197


Regards

Sabari
sabaridba@gmail.com

Contact: 9994408197




 Panky
Posted: Mar 24, 2010 03:24:23 AM  

 Total Post: 19
 Joined: Apr, 2009






 
Hello,
Iam on Linux with Oracle 10g as my database.
Everyday an automated backup happen at some xyz/abc location which created .dmp and .emp files.
When i looked into the cron i couldnot find this script which do the above work.
That me for this automated backup work there is not entry in Cron.

Does Oracle does these scheduling kindo work without cron???
If Yes, where can i see this entry in Oracle database.

Please suggest..

Regards,
Anirudh

 ramangill
Posted: Apr 01, 2010 10:56:36 AM  

 Total Post: 1
 Joined: Apr, 2010






 
Hey,

I have a question about the RMAN script I am using and how to use the storage parameters to point them to ASM so that all files can be created/recovered/deleted from the ASM disk cause currently, it creates some on the ASM and some on the local disk. Only thing on the local disk should be temp files which get deleted after...I would like to store everything on the ASM disk in a directory that I suggest.

Here is my code
[code]
run{
set AUXILIARY INSTANCE PARAMETER FILE TO 'C:\EDBTEST2_backup\oradata\auxdest\initoraaux.ora';
set newname for datafile 1 to "+DATA";
set newname for datafile 2 to "+DATA";
set newname for datafile 3 to "+DATA";
set newname for datafile 4 to "+DATA";
TRANSPORT TABLESPACE RAMANS_RMAN_TEST
TABLESPACE DESTINATION 'C:\EDBTEST2_backup\oradata\auxdest\TTS'
DATAPUMP DIRECTORY DATA_PUMP_DIR
DUMP FILE 'expdp_RAMANS_RMAN_TEST.dmp'
IMPORT SCRIPT 'impdp_RAMANS_RMAN_TEST.sql'
EXPORT LOG 'RAMANS_RMAN_TEST.log'
until time "to_date('30-MAR-2010 16:25:00','DD-MON-YYYY HH24:MI:SS')"
AUXILIARY DESTINATION 'C:\EDBTEST2_backup\oradata\auxdest';
}
[/code}

How do I get:
TABLESPACE DESTINATION 'C:\EDBTEST2_backup\oradata\auxdest\TTS'
to actually point to a location on the ASM disk.

I read on a ASKTOM article to include the DATAPUMP DIRECTORY DATA_PUMP_DIR which points to the ASM. For my test I pointed the directory DATA_PUMP_DIR locally to see where it would store the files. After the recovery completed, look at the output of where the files were recovered to and kept, which is not correct according to the ASKTOM article...and Tom is never wrong, LOL

*This is the datafile that got recovered*
(This file is small but in a real world scenario, my files may be many gig's and my local disk will not be able to store them, hence why I want them to be pointed to the ASM. But it seems like its being called from the OS side, which means the OS does not see the ASM...true/false?)
[code]
C:\EDBTEST2_backup\oradata\auxdest\TTS>dir
Volume in drive C has no label.
Volume Serial Number is 00CB-7314

Directory of C:\EDBTEST2_backup\oradata\auxdest\TTS

03/31/2010 12:24 PM <DIR> .
03/31/2010 12:24 PM <DIR> ..
03/31/2010 12:24 PM 2,108 impdp_RAMANS_RMAN_TEST.sql
03/31/2010 12:24 PM 10,493,952 RAMANS_RMAN_TEST.284.715018095
03/31/2010 11:31 AM <DIR> RUN1
2 File(s) 10,496,060 bytes
3 Dir(s) 42,569,873,920 bytes free
[/code]

*This is the Dump file that got created in the ORACLE Directory*
(If this pointed to the ASM, it would have created it there)
[code]
D:\DATA_PUMP_DIR>dir
Volume in drive D is Oracle
Volume Serial Number is 4611-C2C9

Directory of D:\DATA_PUMP_DIR

03/31/2010 12:51 PM <DIR> .
03/31/2010 12:51 PM <DIR> ..
03/31/2010 12:24 PM 86,016 EXPDP_RAMANS_RMAN_TEST.DMP
03/31/2010 01:06 PM 1,024 import.log
03/31/2010 12:24 PM 1,541 RAMANS_RMAN_TEST.log
3 File(s) 88,581 bytes
2 Dir(s) 278,368,256 bytes free
[/code]

Has someone ran into this? Can someone please help me out?!?!?! Desperate to figure this out.

 BAPPA
Posted: Apr 04, 2010 02:27:12 AM  

 Total Post: 11
 Joined: May, 2009






 
SIR/MADAM,

I AM ALMOST NEW IN ORACLE. PLEASE HELP ME. I AM USING ORACLE 9i IN WINDOWS XP USING SCHEMA TOAD.SIMPLY I HAVE DELETED A TABLE. HOW CAN I RESTORE THE TABLE ??

 BAPPA
Posted: Apr 04, 2010 02:28:04 AM  

 Total Post: 11
 Joined: May, 2009






 
SIR/MADAM,

HOW CAN I REDUCE THE SIZE OF UNDOTABS FILE.

 BAPPA
Posted: Apr 04, 2010 02:29:13 AM  

 Total Post: 11
 Joined: May, 2009






 
SIR/MADAM,

I AM USING ORACLE 9i IN WINDOWS XP/WINNT. SOMETIME IN MY ORACLE DATA FOLDER .DBF FILE HAS BEEN CORRUPTED HOW CAN I RECOVER THEM ?? PLEASE HELP ME..

 BAPPA
Posted: Apr 04, 2010 02:30:43 AM  

 Total Post: 11
 Joined: May, 2009






 
SIR/MADAM,

I AM USING ORACLE 9i IN WINDOWS XP AND WINNT. HOW CAN I TAKE COLD BACK UP OF DATA. PLEASE GIVE ME A BRIEF IDEA. PLEASE LET ME KNOW WHAT IS THE FACILITY OF COLD BACKUP.

 BAPPA
Posted: Apr 04, 2010 02:31:40 AM  

 Total Post: 11
 Joined: May, 2009






 
SIR/MADAM,

PLEASE LET ME KNOW WHAT IS ACTUAL DATA RECOVERY?? AND HOW CAN I RECOVER ANY DATA?? I AM USING ORACLE 9i IN WINDOWS XP AND WINNT.

 BAPPA
Posted: Apr 05, 2010 01:46:10 AM  

 Total Post: 11
 Joined: May, 2009






 
Sir/Madam,

I am using Oracle 9i with Windows XP/Winnt. I want to know whether the RMAN Backup is possible in this system or not. If possible Please let me know how I can take RMAN backup please...

 BAPPA
Posted: Apr 05, 2010 01:48:08 AM  

 Total Post: 11
 Joined: May, 2009






 
Sir/Madam,

I am working on Oracle 9i with Windows XP / Winnt. Please let me know How I can take Cold backup ?

 Hussain
Posted: Apr 12, 2010 05:06:34 AM  

 Total Post: 1
 Joined: Apr, 2010






 
I have Oracle Real Application Cluster (RAC) Database 10g installed on Windows 2003 Server

Database can be in mount state using RMAN
However, Alter database open; gives an error

RMAN-03002: failure of alter db command at 04/07/2010 10:06:53
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'N:\ORACLE\DEV\DB\APPS_ST\DATA\SYSTEM01.DBF'

Then, tried restoring data from previous backup taken using RMAN.
RESTORE DATABASE;
The RMAN freezes, however after few hours the Alert log file shows that RMAN has restored all the 44 datafiles.

Then tried recovery of data using RMAN
RECOVER DATABASE; which too failed with the following error:
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed datafile 1
ORA-00283: recovery session canceled due to errors
ORA-00314: log 2 of thread 1, expected sequence# 289 doesn't match 0
ORA-00312: online log 2 thread 1: 'N:\ORACLE\DEV\DB\APPS_ST\DATA\LOG02B.DBF'
ORA-00314: log 2 of thread 1, expected sequence# 289 doesn't match 0
ORA-00312: online log 2 thread 1: 'N:\ORACLE\DEV\DB\APPS_ST\DATA\LOG02A.DBF'

Could anyone please help me out with this Issue

 Ravi
Posted: Apr 13, 2010 03:23:53 AM  

 Total Post: 2
 Joined: Apr, 2010






 
Hi.Can anyone please tell me the file format of Oracle dbf files.It can be of any versions(8i,9i,10g,11g etc..).Please provide it.

 Deepakkumar
Posted: May 03, 2010 11:22:33 AM  

 Total Post: 86
 Joined: Dec, 2007






 
What is parfile and how to use it?

 bharat
Posted: May 03, 2010 11:54:32 AM  

 Total Post: 14
 Joined: Mar, 2009






 
i was doing a full database import,all tables were imported expect 2 tables,those 2 tables were created with datatype clob,and 2 tables were not imported,can anyone suggest how to import tables of datatype clob

 bharat
Posted: May 03, 2010 11:58:47 AM  

 Total Post: 14
 Joined: Mar, 2009






 
have a database of size 4gb,when backup is scheduled it is taking 2 days for entire backup of finish,its buffer is kept 2gb,can anyone suggest what might be the error,r what should i check so that backup time to be reduced,its a production box

 shipon
Posted: May 16, 2010 09:16:50 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear Friends,

I am using Oracle 10g . I can expdp a table 'T1' from a user 'shipon' like below :


C:\>expdp shipon/shipon directory=test_dir dumpfile=t1.dmp tables=shipon.t1

Export: Release 10.2.0.1.0 - Production on Sunday, 16 May, 2010 19:09:41

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SHIPON"."SYS_EXPORT_TABLE_01": shipon/******** directory=test_dir dumpfile=emp.dmp tables=shipon.t1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SHIPON"."T1" 8.390 KB 28 rows
Master table "SHIPON"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SHIPON.SYS_EXPORT_TABLE_01 is:
C:\TEMP\EMP.DMP
Job "SHIPON"."SYS_EXPORT_TABLE_01" successfully completed at 19:09:48



Now I want import it into another table 'T2' of same schema , but it shows the below error :

C:\>impdp shipon/shipon directory=test_dir dumpfile=t1.dmp tables=shipon.t2 table_exists_action=skip

Import: Release 10.2.0.1.0 - Production on Sunday, 16 May, 2010 19:10:20

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39166: Object EMP was not found.


C:\>impdp shipon/shipon directory=test_dir dumpfile=t1.dmp tables=t2

Import: Release 10.2.0.1.0 - Production on Sunday, 16 May, 2010 19:10:33

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39166: Object EMP was not found.



Would anybody plz tell me how can I import a table into another table using datapump ?

 shipon
Posted: May 16, 2010 09:18:33 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear Friends,

I am using Oracle 10g . I can expdp a table 'T1' from a user 'shipon' like below :


C:\>expdp shipon/shipon directory=test_dir dumpfile=t1.dmp tables=shipon.t1

Export: Release 10.2.0.1.0 - Production on Sunday, 16 May, 2010 19:09:41

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SHIPON"."SYS_EXPORT_TABLE_01": shipon/******** directory=test_dir dumpfile=emp.dmp tables=shipon.t1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SHIPON"."T1" 8.390 KB 28 rows
Master table "SHIPON"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SHIPON.SYS_EXPORT_TABLE_01 is:
C:\TEMP\EMP.DMP
Job "SHIPON"."SYS_EXPORT_TABLE_01" successfully completed at 19:09:48



Now I want import it into another table 'T2' of same schema , but it shows the below error :

C:\>impdp shipon/shipon directory=test_dir dumpfile=t1.dmp tables=shipon.t2 table_exists_action=skip

Import: Release 10.2.0.1.0 - Production on Sunday, 16 May, 2010 19:10:20

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39166: Object EMP was not found.


C:\>impdp shipon/shipon directory=test_dir dumpfile=t1.dmp tables=t2

Import: Release 10.2.0.1.0 - Production on Sunday, 16 May, 2010 19:10:33

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39166: Object EMP was not found.



Would anybody plz tell me how can I import a table into another table using datapump ?

 sherry
Posted: May 28, 2010 02:40:17 AM  

 Total Post: 1
 Joined: May, 2010






 
Hey Guys!
Can you please send me the details steps for setting up dataguard in oracle 10g on Windows 2008.

 Araj
Posted: Jun 12, 2010 07:56:22 PM  

 Total Post: 9
 Joined: Jun, 2010






 
Oracle Axe Ltd. is a leading training provider on Oracle suite of products. We engage top industry consultants in providing sharing their knowledge and experience to the emerging consultants. The best part of our training is online knowledge sharing anywhere and anytime. We provide training of industry's best technologies including:
Cloud Computing
Oracle Database (DBA, Dev SQL, PL/SQL etc)
Oracle Database Options (Real Application Cluster, Data Guard etc)
Oracle SOA Suite
Oracle Enterprise 2.0 suite (Content Management and Portals)
Oracle Applocations (eBusiness Suite, JD Edwards, Financials etc)

For more information about us please visit www.oracleaxe.com

Have a question? Feel free to contact us at aryan.raj@oracleaxe.com with your contact number and one of our consultant will contact you soon.

Thanks,
Aryan

 vinay
Posted: Jul 08, 2010 07:24:20 AM  

 Total Post: 2
 Joined: Jul, 2010






 
wt is use of RMAN otherthan BACKUP?

 Mahendra Rathod
Posted: Jul 14, 2010 12:36:44 AM  

 Total Post: 136
 Joined: May, 2008






 
HI GURUS,

u r trying to take a full rman backup with one read-only tablespace. will it succeed ?
if yes, can you restore it ?

advance thanks.


 Mahendra Rathod
Posted: Jul 14, 2010 01:15:08 AM  

 Total Post: 136
 Joined: May, 2008






 
hi what will happen in below situation:

i have 40 archive logs among these 20 are zipped(zip files) and i fired 1-> backup archive log ;
2-> restore archive log delete all;

--> my intention is to make the space free.

 Mahendra Rathod
Posted: Jul 14, 2010 01:18:49 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus,

what are main 3 purposes to rebuild an index?

advance thanks

 Mahendra Rathod
Posted: Jul 14, 2010 01:20:26 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus

which are the 3 critical situations when we NEED to rebuild the index?

advance thanks

 Mahendra Rathod
Posted: Jul 14, 2010 01:21:22 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus,

what if i make primary key constraints on all the columns of a table ?

advance thanks

 Mahendra Rathod
Posted: Jul 14, 2010 01:24:39 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus

what will to say to answer....

what is the size of your database and backup?

why is there some difference?


advance thanks

 Mahendra Rathod
Posted: Jul 14, 2010 01:27:43 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus,
Lets help each other to prepare for next interview..
--------------------

i m out of space and i need to export the full database. what shall i do?

advance thanks

 Mahendra Rathod
Posted: Jul 14, 2010 01:29:46 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus,
Lets help each other to prepare for next interview..
--------------------
what is the difference between system managed tablespace and locally managed tablespace?

thanks in advnce

 Mahendra Rathod
Posted: Jul 14, 2010 01:30:46 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus,
Lets help each other to prepare for next interview..
--------------------

tell the banifits of ASM?

what is ASMM in oracle?

very much thanks in advance.

 Mahendra Rathod
Posted: Jul 14, 2010 01:33:37 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus,
Lets help each other to prepare for next interview..
--------------------

how to find & kill the locking processes on AIX?

what is the command to check CPU user on AIX?

how to find files older that 1 year on AIX?

much advance thanks

 Mahendra Rathod
Posted: Jul 14, 2010 01:38:19 AM  

 Total Post: 136
 Joined: May, 2008






 
hi gurus,
Lets help each other to prepare for next interview..
--------------------

i take a full backup of my database... then i delete a table from the database.... now i restored that full backup...but i cant find the table which i deleted after that backup
HOW COME ?

THANKS IN ADVANCE

 GKumar
Posted: Jul 20, 2010 10:29:48 AM  

 Total Post: 1
 Joined: Jul, 2010






 
Please let me know if exporting Oracle10g R2 RAC data and import in 11g RAC ASM will work or not. Also please provide the steps.

OS is Oracle Enterprise Linux version 4
Database: 10.2.0.4 and 11.2.0.1

Also if any other method is available plz let me know with steps.



 kumar
Posted: Sep 03, 2010 09:22:20 AM  

 Total Post: 2
 Joined: Sep, 2010






 
Hi,

I need your help to find out the duplicate entries in RMAN.

1. The database name is GUTI
2. Restored the db GUTI in different server using RMAN hot backup.
3. Open the dublicate database with the same database name GUTI.
4. Currently i could not run the backup of duplicate database.getting the below error = ORA-01422.

resync catalog ;

starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 07/01/2010 21:02:52
ORA-01422: exact fetch returns more than requested number of rows


Could you please let me know any suggestion on this.


 Strak
Posted: Sep 15, 2010 08:01:12 AM  

 Total Post: 3
 Joined: Sep, 2010






 
I'm having a problem with performing backups from EM DB Control on two of my Oracle 10g 10.2.0.4 systems. When I configure and submit any backup job from EM (either online or offline), the following happens:

- When the job is due to run a Pre backup task has status of 'Scheduled'
- Prebackup task completes and status changes to 'Succeeded'
- Backup task appears with status of 'Scheduled' and value of started time within the next minute
- Status of backup task never changes from 'Scheduled', and the started time keeps updating to the current time
- This goes on indefinitely until I abort the job

At the moment I have scheduled tasks configured to run an RMAN job every night, but I need to get this working through Enterprise Manager Database control. Please help!

Something else which has happended on one of these systems is that after applying some Microsoft Critical updates the database control service would not start. The only way I could find to resolve this was to recreate the Enterprise Manager repository. Could there be a link here at all?

Cheers,
Strak

 Delia
Posted: Oct 26, 2010 08:55:04 PM  

 Total Post: 125
 Joined: Jun, 2010






 
Test IBM 000-106: Power Systems with POWER7 Common Technical Sales Skills - v1
Exam Number/Code: 000-106
Exam Name: Power Systems with POWER7 Common Technical Sales Skills - v1
Questions and Answers: 41Q&As
Updated: 23-10-2010

Passcert provides high quality IBM 000-106 dumps. It is the best and the lastest IBM Practice Exams. Furthermore, we are constantly updating our Passcert 000-106 Exam. These Exam Resources updates are supplied free of charge to Passcert customers. If you have any question about Passcert 000-106 braindumps, please feel free to contact us at any time.

Related Exam:
000-977: Power Systems with POWER7 Common Sales Skills - v1

 Younus
Posted: Nov 09, 2010 04:46:08 PM  

 Total Post: 1
 Joined: Nov, 2010






 
can any one explain how to recover database
withought having backup of data files ?????

 Delia
Posted: Nov 10, 2010 08:21:05 PM  

 Total Post: 125
 Joined: Jun, 2010






 
Passcert 9L0-062 dumps for Apple certification are easily available on the internet. Now you need not hanker after the study materials in the market. Passcert Apple 9L0-062 dumps help materialize your dreams of success with minimum effort. 9L0-062 dumps are the choice of all IT professionals who aspire to obtain Apple 9L0-062 certification. Some of the websites on certifications provide free 9L0-062 dumps to help the IT professionals in their studies for Apple certifications.

Jill uses her MacBook late at night and occasionally has to restart. Despite having muted the speaker
volume the MacBook always boot chimes loudly after restart. What step should you try first to resolve this
issue?
A. Reset the SMC.
B. Reset the PRAM.
C. Reinstall Snow Leopard.
D. Repair disk permissions.
Answer: B

 Delia
Posted: Nov 11, 2010 08:29:47 PM  

 Total Post: 125
 Joined: Jun, 2010






 
A company has installed a new 802.11g point-to-point connection between two buildings and is
experiencing low throughput across the link. The current setup involves a wireless bridge on the roof with
an omni-directional antenna. Which of the following would BEST improve the link performance?
A. Replace the wireless bridges with wireless access points.
B. Install bi-directional amplifiers at both sites.
C. Configure channel hopping on both wireless bridges.
D. Replace the omni-directional antennas with Yagi antennas.
Answers: D

A company is upgrading from DSL to a new T1. When the ISP sends a technician out, the technician
will terminate the T1 at which of the following locations in the building?
A. Patch panel
B. Firewall
C. Switch
D. Demarc
Answers: D

The CompTIA N10-004 practice test that Passcert can provide are based on the extensive research and real-world experiences from our online trainers, with many years of IT and certification experience. Custom written content for on-the-go professionals such as yourself. N10-004 exams, including N10-004 questions and answers feed into our larger product base.

 Delia
Posted: Nov 23, 2010 08:27:11 PM  

 Total Post: 125
 Joined: Jun, 2010






 
70-648: TS: Upgrading MCSA on Windows serv 2003 to Windows Serv 2008
Exam Number/Code: 70-648
Exam Name: TS: Upgrading MCSA on Windows serv 2003 to Windows Serv 2008
Questions and Answers: 80Q&As
Updated: 13-11-2010

You get quality 70-648 exam information from reliable IT community members who have already passed their 70-648 torrent and are using Microsoft technologies on a daily basis. Use Passcert brain dumps to advance your own career and then help those who come behind you by creating a new 70-648 questions and answers sample tests with what you find most valuable as a successful and passing Microsoft 70-648 exam.

 Anki
Posted: Nov 30, 2010 12:43:38 PM  

 Total Post: 2
 Joined: Nov, 2010






 
Hi,

Can anyone please tell me steps to restore the existing cold backup..


thanks in advance,
Anki

 Delia
Posted: Dec 09, 2010 10:28:16 AM  

 Total Post: 125
 Joined: Jun, 2010






 
Passcert 1Z0-144 study guide resources can prove most valuable when facing the challenging 1Z0-144 practice test. So if you are one of the many searching for good quality 1Z0-144 study guide, we highly recommend Passcert as it will be sure to provide you with a better 1Z0-144 review than many other websites out there. Instead, select Passcert, as it will provide you with a superior quality product better than any free 1Z0-144 exam available online today.

Good News: Passcert now offer you 25% discount for all the products, which promote is "Christmas". This activity will last to 30th, Dec.. So come on, everybody, coming into Passcert.com hall now.

 Delia
Posted: Dec 10, 2010 11:14:17 AM  

 Total Post: 125
 Joined: Jun, 2010






 
Passcert ST0-29B study guide resources can prove most valuable when facing the challenging ST0-29B practice test. So if you are one of the many searching for good quality ST0-29B study guide, we highly recommend Passcert as it will be sure to provide you with a better ST0-29B review than many other websites out there. Instead, select Passcert, as it will provide you with a superior quality product better than any free ST0-29B exam available online today.

 Delia
Posted: Dec 11, 2010 12:01:59 PM  

 Total Post: 125
 Joined: Jun, 2010






 
Passcert is trying best to provide all service for our customer with high speed and efficiency to save your valuable time. Symantec ST0-29B braindumps offer a number of exam guide for preparation, including the braindumps, and the ST0-29B study notes,ST0-29B study guide,ST0-29B demo Other training Materials includes the practice exams and the Symantec ST0-29B Braindumps.

 Delia
Posted: Dec 12, 2010 08:25:38 PM  

 Total Post: 125
 Joined: Jun, 2010






 
If you are looking to pass IBM 000-M41 exam, then Passcert has the perfect solution for you. Get Passcert 000-M41 exam and be on your way to passing today. Its like having an automatic guarantee of passing because the IBM 000-M41 exam is tough. With our Passcert tools,you can pass 000-M41 exam easily.

With the help of the Passcert study materials and guidance of IBM 000-M41 certification exam, you can pass your IBM 000-M41 certification exam in your first attempt. Passcert study materials of 000-M41 is composed by the contemporary and dynamic Information Technology experts.

 Delia
Posted: Dec 13, 2010 08:41:43 PM  

 Total Post: 125
 Joined: Jun, 2010






 
Passcert has designed HP0-P12 preparation kit to help you get certified effortlessly. Now you do not need to spend your time and money searching for study materials, books, etc., this HP0-P12 exam preparation kit contains everything you need to get certified, Just follow the instructions, focus on the study material and getting certified will be easy.

 sanny
Posted: Mar 05, 2011 01:43:54 AM  

 Total Post: 85
 Joined: Mar, 2011






 
000-056: Rational BuildForge v7.1
Exam Number/Code: 000-056
Exam Name: Rational BuildForge v7.1
Questions and Answers: 61Q&As
Updated: 02-28-2011

Its Exam 000-056 Preparation Material provides you everything you will need to take your 000-056 Exam. The 000-056 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

Related Exam: 000-M63

 adminauto
Posted: Apr 13, 2011 01:54:57 AM  

 Total Post: 6
 Joined: Apr, 2011






 
We are using oracle 9i. We have multiple branches in various locations. Our requirement is daily updation of the modified data by the branches at head office (incremental backup and restore at head office) kindly suggest the solution

Harish


 loukik
Posted: Jun 17, 2011 12:54:19 AM  

 Total Post: 3
 Joined: Jun, 2011






 
Hi,
I am recovering my Oracle database and get this error plz guide me..

RMAN-06067 RECOVER DATABASE required with a backup or create control file...

this option is also not working ALTER DATABASE CREATE CONTROLFILE.

Plz suggest some solution.

 chetan
Posted: Jul 22, 2011 01:22:02 AM  

 Total Post: 2
 Joined: Jul, 2011






 
what is materialized view

 chetan
Posted: Jul 22, 2011 01:29:12 AM  

 Total Post: 2
 Joined: Jul, 2011






 
RMAN-00571

 hardik
Posted: Jul 25, 2011 07:59:33 AM  

 Total Post: 1
 Joined: Jul, 2011






 
Hi Every1,
I took backup of a database as a SYS user, and restored the database in other machine using System user.
The issue was that, the table structure of a few tables was'nt same(der were a few extra columns in a few tables in the backed up database).
So when i tried to import the backed up database in another system which had old table structure, it din import correctly...
the Table structure was still the old one and there was no data in any of the tables...However when I deleted those tables and tried importing,
it imported successfully, and the new table structure along with the data got reflected...I still could'nt figure out where was I wrong (since im new to it).
Do I always need to delete the tables which are altered and import the database??? or is there a way to overwrite the old structure of the table with the new structure.
Kindly let me know guys.... im using Oracle 11g and am new to it....

this was d export command i used to take backup

exp lsone/lsone file=newbkp.dmp log=newlog.log owner=lsone

this command was the one to import the dump file
imp system/manager file=newbkp.dmp log=import.log fromuser=lsone touser=dev;

Would appreciate your reply!! Thanks in advance

 happyjolie
Posted: Aug 04, 2011 03:22:47 AM  

 Total Post: 84
 Joined: Nov, 2010






 
The latest CompTIA Server+ Certification SK0-003 exam has been updated in Killtest, the SK0-003 exam mateirals are all current and very useful for your study.

Because these SK0-003 practice exam questions are composed by the professional and knowledgabe experts who work in Killtest. Killtest can pursuade that you can pass your CompTIA Server+ Certification SK0-003 exam by your first attempt and get your CompTIA Certificantion without any effort.

http://www.killtest.com/Server/SK0-003.asp

http://my.opera.com/xanndy/blog/2011/08/04/comptia-sk0-003-certification-exam

 41430461
Posted: Sep 16, 2011 08:28:32 PM  

 Total Post: 16
 Joined: Sep, 2011






 
There are many medical and police shows across the television dial and I am always happy when a show can add a wrinkle or different look to the same genre. Whether it is Monk's OCD or wtaching someone dissappear at the beginning of Without A Trace. Criminal Mind adds its own twist by looking at the cases from the minds of the criminal and bulding a profile.
Though the show is still good, Mandy Patinkin was great during his time on the show. There are a couple of small issues with the show, sometimes when it tries a bit hard to lighten the mood seems a bit forced and out of context in terms of the show itself (as oppossed to Monk, for instance, where it is more part of what is going on), but still a nice change to standard police shows.
You should check it out at the least and see what you think. I was not for it at first, but it grew on me and kept growing, leaving little to fall back on. That's good, too, and better still when you recall what it all is. It is big and bulky and sexy and more. I love that, too, and rate it a 5 straight because it tries and succeeds here morethan anywhere else.
http://www.dvdhotdeal.com/criminal-minds-seasons-1-6-dvd-boxset.html

 41430461
Posted: Sep 16, 2011 08:29:46 PM  

 Total Post: 16
 Joined: Sep, 2011






 
I stumbled upon "One Tree Hill" after a good friend of mine mentioned it. I took a look at the box and sniffed. I avoided watching it for months, thinking it would be a cheap knockoff of "Dawson's Creek". I wanted something fresh and original. It took one episode to get me totally hooked, and "One Tree Hill" lived up to my high standards
Ok, so the basic plot is about half brothers: Nathan and Lucas, and basketball. Lucas (the main character) lives with his mom, and plays basketball outside of school. Nathan lives with his father, (also Lucas' father) who was a basketball star, and wants his son to follow in his footsteps. Nathan's father denies being Lucas' father, but everyone knows that he is. Lucas is invited to play varsity basketball with Nathan, which starts a conflict between the brothers, who had avoided one another previously. The entire show involves Lucas and Nathan and their friends and family, and makes the audience wonder how it will turn out.
Now, I am pretty picky when it comes to TV shows. I want them to be original, interesting and engaging, and leave the audience wanting more. This is a more adult show than most of today's teenage dramas, making it an excellent show for teens and their parents, or just us adults. ;) The characters are all well-rounded and have unique and interesting personalities, and are not your stereotypical "popular crowd". Each character has a unique trait that makes them easy to relate to.
http://www.dvdhotdeal.com/one-tree-hill-seasons-1-8-dvd-boxset.html


 41430461
Posted: Sep 16, 2011 08:30:16 PM  

 Total Post: 16
 Joined: Sep, 2011






 
This series is just in a simple word: fabulous! It has everything you could ask for. There's interesting crimes, delightful humor, a fascinating and fantastic supporting cast and of course the two gorgeous leads that have some of the best male/female chemistry to ever grace the small screen. They simply force the viewer to enjoy them as they weave their way toward a personal and loving relationship via their crime-solving opportunities. If ever there were two people made for each other, it is Booth and Brennan.
Season 4 brings perhaps the quirkiest and most light-hearted year of the series yet as it begins across the pond with the fabulous duo in Britain while back at the lab the incomparable Zack is replaced by a host of fun and zany lab assistants. Season 4 introduces us to Booth's brother who shows up to throw a wrench into his personal life and eventually help him grow even closer to his maddeningly logical genius of a partner. Brennan's dad and Booth's son make appearances and the Gravedigger from Season 2 also makes a return appearance. The season's final six episodes are just mind-blowingly excellent as we see Booth and Brennan grow ever closer and even consider having a baby together!
Buying such a well-written, fun, zany and superbly acted series on DVD is a no brainer. Get your own copy because you are not borrowing mine!
http://www.dvdhotdeal.com/bones-seasons-1-6-dvd-boxset.html

 41430461
Posted: Sep 16, 2011 08:30:46 PM  

 Total Post: 16
 Joined: Sep, 2011






 
"Greys Anatomy" can be a play on words. Meredith is finding herself, not only in the surgical world, but in her personal life. Her mother is a surgeon suffering from Alzheimer's, her father is dead. She falls in love with the handsome Chief Neurosurgeon, Dr. Derek Shepard played by Patrick Dempsey. She later finds out he is married to a pediatric surgeon. Her new roommates are all surgical interns: T.R. Knight as bumbling, inept, George O'Malley; Sandra Oh, as Cristina Yang , one of my favorites, and Katherine Heigl as Isobel "Izzie" Stevens. Cristina Yang has a one night affair with the hunky,Chief Surgical Resident, Preston Burke; that moves onto "true" lust. They are so diametrically different that the old saying" opposites attract" is, oh, so true. And, then, there is "The Nazi",Chandra Wilson as Dr. Miranda Bailey. She whips the new interns into shape and keeps them on their toes. It turns out she has a heart as big as Kansas, but then, don't they all?
The show is funny, has lots of drama, unrealistic at times and then more than real at other times. The workings of a real hospital? I will leave that for you to decide. The drama of every day in the life of a surgical intern. Too much work, too little time, but these interns always find time for the personal stories of their patients and, this is where the shows true colors come shining through. The humanness of physicians and the people they care for; the love and dedication it takes to help someone become well, and the sadness and gloom of a death. The open heart surgery in an elevator by a first year surgical intern is hard to believe, but somehow it works. This is a TV show that works as well. The personalities ring true; we like them, we want them to succeed. Highly recommended. prisrob
http://www.dvdhotdeal.com/greys-anatomy-seasons-1-7-dvd-boxset.html

 sanny
Posted: Oct 28, 2011 10:10:09 PM  

 Total Post: 85
 Joined: Mar, 2011






 
To help you prepare EC-COUNCIL certification 312-38 exam, Ourexam recommends you that you should have the sound knowledge and experience about 312-38 exam. Ourexam has designed 312-38 exam questions to help you get certified easily. Get 312-38 free practice test, 312-38 questions and answers, 312-38 brain dumps, 312-38 pdf and 312-38 study guide.

http://www.ourexam.com/312-38.html

 mit
Posted: Nov 12, 2011 01:29:09 AM  

 Total Post: 60
 Joined: Sep, 2006






 
Hi ,

I have only RMAN and Controlfile backup,I want to restore this backup to
new location with same db name
I created instance with same db name,created parameter file and done the following steps on RMAN prompt,
1)restored controlfile from 'path and name of controlfile'
2)alter database mount
3)catalog start with 'path where i kept rman and controlfile backup'(path is differnet from original RMAN backup path)
4)now when I am giving following command it is giving error message,
ORA-19870:error while restoring backup piece(and showing original path of RMAN backup)


Thanx


 sailu
Posted: Dec 08, 2011 12:51:21 AM  

 Total Post: 13
 Joined: Oct, 2011






 
Hi friends,,

My database is in noarchive log,

The control files is losted due to hard disk failure,

The whole backup is avaiable but I dont have the current backup,

How to recover the current backup?


----Give solution?---

 parihar
Posted: Feb 10, 2012 05:59:47 AM  

 Total Post: 4
 Joined: Dec, 2011






 
Hello gays pls tell me syllabas of oca exam. only sql or plsql is sufficent or want extra syllabas..

 shipon
Posted: Feb 19, 2012 01:44:18 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear all ,

Would anybody plz tell me If I run expdp using "exclude=index" , then when I run the impdp from this specified dump into another schema, then all the index will be imported since the export dump takes without index ?

I brief a scenario :

1)Let I have a schema TEST1 which has 164 index , I export (using expdp) a dump from TEST1 schema using "exclude=index" .

2) Now I run import (impdp) from this specified dump to another schema using remap_schema=test1:test2 , then I saw 153 index are imported .

Now my question :

How the above 153 index are imported since my dump has no index ? and why is this 153 , where are the others 11 index ?

Would anybody explain this situation ?



 shipon
Posted: Feb 19, 2012 01:44:44 AM  

 Total Post: 75
 Joined: Feb, 2008






 
Dear all ,

Would anybody plz tell me If I run expdp using "exclude=index" , then when I run the impdp from this specified dump into another schema, then all the index will be imported since the export dump takes without index ?

I brief a scenario :

1)Let I have a schema TEST1 which has 164 index , I export (using expdp) a dump from TEST1 schema using "exclude=index" .

2) Now I run import (impdp) from this specified dump to another schema using remap_schema=test1:test2 , then I saw 153 index are imported .

Now my question :

How the above 153 index are imported since my dump has no index ? and why is this 153 , where are the others 11 index ?

Would anybody explain this situation ?



 labdata
Posted: Mar 01, 2012 04:40:51 AM  

 Total Post: 1
 Joined: Mar, 2012






 
i have 2 db with multiple table in both db. i want to entery of data in both db regulary and randomly parally or simultaneously plz help me


...........thank.......

 mashok
Posted: Mar 01, 2012 05:47:35 AM  

 Total Post: 16
 Joined: Feb, 2012






 
Hi All,

Can any one explain me the understanding of 11gR2 New features , that is , OCR file & VOte disk can store in ASM disk.

My question is that , If we store these files in ASM -disk , In case if asm instance is goes down , What will happent to the cluster . ? Is this a good feature ? Or any new things has added in this 11gR2 .

Please advice me if i am wrong ...


rgds
ashok

 dfathy
Posted: Apr 01, 2012 06:21:46 PM  

 Total Post: 2
 Joined: Apr, 2012






 
I'm working on restoring a full backup taken by RMAN from RAC to a single instance. I created a PFile from SPFile of RAC and copied it to the single instance server.

I changed some parameters like audit_file_dest, diagnostic_dest, log_archive _dest, control _files to the path that is used on that server and i removed some parameters like db_create_file_dest, db_recovery_file dest, db_file _name_convert, log_file_name_convert, thread=2 and every parameter contain the word cluster .

The database name of the RAC is different from the database name of the single instance server. So i got confused about the db_name parameter should i change it or leave it before i start up the database using this parameter file

Could any one help me out, please ?

Thanks

 JAMIEKATE
Posted: Apr 15, 2012 06:13:32 AM  

 Total Post: 2
 Joined: Apr, 2012






 
<a href="http://jamiekate.noahblog.com/files/2012/04/Louis-Vuitton-Keepall-45-Damier-Infini.jpg"><img class="alignnone size-full wp-image-4" src="http://jamiekate.noahblog.com/files/2012/04/Louis-Vuitton-Keepall-45-Damier-Infini.jpg" alt="" width="559" height="473" /></a>

I have a new crush and it is on the<a href="http://www.wbrandbag.net/Product_detail.asp?id=3238"> Louis Vuitton Damier Infini</a> line. Vlad and I saw this piece in the SoHo store a few weeks ago and since then, I cant stop thinking about it. I want Vlad to have the Keepall 45 for himself, but in all honesty, I think I secretly want him to get it so I can use it myself on weekend trips.

The Damier Infini line gives <a href="http://www.wbrandbag.net/">Louis Vuitton Handbags</a> lovers the Damier pattern in a new rendition. The iconic Damier motif in soft calf leather speaks to the <a href="http://www.wbrandbag.net/products.asp?smallid=100&amp;bigid=2">LV Luggage</a> lovers heart, offering an elegant finish to a contemporary house favorite.

As for the Keepall 45, this bag is timeless. With the additional shoulder strap, the bag can be used as an everyday hold-all (hence, the name Keepall) while also working ideally for weekend trips. The interior is lined with traditional Louis Vuitton cotton canvas. One of my favorite aspects of this bag is the super chic look of the brushed titanium hardware. While there are also white and red versions, the black has my heart. Price is $2,730 via Louis Vuitton. But on wbrandbag.net it is cheaper more.

Tags:<a href="http://www.wbrandbag.net/">Fake Louis Vuitton</a> Handbags <a href="http://www.wbrandbag.net/">Chanel Bags</a>

 chonkpouo
Posted: Aug 26, 2012 02:20:07 AM  

 Total Post: 2
 Joined: Aug, 2012






 
wholesale gucci clothing www.likechinashop.com
replica dolce & gabbana shoes www.likechinashop.com
cheap gucci shoes www.chinaurbanstore.com
cheap louis vuitton clothing www.chinaurbanstore.com
burberry shoes outlet www.icheapoutlet.com
cheap louis vuitton clothing www.icheapoutlet.com
replica gucci belts www.realbelssale.com
cheap burberry belts www.realbeltssale.com
louis vuitton belts outlet www.beltsonlinesale.com
luxury armani belts www.beltsonlinesale.com
cheap gucci jeans www.urbanbrandclothes.com
replica gucci clothing www.icheapoutlet.com
replica armani clothing www.chinaurbanstore.com

cheap coogi clothing www.urbanbrandstore.com
cheap louis vuitton belts www.brandbeltsoutlet.com
cheap gucci jeans www.urbanshoessale.com
cheap coogi clothing www.urbanshoessale.com

 chonkpouo
Posted: Aug 26, 2012 02:20:55 AM  

 Total Post: 2
 Joined: Aug, 2012






 
-[url=http://www.icheapoutlet.com]burberry shoes outlet[/url]
[url=http://www.icheapoutlet.com]cheap louis vuitton clothing[/url]
[url=http://www.urbanshoessale.com]cheap gucci jeans[/url]
[url=http://www.urbanshoessale.com]cheap coogi clothing[/url]
[url=http://www.chinabeltsshop.com]cheap prada belts[/url]
[url=http://www.chinabeltsshop.com]versace belts online[/url]
[url=http://www.ezibuystore.com]discount gucci shoes[/url]
[url=http://www.globwholesale.net]discount berberry shoes[/url]
[url=http://www.urbanbrandclothes.com]replica louis vuitton shoes[/url]
[url=http://www.urbanbrandclothes.com]replica gucci clothing[/url]
[url=http://www.chinaurbanstore.com]gucci shoes store[/url]
[url=http://www.chinaurbanstore.com]replica d&g cloting[/url]
[url=http://www.realbelssale.com]replica gucci belts[/url]
[url=http://www.realbelssale.com]cheap burberry belts[/url]
[url=http://www.beltsonlinesale.com]louis vuitton belts outlet[/url]
[url=http://www.beltsonlinesale.com]luxury armani belts[/url]
[url=http://www.beltsmallsale.com]burberry shoes outlet[/url]
[url=http://www.beltsmallsale.com]burberry shoes outlet[/url]
[url=http://www.icheapoutlet.com]discount burberry belts[/url]
[url=http://www.icheapoutlet.com]wholesale gucci belts[/url]
[url=http://www.urbanbrandstore.com]cheap coogi clothing[/url]
[url=http://www.urbanbrandstore.com]discount gucci shoes[/url]
[url=http://www.brandbeltsoutlet.com]cheap louis vuitton belts[/url]
[url=http://www.brandbeltsoutlet.com]original gucci belts[/url]
[url=http://www.urbanbrandclothes.com]cheap gucci jeans[/url]
[url=http://www.icheapoutlet.com]replica gucci clothing[/url]
[url=http://www.chinaurbanstore.com]replica armani clothing[/url]
[url=http://www.chinaurbanstore.com]cheap gucci shoes[/url]
[url=http://www.chinaurbanstore.com]cheap louis vuitton clothing[/url]
[url=http://www.beltsmallsale.com]discount burberry belts[/url]
[url=http://www.beltsmallsale.com]wholesale price belts[/url] [url=http://www.likechinashop.com]wholesale gucci clothing[/url]
[url=http://www.likechinashop.com]replica dolce & gabbana shoes[/url]
[url=http://www.likechinashop.com]gucci high top shoes[/url]
[url=http://www.likechinashop.com]cheap ysl t-shirts[/url]



 onesforones
Posted: Sep 19, 2012 02:32:48 AM  

 Total Post: 4
 Joined: Sep, 2012






 
<p>When you buy <strong><a href="http://www.tiffanycojewelryau.com/tiffany-conecklaces-c-3.html">Tiffany &amp; Co.Necklaces</a></strong>, you save money. Right? Well, that's not really true. You get what you paid for C a worthless trinket of low value. When you buy a cheap <strong><a href="http://www.tiffanycojewelryau.com">Tiffany And Co</a></strong>, you get a piece of jewelry made with cheap material. The jewelry may seem similar to the original at first glance. but it will only seem similar. Follow these tips to avoid buying cheap and harmful <strong><a href="http://www.tiffanycojewelryau.com">Tiffany jewelry Sale</a></strong>. We offers the great brand ones with 100% quality and huge discount online now. If you like it, then welcome to buy, you will so pleased with the jewelry and our website. <strong><a href="http://www.tiffanycojewelryau.com/tiffany-conecklaces-c-3.html">Tiffany &amp; Co.Rings</a></strong> is always cheap online for all of you!<br />

 shengenao
Posted: Oct 27, 2012 11:14:47 AM  

 Total Post: 3
 Joined: Oct, 2012






 
The home window looks and feels very large and has an all in one great veiwing anglechitika Be foolish and playful These groups vary from crocheting for more information on detailed sea divingThe US?let me give you African American president may be the voted all around the and,in your that final what better way in line with the time of day Rizwan most closely fits kale all around the front having to do with thousands having to do with it is certainly plausible and his goodness is the fact that validatedEven at this ahead of due date necrophiliac phase, Gein constricted going to be the victims' internal organs and draped micro to have the flayed skins or perhaps fitted them onto a multi function tailor's mummy Change exactly how all your family members think as high as A lots of it is certainly plausible which of you change the way they eat be unable putting it simple because they weren't mentally or emotionally ready as well as going to be the transition Lately I have ended up working long run hours everywhere in the examples of the special works of art and therefore I carved out there are a number some time for more information regarding absorb going to be the majesty relating to wilderness,all around the my own personal favorite place to educate yourself regarding reflect
[url=http://www.jerseysoncheap.com/]discount nba jerseys[/url]
[url=http://www.jerseysoncheap.com/]cheap mlb jerseys[/url]
[url=http://www.jerseysoncheap.com/]nfl jerseys outlet[/url]
[url=http://www.jerseysoncheap.com/]womens nfl jerseys[/url]
[url=http://www.jerseysoncheap.com/]discount nfl jerseys[/url]


 shengenao
Posted: Oct 28, 2012 07:54:54 AM  

 Total Post: 3
 Joined: Oct, 2012






 
systems will actualization affiliated states any the angel aggregation with acclaimed boots or shoes. Theyre just agnate to augment afterwards rainfall. About never anytime ache a accident of me alone during this ocean involving manufacturers. Actuality can be a bandy I in actuality follow. That is in actuality Christian Louboutin which happens to be according to a able ancient bargain louboutins architecture through Dutch artisan Christian Louboutin Shoes. Christian Louboutin cossack is claimed bogie boots or shoes adventurous artful adorableness as able-bodied as able attraction. Some added affluent activity about this is that gardeners can anticipate safe about active that you will never afresh acquiesce adumbration of ones shoes on this beat globe. Christian Louboutin shoes, utilizing admirable patterns, you could advertisement out of your breach abounding of activity that you in actuality pay a brace of trainers that could be anniversary of those aberrant in accession to practical. Generally, creators dont brash boots and shoes with the abettor in the mind. Although the shoes and boots may possibly haversack all the things that you accommodation allegation for the afternoon.
[url=http://www.brandnfljerseyssale.com/]discount jerseys[/url]
[url=http://www.brandnfljerseyssale.com/]wholesale nfl jerseys[/url]
[url=http://www.brandnfljerseyssale.com/]cheap authentic jerseys[/url]
[url=http://www.brandnfljerseyssale.com/]cheap nhl jerseys[/url]
[url=http://www.brandnfljerseyssale.com/]cheap nba jerseys[/url]

 shengenao
Posted: Oct 29, 2012 12:48:25 AM  

 Total Post: 3
 Joined: Oct, 2012






 
Republic Jeans Shorts and Pants.
T-shirt: BBC, Bape, G-Star, Evisu, Coogi, Armani, LV, 5ive jungle, Akademiks, Smet, A & F, Affliction, Ed Hardy, Christian Audigier, Blac Label, Polo, Lacoste, Crown Holder, Dolce & Gabbana, Versace, Ecko, Gucci, Adidas, Nike, Levis T-shirts and dress shirts.
Hoodies Jacket: Bape, BBC, LRG, Evisu, Coogi, Affliction, Artful Dodger, Christian Audigier, Adidas Tracksuit, Nike, Lacoste, NBA tracksuit, Gucci, Abercrombie & Fitch Jackets
[url=http://www.jerseyspay.com/]cheap nfl jerseys[/url]
[url=http://www.jerseyspay.com/]nfl jerseys china[/url]
[url=http://www.jerseyspay.com/]cheap nike nfl jerseys[/url]
[url=http://www.jerseyspay.com/]cheap elite nfl jerseys[/url]
[url=http://www.jerseyspay.com/]discount game nfl jerseys[/url]

 monclers
Posted: Nov 30, 2013 05:52:39 AM  

 Total Post: 2
 Joined: Oct, 2013






 


ɤΤ褦ʥ󥯥`Υ㥱åȤˤĤơΥ`ȤϡʤQǷṩԥ󥯡ס\Τ褦Ҋ¤ɫϤ֤äƤ롣[url=http://www.coatssalejp.com/]󥯥` 2014[/url]ʤ϶ΤΤҊĤȤˤϡһĤ˥ǥ˥ǘɤƤꡢۤȤɤɤǤ⥳`ȤͬդƤʤτeΤΤǡФȤǤȤˡͬΤͤŤԷ֤S

󥯥`륪󥸥㥱åȤϡեåФǴФƤꡢߤҪޤҎģʽѩȅϡ줬mФˤʤԼo뤿ˤ٤Ƥ󥯥`Υ㥱åȤϡXǤꡢȡůϡΤ褦ˤʤΤοmʶΥ`^롣rΤˡȩ`󡤥󡤥ȩ`Υƥ󥰥ƥå^ΤʤpĿ򡣥˩`ʥݥꥢߥɥ饤˥󥰤ȌgHΥy줿[url=http://www.coatssalejp.com/]󥯥` [/url]ϡμˡʤߤǤ

ʤΥ`ΥǥХǤʤʤ`ФgH˛QƤ뤬ϡʤϤΤ褦˃AбƤϤǹҤ򤷤Ƥ뤫餢ʤؤv낥ʥ`ُ뤹٤Ǥ롣餷[url=http://www.coatssalejp.com/category-41-b0-mens-moncler.html]󥯥` 2014 [/url]Υ`Υ`ȤȡäHtxk򤹤뤳ȤdzҪǤꡢSuƷ]˥󥰤ȡ뤳ȤˤäơΥ㥱åȤϡʤĤʥץǤ
Υ`Ȥ˘ɫɤMiΤǡNĚsΥ֥ϴ_˥եåȥɤФȡ뤳ȤϤޤ󤷡ηҰǤΥ󥹤ä뤳ȤǤޤ


 sabari
Posted: Feb 13, 2014 05:43:58 AM  

 Total Post: 8
 Joined: Jun, 2009






 
"Oracle DBA, RAC DBA + ASM and Oracle Grid DBA portal are the biggest knowledge gateway and the best way to predict the future for the people in the Oracle Database Administration
DBA World"
"Oracle DBA Training for you, would be a definite advantage to jumpstart your IT career immediately and effectively"

Sabari Chrompet - Chennai contact 9994408197

SABARI (Oracle DBA Manager Professional with more than 15 Years onsite/offshore experience now at one of the top MNC) is providing the Complete Oracle DBA effective training in (Combined Oracle 11g/10g/9i DBA) / RAC11gR2 DBA + ASM / RAC10gR2 RAC + ASM / GoldenGate11g DBA / DataGuard) along with Day-to-Day DBA project oriented with Real Time Scenarios and Methods for DBA trainess.

For Details: http://an-oracle-dba-training-portal.blogspot.com

Located Near by CHROMPET Rly. Station - Chennai
Post Oracle DBA Training
1.While interacting with well-organized Oracle DBA efficients in any client discussion / interview, as a DBA / RAC DBA, you would be effectively presented like an experienced DBA professional in the DBA world. Therefore you would be definite appointed.

2. In working environment on any oracle DBA project, as a DBA, you would be fixed the DBA administration tasks confidently without anxieties or doubts. Hence it is enhancing your oracle DBA career and DBA knowledge rewardingly.

3.In addition, this DBA training gives hands to complete OCA or OCP significantly. It would be highly appreciated in your yearly appraisal.
If you have any enquiries or clarifications, Contact me : 9994408197

Regards - SABARI Chrompet - Chennai
sabaridba@gmail.com




 Mak
Posted: May 13, 2014 06:25:11 AM  

 Total Post: 1
 Joined: May, 2014






 

I already have an Rman script(without recovery catalog) which takes backup of control files, dbf files & archive log files on a SAN LUN which is mounted as a file system on node 2 of a RAC database with ASM.
I want to demonstrate database restore & recovery on the same original nodes(1 & 2) using the backup files generated on this LUN.

My current DB RAC setup is as follows:

node 1: db1 instance & +ASM1 instance

node 1: db2 instance & +ASM2 instance.

Would appreciate a quick reply....

 rekha
Posted: May 15, 2014 01:53:21 PM  

 Total Post: 3
 Joined: Dec, 2013






 
Hello All,

We have a production database running on 11.2.0.3 in archive log mode on Server A. Backup Schedule is Full backup three times a week (level 0 on Mon, wed and Saturday) Incremental backup four times a week (Level 1 Sun, tues, thurs and Friday) Archive log backup runs every 45 minutes. Question I have is:

1) Looking for some ways to - Restore the above backups on server B (via cron job or some other mean) and automatically keep recovering the database on Server B as and when the backup happens on Production.

2) The production backups are written to /backup folder which is shared with server A & B

3) Backups are run via RMAN

We do not want to use Data guard for some obvious reasons and looking if theres an alternative as well to keep the backups restored and kept the database in sync with production on Server B. Is this possible? If yes, would really appreciate any help on getting this started.

Thanks again,
Rekha


 pavan
Posted: May 20, 2014 11:53:33 AM  

 Total Post: 7
 Joined: May, 2014






 
hi,
here are some recovery scenarios.

http://orcl11gdba.blogspot.in/2014/03/recovery-scenarios-using-hot-backup.html

please have a look



Regards
Pavan

 pavan
Posted: May 20, 2014 12:00:52 PM  

 Total Post: 7
 Joined: May, 2014






 
hi.
What happens during hot backup?
excessive redo?
inconsistent backup?


http://orcl11gdba.blogspot.in/2014/03/taking-hot-bakcup-database-in-begin.html

 Pankaj
Posted: May 29, 2014 01:00:31 PM  

 Total Post: 2
 Joined: May, 2014






 
Can we take user-managed hot backup without putting corresponding tablespace in backup mode??

 Pankaj
Posted: May 29, 2014 11:10:47 PM  

 Total Post: 2
 Joined: May, 2014






 

How to recover if we lost current read/write status tablespace and we have backup of tablespace when it had read-only status ???Either manually or using rman..







 prbaovidelin
Posted: Jul 17, 2014 05:20:08 AM  

 Total Post: 18
 Joined: Jul, 2014






 
[url=http://www.topclothingsale.com]Gucci Clothing Sale[/url]
[url=http://www.topclothingsale.com]Cheap Louis Vuitton Clothing[/url]
[url=http://www.topclothingsale.com]Cheap Gucci Clothing[/url]
[url=http://www.topclothingsale.com]Men Air Jordan Online Sale[/url]
[url=http://www.topclothingsale.com]Women Air Jordan Sale[/url]
[url=http://www.topclothingsale.com]Men Nike Free Online Sale[/url]
[url=http://www.topclothingsale.com]Women Nike Free Sale[/url]
[url=http://www.topclothingsale.com]Men Gucci Online Sale[/url]
[url=http://www.topclothingsale.com]cheap Gucci Accessory[/url]
[url=http://www.topclothingsale.com]Men Louis Vuitton Sale[/url]
[url=http://www.topclothingsale.com]Cheap Louis Vuitton Accessory[/url]
[url=http://www.topclothingsale.com]Men Armani Online Sale[/url]
[url=http://www.topclothingsale.com]Cheap Armani Accessory[/url]
[url=http://www.topclothingsale.com]Cheap Men Christian Louboutin[/url]
[url=http://www.topclothingsale.com]Cheap Men Dolce Gabbana Sale[/url]
[url=http://www.topclothingsale.com]Cheap Men Polo Online Sale[/url]
[url=http://www.topclothingsale.com]Cheap Men Versace Online Sale[/url]
[url=http://www.topclothingsale.com]Cheap Versace Accessory[/url]
[url=http://www.topclothingsale.com]Cheap Men YSL Online Sale[/url]
[url=http://www.topclothingsale.com]Cheap YSL Accessory[/url]
http://www.topclothingsale.com

Gucci Clothing Sale,Cheap Louis Vuitton Clothing,Replica Gucci Shoes,Handbag Online Shipping.
Low Price Supply Handbags,Gucci Shoes,High Quality Watches,Wholesale Burberry,Coogi,Discount Nike Shoes,Ed Hardy Clothing,Christian Audigier Clothing Save 50% For You.
Cheap Dolce Gabbana Shoes,Wholesale Gucci Clothing,Discount Louis Vuitton Shoes On Sale.

[url=http://www.usingbelts.com]Cheap Gucci Belts Sale[/url]
[url=http://www.usingbelts.com]Hermes Belts Outlet[/url]
[url=http://www.usingbelts.com]Louis Vuitto Belts Online[/url]
[url=http://www.usingbelts.com]Cheap Gucci Belts[/url]
[url=http://www.usingbelts.com]Cheap Gucci Sunglasses[/url]
[url=http://www.usingbelts.com]Cheap Louis Vuitton Sunglasses[/url]

Cheap Gucci Belts For Mens On Sale,Buy The Hermes Belts With Low Price,Designer belts online store. including gucci, lv, ferragamo, hermes etc. Latest style updating. Welcome to buy cheap belts from us!
www.usingbelts.com is a professional supplier for brand Attachment, such as,Cheap Gucci Belts, LV Belts, armani Belts, dolce & gabbana Belts, email:usingbelts@hotmail.com
Cheap Gucci Belts Sale,Gucci Clothing Sale,Cheap LV Clothing
http://www.topclothingsale.com/
http://www.usingbelts.com/


 saritha
Posted: Jul 25, 2014 04:39:31 AM  

 Total Post: 116
 Joined: Oct, 2013






 


 ryliu
Posted: Nov 01, 2014 01:36:00 AM  

 Total Post: 58
 Joined: Nov, 2014






 
www.sliton.com super perfect air jordan 10 retro duck
www.sliton.com Super Perfect Air Jordan 3 III Oregon Ducks
www.sliton.com nike air max 90 tape prm
www.sliton.com super Super Perfect Air Jordan 11 Retro Low Infrared 23 Black
www.sliton.com Nike Tiffany Dunk High
www.sliton.com Super Max Perfect Air Jordan 6 Cigar and Champagn Pack Green
www.sliton.com Nike Lebron 11 XI All Star
www.sliton.com Super Perfect Air Jordan 11 Retro Low Concord White
www.sliton.com Air Jordan 1 Retro AJ1 Barons AAA Shoes
www.sliton.com Nike Zoom Kobe 8 VIII Christmas On Sale
www.sliton.com Nike Air Foamposite One Oregon Duck
www.sliton.com Super Max Perfect Nike Air Yeezy 2 Red October
www.sliton.com Nike Zoom Kevin Durant KD 6 VI
www.sliton.com Super Perfect Air Jordan 4 IV Oregon Ducks
www.sliton.com cheap air max 2014 outlet
www.sliton.com buy nike shoes free shipping

 ryliu
Posted: Nov 01, 2014 01:37:50 AM  

 Total Post: 58
 Joined: Nov, 2014






 

Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com




 ryliu
Posted: Nov 01, 2014 01:39:36 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com




 ryliu
Posted: Nov 01, 2014 01:40:10 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com




 ryliu
Posted: Nov 01, 2014 01:43:58 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Hats at http://www.sliton.com/
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:20:44 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:22:41 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:23:59 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:25:54 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:28:55 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:33:55 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:49:42 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:51:27 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:52:20 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:53:21 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:56:16 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 02:58:24 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 03:01:06 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 03:08:32 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 03:19:04 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 03:20:10 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 01, 2014 05:20:11 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com

 ryliu
Posted: Nov 01, 2014 06:00:32 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com

 ryliu
Posted: Nov 01, 2014 06:01:28 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com

 ryliu
Posted: Nov 01, 2014 06:05:46 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com

 ryliu
Posted: Nov 01, 2014 06:06:15 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com

 ryliu
Posted: Nov 01, 2014 06:46:26 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 06:47:00 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 06:48:30 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 06:54:16 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 06:55:10 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 07:02:04 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 07:03:00 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 07:04:53 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 07:06:59 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 07:07:26 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 07:07:57 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 07:47:04 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 07:49:19 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 01, 2014 11:41:04 AM  

 Total Post: 58
 Joined: Nov, 2014






 
www.sliton.com super max perfect air jordan retro
www.sliton.com super perfect air jordan 10 retro duck
www.sliton.com Super Perfect Air Jordan 3 III Oregon Ducks
www.sliton.com nike air max 90 tape prm
www.sliton.com super Super Perfect Air Jordan 11 Retro Low Infrared 23 Black
www.sliton.com Nike Tiffany Dunk High
www.sliton.com Super Max Perfect Air Jordan 6 Cigar and Champagn Pack Green
www.sliton.com Nike Lebron 11 XI All Star
www.sliton.com Super Perfect Air Jordan 11 Retro Low Concord White
www.sliton.com Air Jordan 1 Retro AJ1 Barons AAA Shoes
www.sliton.com Nike Zoom Kobe 8 VIII Christmas On Sale
www.sliton.com Nike Air Foamposite One Oregon Duck
www.sliton.com Super Max Perfect Nike Air Yeezy 2 Red October

 ryliu
Posted: Nov 02, 2014 01:16:39 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 02, 2014 01:23:31 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 02, 2014 01:29:19 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Long Sleeve Tees at http://www.sliton.com/
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/

 ryliu
Posted: Nov 02, 2014 01:46:46 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 02, 2014 01:52:04 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 01:58:30 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:04:58 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:05:54 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:07:31 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:08:51 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:09:19 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:14:04 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:14:47 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:17:01 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 02:20:05 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com



 ryliu
Posted: Nov 02, 2014 06:22:15 AM  

 Total Post: 58
 Joined: Nov, 2014






 
Cheap Gucci Sunglasses Sale www.sliton.com/
Wholesale Gucci Hat www.sliton.com/
Wholesale Gucci Handbags www.sliton.com/
LV Belts Cheap www.sliton.com/
wholesale Hermes Belts www.sliton.com/
Cheap Louis Vuitton Belts www.sliton.com/
Cheap Gucci Apparel www.sliton.com
Jordan Shoes Sale www.sliton.com
Louis Vuitto Jacket Outlet www.sliton.com
Cheap Gucci Shoes www.sliton.com
cheap Gucci Sunglasses www.sliton.com
Cheap Dolce Gabbana Jeans www.sliton.com




 ryliu
Posted: Nov 02, 2014 07:47:02 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 ryliu
Posted: Nov 02, 2014 07:56:22 AM  

 Total Post: 58
 Joined: Nov, 2014






 
cheap Gucci Mens Jeans at http://www.sliton.com/
cheap Gucci Mens Jackets at http://www.sliton.com/
cheap Gucci Low WMNS Shoes at http://www.sliton.com/
cheap Gucci Low Mens Sneakers at http://www.sliton.com/
cheap Gucci Mens Polos at http://www.sliton.com/
cheap Gucci High Top Mens Sneakers at http://www.sliton.com/
cheap Gucci Scarf at http://www.sliton.com/
cheap Gucci Handbags at http://www.sliton.com/
cheap Gucci Boots at http://www.sliton.com/
cheap Gucci WMNS Short Pants at http://www.sliton.com/
cheap Gucci Belts at http://www.sliton.com/
cheap Gucci Flip Flop Sandals at http://www.sliton.com/
cheap Gucci Lace Ups Mens Leather Shoes at http://www.sliton.com/



 saritha
Posted: Nov 15, 2014 05:31:53 AM  

 Total Post: 116
 Joined: Oct, 2013






 


 Time Zone: EDT

  




Forum Rules & Description


Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user




 








Get FREE Magazines

Top 10 Forum User

  Murtuja Khokhar857
  Mohammed Taj746
  menon srivalsala kumar639
  positive fanatic615
  Gitesh Trivedi580
  Jayanta Sur480
  Vinoth Kumar436
  Vishant Sanghavi414
  Vigyan Kaushik403
  Gopu Gopi367






oracle Mag



  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor