Forum Replies Created
30 October, 2012 at 6:48 pm in reply to: Induction Error #2280
ORA-600/ORA-7445 are oracle internal error. I would recommend using “My oracle support” (support.oracle.com) for debugging this issue
amit30 October, 2012 at 6:46 pm in reply to: Duplicate Database using RMAN #2279
>>RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo01.log conflicts with a file used by the target database
Above error indicates that you are using cloning on same host or target host already has same files present. Most likely oas db is in open mode while you are trying to clone it again
Amit28 September, 2012 at 12:48 pm in reply to: Sql Loader Data loading issue by sys user #2273
Above data indicates that you should be using timestamp datatype
SQL> select to_date( ‘2012-09-28 02:00:00.000’, ‘YYYY-MM-DD HH24:MI:SS’) from dual;
select to_date( ‘2012-09-28 02:00:00.000’, ‘YYYY-MM-DD HH24:MI:SS’) from dual
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
If I change this to timestamp it would work fine
select to_timestamp( ‘2012-09-28 02:00:00.000’, ‘YYYY-MM-DD HH24:MI:SS.FF’) from dual;
28-SEP-12 02.00.00.000000000 AM
Amit25 September, 2012 at 8:07 pm in reply to: Sql Loader Data loading issue by sys user #2271
I think you can do it using CTAS.
Suppose table emp has two columns empid,hiredate(varchar2)
create table emp_new as select empid,to_date(hiredate,'DD-MON-YYYY') hiredate from emp;
I believe above thing would work24 September, 2012 at 7:45 pm in reply to: Sql Loader Data loading issue by sys user #2268
As error states, you need to specify ‘as sysdba’. So it should be
sqlldr userid=sys/orcl as sysdba control=Spl_Master.ctl log=spl.log21 December, 2011 at 3:36 am in reply to: Lost all voting disk on ASM in oracle 11gr2 #2168
Is this a normal redundancy diskgroup?
Amit15 October, 2011 at 5:32 am in reply to: Oracle 11g R2 – CRS is not starting #2158
Stop crs and start using following command
crsctl start crs -excl -nocrs
Then try ocrconfig restore . It should work
-Amit7 July, 2011 at 3:55 am in reply to: Disaster recovery scenarios of RAC 11gR2 #2148
Actually when you take backup on disk (assuming you have linked rman library with tape and set sbt_type) and are using catalog. Oracle will know which backup to restore. Check in Myoracle support for ‘rman tape’ and you will find many articles related to it.4 July, 2011 at 3:37 am in reply to: Disaster recovery scenarios of RAC 11gR2 #2144
I think you should check regarding licensing terms with Oracle sales representative. I believe if you restore on new server and use it for some number of days, you have to pay license cost. Not sure on this.
I have done ASM restore operation in past but don’t have documented steps. You will have to create the ASM Diskgroup disk’s prior to running the restore operation. Also if you are having any aliases like ‘+DG/orabcn (where orabcn is not oracle_sid), you will have to pre-create before starting restore.
Amit30 June, 2011 at 5:50 am in reply to: Disaster recovery scenarios of RAC 11gR2 #2142
I think what you require is disaster recover solution which is provided by using Oracle dataguard. So you can create a bcp for your existing RAC database which will help in case your primary RAC servers are gone. Also note that restoring from tape can take time, so you should have 1 backup copy on disk’s.30 June, 2011 at 5:46 am in reply to: CRS and ORACLE_HOME wiped out accidentally on node1 #2141
I think you can just copy the two oracle homes from other node and then run root102.sh/root.sh from CRS_HOME. No such thing is required for db home.
-Amit23 December, 2010 at 4:30 am in reply to: RMAN Backup #2123
Transaction will keep running and it will generate redo and also write to datafiles. it is just that records will be marked uncommitted. RMAN will not wait for transaction to complete.
Suppose you took this rman backup and restored it. Once you apply redo which consists of “commit” point of this transaction, you can see the data. If you open the database before applying this redo, the changes will be rolled back
-Amit17 October, 2010 at 4:15 am in reply to: register standby database in recovery catalog. #2122
Apologies, didnt read the question properly. I have not seen any configuration using different catalog for primary and standby (there could be but I havent seen it). Moreover purpose of using rman at standby site is to reduce workload on primary so that in case of failure you can restore the backup. In case of failure, you would need to connect to this very catalog. Anyways I think you can register first primary database at catalog and then take standy backups.
Checked docs (http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmcatdb.htm#CIHECCEF) and they mention that registration can only be done at primary database.
-Amit13 October, 2010 at 1:20 pm in reply to: register standby database in recovery catalog. #2119
You are not required to register standby database in recovery catalog. Oracle will understand that this is standby database (even though they share same dbid)
Hope this helps30 August, 2010 at 4:57 am in reply to: ASM DiskGroup #2117
When you don’t define failgroup while creating normal redundancy diskgroup, oracle would automatically create diskgroup for you. Run following query to identify this
select name,path,failgroup,header_status from V$ASM_DISKGROUP;