Server Administration :: How To Copy RAC Database
Feb 2, 2012how can i copy to a RAC database which managered by ASM to another new host? just as clone.
View 6 Replies
ADVERTISEMENT
Server Administration :: Copy Many Files From ASM To FileSystem
May 1, 2013I have got backup pieces in ASM, I guess about more than 100 files. Now, I need to copy all of them from ASM to FileSystem, there are 2 methods still now:
1- Copy from ASM to FileSystem using cp command.
2- Copy from ASM to FileSystem using DBMS_FILE_TRANSFER.
But:
In the first method, when I copy one file, I took more than 1 minute, so the following script would take me more than 1 days (I guess so).
#!/bin/ksh
#
# This script copies files from FRA on ASM to local disk
#
ORACLE_SID=+ASM2
ASMLS=/vasgatedb/app/vsgbkp/asm_ls.txt ##{ASM files list}
[Code]...
The second method, DBMS_FILE_TRANSFER took me less than 1 second to copy one file completely.
sys@VSGDB> set timing on
sys@VSGDB> exec dbms_file_transfer.COPY_FILE('asm_dir','level_0_vsgdb_9998_813844797.bkp','fs_dir','level_0_vsgdb_9998_813844797.bkp');
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.38
Of course, I wish I used the second method as soon as possible, however, said I below, I've got about ~200 files, and I could not copy one by one file.
SQL & PL/SQL :: Copy Some Archivelog Files Between 2 Database Server
Sep 27, 2011I wanted to copy some archive log files between 2 DB Server.Steps:
1) Edited the Local and Remote DB's TNSNAMES file and modifyied like below.
bookstore =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.100.28)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BOOKSTORE)
)
)
2) Created a Source Directory --> DR1
3) Created a Target Directory --> DR2
4) Created a DB Link
CREATE DATABASE LINK LINK1 CONNECT TO <username of the Remote DB> IDENTIFIED BY <Password> USING '<Remote DB Name taken in the TNSFILE>.
5) In the Local Server I had written the below command.
create or replace procedure proc1 is
cursor c1 is select recid,substr(name,37) "ARCH_FILE" from v$archived_log;
var1 c1%rowtype;
begin
open c1;
fetch c1 into var1;
[code]...
It is working, but not coping the Files from Local To the Remote.
Server Utilities :: Copy Table With NCLOB Column Into Another Database (10g To 11g)?
Dec 4, 2012I need to copy one table which is having NCLOB column into our new DB(11g) from old DB (10g). As this table having huge records (1 crore) it is difficult to use direct insert statement (INSERT INTO ... SELECT * FROM @remotedb). I don't have DBA privilege to use loader.
View 3 Replies View RelatedServer Utilities :: Copy Database On Another Computer Through Local Network
Feb 23, 2012i've 0racle 9i database, i wanted to know the easiest way how to copy that database on another computer throw local network,
View 15 Replies View RelatedForms :: Generate File From Database Into Server And Copy It To Client Machine
Feb 2, 2012I have a forms that generate a file from database into database server and copy it to client machine by the follow process:
IF webutil_file_transfer.Is_AS_readable(V_server_way || V_file_name) THEN
l_success := webutil_file_transfer.AS_to_Client
(clientFile => :V_screen_way
[code]...
But is showing the erro ora-105100 in one client machine
Application Express :: Copy Team Development From Database To Another Database?
Feb 11, 2013How can I copy Team Development from database to another database
View 3 Replies View RelatedServer Administration :: Database Configuration Assistant Not Working / When Create New Database
Mar 26, 2011i am installing oracle database 8.1.7 on dell server power edge 2650 first time database successfully installed but when i want to crate new database by Database Configuration Assistant it is not working for new database creation.
View 1 Replies View RelatedServer Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?
Jan 11, 2011i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."
Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server
Oct 31, 2012I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .
View 22 Replies View RelatedServer Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client
Feb 13, 2013I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
Server Administration :: Create Multiple Database In Single Server
Apr 18, 2011I have database in single server. I already have ORACLE_SID=stagedb. So i want to create new sid and named as proddb.Is it possible have multiple db in single server? This server not running as RAC. It run as single only.
View 1 Replies View RelatedServer Administration :: Access To Database Server Machine Login?
Apr 30, 2012database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?
View 9 Replies View RelatedServer Administration :: Oracle 10g - Database Server Startup / Shutdown
Jun 29, 2011I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.
View 5 Replies View RelatedServer Administration :: Oracle Database Server - Logon Denied
Jul 19, 2011I am connected as System. It was the only user I set-up a password when installed the database on personal computer.
SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
[code]...
SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied
Server Administration :: Fetch Procedure Of One Database From Another Server
Oct 22, 2011I want to know if I can access a procedure created on Database server A from database server B.
View 2 Replies View RelatedServer Administration :: Moving 10 GB Data To 200 GB Database Server
Jun 22, 2011We have an Oracle Server database of Size 50 GB having 10 GB Data. And Planning to have a new Database Server of 200GB . So my question is after moving all the 10 GB data to 200 GB Database Server, will the performance of the system come down? Will it reduce the speed?
View 9 Replies View RelatedServer Administration :: Database Server Session History?
Apr 17, 2011Can I extract data from our Oracle server regarding the no. of sessions per day? But the problem is that our Boss wants a previous dates from April 11-17, 2011.
View 4 Replies View RelatedServer Administration :: From Where To Download Oracle 9i Database Server
Aug 17, 2010I have some requirement wherein I need to install Oracle 9i database server (9.2.0.7). I am not getting it on Oracle website. where can I get the download.
View 1 Replies View RelatedRECOVER / Copy A DATABASE?
Jul 13, 2010While trying to copy a database, i used the command: RECOVER DATABASE USING BACKUP CONTROLFILE until cancel; it gave:
ORA-00279: change 7866782806751 generated at 07/12/2010 19:39:23 needed for thread 1
ORA-00289: suggestion : /moteurs/oracle/r11110/R11110/archivelog/2010_07_13/o1_mf_1_1158_%u_.arc
ORA-00280: change 7866782806751 for thread 1 is in sequence #1158
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data01/oracle/r11110/data/SYSTEM01.dbf'
ORA-01112: media recovery not started what can i do in this case of issue?
Can Copy RMAN To Use Different Database With Different ID
Feb 23, 2011Can I copy rman to use a different database with a different ID
View 6 Replies View RelatedCopy Database From Production To Test?
Feb 22, 2011Would like to know if I can replicate Production database (10.2.0.2) to Test (10.2.0.4).
tell me the process to do that on windows environment.
I wonder if I can do it with two different oracle versions?
Server Administration :: Database Down Often?
Jun 10, 2010see as i said keep on my database down in the night time around 9 pm. the OS redhat linux 5 restarting morning around 6.45 am.when i check alert_log there is no indication.when i check OS log , OS restarting around 6.45 amchecked in the log file in OS level
location: /var/log
i found this
Jun 7 06:45:33 Alraya syslogd 1.4.1: restart.
Jun 8 06:42:22 Alraya syslogd 1.4.1: restart.
Jun 9 06:47:12 Alraya syslogd 1.4.1: restart.
what is this mean, system restarting around 6:45 daily i think now i m posting listener.log for reference
<b>06-JUN-2010 21:04:52 *</b> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Alraya)(USER=alrayaora))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADD
RESS=(PROTOCOL=TCP)(HOST=Alraya)(PORT=1521)))(VERSION=169869568)) * status * 0
06-JUN-2010 21:05:05 * (CONNECT_DATA=(SID=alraya)(CID=(PROGRAM=perl@Alraya)(HOST=Alraya)
[code]...
OS is restarting around 6.45 in the morning, but database getting down night around 9 pm itself why then in the morning if i bounce the database it starting with no problem
Copy DBF Into New Server?
Feb 24, 2013I am using oracle 11g XE.
My server hard disc crashed yesteday and i don't have any backups / I am able to recover the .dbf by using a recovery tool.
is it possible to use this .dbf into new server and recover my data.
Enterprise Manager :: Copy Objects From One Database To Another?
Mar 24, 2011I need to copy all the database objects from one database to another database.I have 32 bit windows environment I tried export and put it in a dump file but dump file size exceeds the limit, my database size is about 300 GB.
What would be efficient way to replicate all the database objects move to another box ..?
Backup & Recovery :: Copy Database To New Location
May 21, 2011i have one database name tom on my one pc its name is rose1 now i have to place this my tom database to on my another pc its name is rose2.
i do not want to use rman.
How can i place this tom database from rose1 pc to rose2 pc and my this tom database is in archive mode and my this tom database is in rose1 pc and my rose1 os is windows xp 32bit and i want to transfer this database to on my rose2 pc and the os of rose2 pc is windows 7 64 bit.
Copy Database File To Clone Machine?
Nov 12, 2012I tried to convert a physical SuseLinux with Oracle 9i Machine into an virtual Machine (esxi Server 5.0). (VMware vCenter Converter ) Before started I shutdown database:
su – oracle
sqlplus ‘/ as sysdba’
shutdown
and the run converter.
But i have problem with copy /u01 and /u02 (database files) "Error: Unable to clone the volume mounted on '/u01' "
So i want clone machine without /u01 and /u02 then copy file. What I should do to be correctly?
Server Administration :: Database Can't Be Started
Jun 4, 2012i m facing a problem in my databse when going to startup. sql> startup ora:00824- can not set sga_target due to existing inernal setting see alert log for more information . when i checked the alert log file i found
cannot set sga_target with statistics_level=basic. acutally last time i change the parameter statistics_level=basic scope=spfile (typical to basic).now my database is not open.what can i do to startup the database.I have no any type of backup.
Server Administration :: Upgrade Database From 11.2.0.1 To 11.2.0.3?
Dec 15, 2012I tried updating the oracle database from version 11.2.0.1 to 11.2.0.3 but I have no clear procedure. I chose the option of the installer "upgrade database" and install the software on a new home. To migrate, must be all oracle services stopped? In the migration phase, it is normal to ask me listener data, etc .... or installer now detects the same database?
View 1 Replies View RelatedServer Administration :: Not Able To Open Database
Mar 8, 2013I am using oracle 10gXE just for basic practice but its showing following Errors
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 8 11:46:34 2
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down fir
SQL>
SQL>
SQL>
SQL> select * from dept;
select * from dept
[code]....