RMAN :: Unable To Take Backup After Upgrade From 10g To 11gr2
Dec 5, 2012
After upgrading db from 10 g to 11g ,unable to take rman backup.catlog also upgraded.SCAN listsner alos running
ps -ef |grep tns
oracle 13235 13215 0 13:23:55 pts/3 0:00 grep tns
oracle 2968 1 0 Dec 2 ? 0:47 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit
oracle 2997 1 0 Dec 2 ? 0:51 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit
oracle 19844 1 0 Dec 3 ? 0:30 /orahome_new/oracle/product/11.2.0/bin/tnslsnr LISTENER_DB -inherit
[code]....
View 2 Replies
ADVERTISEMENT
Mar 22, 2011
I have upgraded a 9i db to 10g on another server using rman backup (9.2.0.8.0 on linux to 10.2.0.4.0 on Linux)
I copied the hot backup - rman from 9i db server to 10g db server
Then I restores the rman backup on the 10g db server opened the database with
alter database open restlogs upgrade;
@?/rdbms/admin/catupgrd.sql
shutdown immediate;
startup restrict
@?/rdbms/admin/utlrp.sql
Now I have all components in VALID state but the db server itself in INVALID state as can be seen from results below
SQL> select comp_name, status, version from dba_registry;
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
Oracle Database Catalog Views
VALID 10.2.0.4.0
Oracle Database Packages and Types
VALID 10.2.0.4.0
SQL> @?/rdbms/admin/utlu102s.sql TEXT
.
Oracle Database 10.2 Upgrade Status Utility 03-22-2011 10:35:20
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:06:59
.
Total Upgrade Time: 00:07:05
PL/SQL procedure successfully completed.
SQL>
Has the upgrade failed?
Note that
OS for 9i db server is
Linux 2.6.9-42.EL #1 x86_64 x86_64 x86_64 GNU/Linux
OS for 10g db server is
Linux 2.6.18-53.el5 #1 x86_64 x86_64 x86_64 GNU/Linux
View 4 Replies
View Related
Aug 31, 2013
I tried to run the duplicate script after transferring new rman backup to standby. Even after transferring the backup, duplicate command and was unable to open the database.
View 1 Replies
View Related
Aug 6, 2012
Iam doing some oracle database upgrade from 9.2.0 to 11gr2 . is it possible to upgrade directly from this 9i version to 11gr2 .
Version : 9.2.0 to 11gr2
View 4 Replies
View Related
Aug 26, 2011
Is there any document available for 10g to 11gR2 RAC upgrade on AIX?
View 1 Replies
View Related
Jul 20, 2013
up gradation steps from 10g RAC to 11gr2 RAC.
View 1 Replies
View Related
Aug 6, 2012
After upgrading 11gR1 database (11.1.0.7.0) to 11gR2 (11.2.0.3.0), the datapump exports have been taking quite a bit longer. When database was 11gR1, a full expdp took approx. 40-45 minutes. After upgrade, it takes approx. 1 hour 40-50 minutes. These times were with parallel=4. I tried with parallel=8 and parallel=12, both of these took around 1 hour 5-10 minutes, better but still quite a bit slower than pre-11gR2 upgrade. I tried with exclude=statistics, index_statistics, indexes; it still took approx. 1 hour 40-45 minutes. This is a PeopleSoft database so there are many, many objects to be exported. The database was upgraded using dbua.
View 1 Replies
View Related
Nov 25, 2011
Im planning to upgrade oracle10g to 11gr2.. i have query on that ..
my 10g having ORACLE_HOME=/app/ora/10.2.0, orainventory =/app/ora/oraInventory
new 11g ORACLE_HOME=/app/ora/11.2.0 .orainventory =?
my question is where i need to set ora inventory location for my new 11g? or it will create new location for that?
OS version : IBM AIX
View 3 Replies
View Related
Feb 20, 2013
We have imported 8i DMP file into 11gR2 successfully by IMP command.
Afterthat, we give EXP command for backup in 11gR2, but it shows some error like NCHAR character data type...
i.e. IMP works fine while upgrading 8i DMP in 11gR2, but then EXP shows error in 11gR2.
View 3 Replies
View Related
Aug 3, 2012
upgrading a single instance 10.2.0.2 database of approx size 2TB to 11.2.0.3 rac 2 node db on linux.
View 3 Replies
View Related
Mar 7, 2011
I have a database running on 10205 version. It is a RAC database with ASM storage.
I want to migrate this database to other server and upgrade this database to 11202 version .
View 1 Replies
View Related
May 2, 2011
I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.
On Database Server
SQL> create directory win_expdp_dir as 'd:expimp';
Directory created.
SQL> grant read, write on directory win_expdp_dir to lab;
Grant succeeded.
On Windows 7 machine (client machine)
D:appproduct11.2.0client_1BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
I have give all sharing rights on d:expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. how to take export on windows 7 client.
View 6 Replies
View Related
Oct 18, 2012
understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???
View 1 Replies
View Related
Jan 24, 2011
I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am
other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)
if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)
I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)
View 17 Replies
View Related
Oct 31, 2010
I'm attempting to upgrade a 9.2.0.7 to 10.2.0.? (haven't run the patch set yet so it's at 10.2.0.1) I'm not sure if the listener is correct to proceed.
The platform is Windows x323 (server 2003)
>>I'm not an Oracle DBA, I stumble thru it in administering PTC's Windchill vault..
I am trying to run the Oracle DBUA and the documentation for the Upgrade Assistant instructs me to install in an OraHome that is separate from the existing. Done.
The Upgrading Guide then States:
"Run the Oracle Net Configuration Assistant
If you are upgrading from Oracle9i and a listener was not configured in the Oracle9i repository, run Oracle Net Configuration Assistant to configure the listening protocol address and service information for the new Oracle Database 10g database, including a listener.ora file. A version 10 listener is required for an Oracle Database 10g database. Previous versions of the listener are not supported for use with an Oracle Database 10g database. However, it is possible to use a version 10 listener with previous versions of the Oracle database."
Oracle Net Services Administration Guide, �10 states:
"Note:
A version 10 listener is required for an Oracle Database 10g database. Previous versions of the listener are not supported for use with an Oracle Database 10g database. However, it is possible to use a version 10 listener with previous versions of the Oracle database."
Here's what I've got: The Installation using the Universal installer for 10g ran w/o complaint, reported success. The installation type was Advanced>Custom per the PTC Windchill documentation. After the initial installation, the Oracle Net Configuration Assistant did not start automatically, as the documentation stated it would. (The documentation from PTC on Oracle is skimpy at best)
I launched the Network Config Assistant from the start menu in the new OraHome10g. When I tried to create the listener, TCP on port 1521, it told me this was already in use by another program. I could configure it, but until the conflict was resolved....
When I open the Net Manager, the path in the header bar of the frame is to OraHome92\network\Admin....YET, when I run HELP>About in the Net Manager it reports "Oracle Net Manager; Version 10.2.0.0.0 Production"
I had stopped all Oracle services when I ran the UI to install 10g. I have also since removed the service for the 9i TNSListener from windoze register (and restarted). Right now, there is no that shows running in Services.
??Am I actually OK to go ahead w/ the patch set, then run the Pre-Upgrade Information Tool then the Oracle DBUA?
Do I actually have a 10g listener setup?
But, the listener.ora, tnsnames.ora etc are all in the OraHom92/network/admin folder and nothing but the samples show in the OraHome10g/network/admin. Will the DBUA migrate these or should I manually transplant them into the OraHome10g directory?
View 1 Replies
View Related
Mar 28, 2012
I am trying to install Oracle 11g R2 on Windows 7 professional at the time of database creation they give error.
ORA-12638:Credential retrival failed.
View 9 Replies
View Related
Jul 4, 2010
Question:1 I am trying to upgrade 9i to 10g , using DBUA. I am getting below error at step 1:
There is an error in creating the following process: C:\oracle\ora92\bin\sqlplus -s/nolog
The error is: createprocess:C:\oracle\ora92\bin\sqlplus -s/nolog error:193
I can login as sysdba ,using C:\oracle\ora92\bin\sqlplu for both 9i as well as 10g i did set oracle_home to C:\oracle\ora92, using command prompt.
Question 2:Is there any way i can generate the database template of running production so i can use same template to create the test server. I cant find existing template in prod :ORACLE_HOME/assistants/dbca/templates , all templates looks like the default one only.
Question 3:If i have different structure in test db server i.e i have datafiles, controlfiles in I and J drives in production, but in test i have all datafiles ,control files in H:drive Can i use Transport_tablespaces import to upgrade test server ?
View 1 Replies
View Related
Jul 27, 2012
I 'm trying restore database 11GR1 on other host with 11GR2.Using this steps:
>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Jul 27 09:00:32 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/password@PRD
Recovery Manager incompatible with TARGET database: RMAN 8.0.4.0 to 11.1.0.7 required
[code]...
QUestion:
Is posible do this?
View 6 Replies
View Related
May 29, 2013
unable to start the DBCONSOLE immediately after installing Oracle 11G R2 onto my Windows 7 box. Here is what I have ran from the command line:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Userssandifer>emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
C:Userssandifer>SET ORACLE_HOSTNAME=localhost
[code].....
I checked the above listed file path, and sure enough, OC4J_DBConsole_localhost_orcl is missing.
View 7 Replies
View Related
Dec 15, 2012
I am trying to restore 11gr2 database to point in time. using following steps:
Control files are fine, that are not restored.
RMAN> run
{
set until time "to_time('2012-12-13 12:12:00','YYYY-MM-DD HH24:MI:SS')";
}
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;
Here my problem is it is restore complete data what ever i was having, but i don't was it, i has to restore up to specified time only.
View 2 Replies
View Related
Apr 1, 2013
On Oracle 11gr2 DB Prod DB client error log gives error "Txxnx_AxSxNERGY service terminated unexpectedly" and it has done this 25 time(s) but from DB size in alert.log i can find only "ORA-1652: unable to extend temp segment by 128 in tablespace TIVOLIORTEMPTS" error.
After increasing table space size it starts working fine but i am not sure whether Table space was a reason for service termination or network issue i can not find any error in listener.log file .
View 5 Replies
View Related
Feb 6, 2013
able to utilize "RMAN Restore of Backups as Part of a Database Upgrade [ID 790559.1]" and duplicate an 11.1 PRD DB to another server that only has the 11.2 software. When I attempted this, I got an error since the target DB is a earlier version than the rman client - "RMAN-06429: TARGET database is not compatible with this version of RMAN".
I tried to avoid connecting to the target database & just use the following syntax (duplicate 'prd' DBID 123456789 to 'dev') to let rman know about the backups it would need from NetBackup.
That also got an error - RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "database, for, target, to". I tried other variations, but also got errors.
I may try this from a disk based backup, but have to wait to get a large enough NFS mount to be able to complete this. The following syntax was in the 11.2 rman docs:
DUPLICATE DATABASE 'PROD' dbid 8675309 to 'TEST'
UNTIL TIME "to_date('11/01/2007', 'MM/DD/YYYY')"
BACKUP LOCATION '/backups' NOFILENAMECHECK
PFILE='?/dbs/inittest.ora' db_file_name_convert='prod','test';
Our goal is to not have to install the 11.1 software on our new servers. Also, trying to avoid restoring with the same name & then renaming the DB so that ASM would have multiple directories for the DB.
OS: RHEL 6.3 for target host
OS: RHEL 5.9 for target host
Target DB: 11.1.0.7.12 - PRD
Auxiliary DB: 11.2.0.3.5 - DEV
View 5 Replies
View Related
Apr 2, 2013
I am working on SLES 11 SP2 on zLinux and I am trying to install oracle 11gr2 silently. I was able to install the GI and it is running but when I try to install the oracle binaries I keep getting this error:
[FATAL] [INS-32035] Unable to create a new central inventory directory : /opt/oraInventory.
CAUSE: The central inventory location provided is not empty.
The GI install created /opt/oraInventory and all the files are in there. I even changed the owner from grid:oinstall to oracle:oinstall but that did not work. When I did the install on SLES 11 SP1 I did not get this error.
I am running this command to install oracle:
/runInstaller -silent -ignorePrereq -showProgress -waitForCompletion -responseFile /tmp/db_install.rsp
drwxrwx--- 6 oracle oinstall 4096 Apr 2 10:42 oraInventory
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:39 ContentsXML
drwxrwx--- 3 oracle oinstall 4096 Apr 2 10:41 backup
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:41 logs
[code]....
View 5 Replies
View Related
Feb 26, 2012
We are doing RMAN Duplicate set until time to refresh daily our test database for our developers and it taking long time to finish. We noticed on the restore log that RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.
For additional details here's the rman duplicate command we are using which we run daily(mon-sat) at 4am once daily full backup on production completed.
RMAN Duplicate commands:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 04:00:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit
Is there a way on how to let RMAN use the latest backup pieces instead?
View 1 Replies
View Related
Dec 22, 2012
I created a tablespace named 'data'.During create a new user with default tablespace 'data',I got following error message:
SQL> create user rman identified by rman default tablespace data
temporary tablespace temp
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_USER# by 2 in tablespace
OS:Windows XP
Oracle 10g
View 2 Replies
View Related
Jan 28, 2011
I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...
brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap
The backup goes thru but i get this erro on the end...
BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28
[code]...
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42
[code]...
Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman
[code]...
I have check on the system .. There is not file like that but thwre on on the db i,e
eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1
View 13 Replies
View Related
Feb 9, 2011
Is it possible to restore dropped table OR wrongly updated table using RMAN backup.
View 18 Replies
View Related
Jan 8, 2013
Is this script is enough to delete the backup pieces older than 2 days.
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
configure device type disk parallelism 1 backup type to compressed backupset;
run
{
allocate channel d1 type disk ;
backup filesperset 5 format '/u06/backup/EBSDEV/EBSDEV_data_t%t_s%s_p%p' database ;
sql 'alter system archive log current' ;
backup filesperset 20 format '/u06/backup/EBSDV3/EBSDV3_arch_t%t_s%s_p%p' archivelog all delete input ;
[Code]....
View 1 Replies
View Related
Jan 8, 2013
My Rman log location is d:kp man.log, how can i fetch the result of backup into this log file after windows scheduler runs backup..
View 6 Replies
View Related
Jan 8, 2013
Does the full cold backup of rman include online redologs?
So that at the time of recovery when i restore the database the online redologs also restored to that point?
View 2 Replies
View Related
