RMAN :: What Does (change) Command Do

Sep 12, 2013

What the "change" RMAN command does? For example, what is the effect of following command: 

change archivelog until time 'SYSDATE-7' delete 

And what is the difference between following commands: 

change archivelog all validate;change archivelog all crosscheck;change archivelog all; 

I checked the following doc but could not find anything:[URL]I am using Oracle 10gR2 on RHEL 64-bit.

View 3 Replies


ADVERTISEMENT

SQL & PL/SQL :: Using EXECUTE IMMEDIATE For DDL Command In Procedure For Password Change?

Nov 6, 2011

I have a procedure in this procedure i use.

EXECUTE IMMEDIATE 'alter user '||use||' identified by '||modp ||' replace '||oldp;

but when i execute it show insufficient privilages but i create for this procedure as public.and grant execute facility to the user.

View 6 Replies View Related

Security :: User Unable To Change Password With Command

Aug 23, 2010

We have enable the alter log for audit purpose so the password will be display in the log which is not security. I try to use "password" to change password but very user got the error below.

SQL> password
Changing password for RUDEE
Old password:
New password:
Retype new password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20014: -6502 ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 27

Password unchanged

View 17 Replies View Related

RMAN - Set Command ID

Dec 27, 2011

I can successfully SET COMMAND ID inside an RMAN run block

CODErman <<EOF
connect target
connect catalog ....
CROSSCHECK BACKUP DEVICE TYPE DISK;
CROSSCHECK ARCHIVELOG ALL;
RUN {
[code]...

Can this be setup without a RUN block? I am running on 11.1.07 and 11.2.0.2

View 2 Replies View Related

RMAN :: Delete Obsolete Command Without Confirmation?

Mar 12, 2013

I've created a small script witch delete the obsolete and expired backups of RMAN.

The problem is: the "delete obsolete" and the "delete expired backup" command needs a confirmation with YES. I don't need to confirm the command and he deletes the backups directly?

Here is my little script:

#!/bin/ksh
export ORACLE_SID=dbtest2
export ORACLE_HOME=/home/oracle/srv/ora/product/11.2.0/dbtest_2
export ORACLE_BIN=/home/oracle/srv/ora/product/11.2.0/dbtest_2/bin
alias RMAN=$ORACLE_BIN/rman

[code].....

View 9 Replies View Related

RAC & Failsafe :: RMAN Command To Reduce Space Usage

Sep 21, 2010

How to reduce the space usage in RMAN commands.

View 3 Replies View Related

RMAN :: 03009 - Failure Of Backup Command On Channel?

Sep 17, 2013

 I've attempted to backup my database using RMAN but i got the ERROR that follows: 

RMAN> backup database; output:Starting backup at 16-SEP-13using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=20 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00001

[code]...

View 4 Replies View Related

RMAN :: Duplicate Command Failed In Without Catalog On Different Server

Jun 29, 2012

i am creating duplicate DB from rman backup it failed as all steps is as below:

$ vi pfile.ora
$
$
$ export ORACLE_SID=tim
$
$
$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 8 10:35:10 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> !pwd
/oracle1/oraerp/tech_st/dbhome_1/dbs
[code]....

View 10 Replies View Related

RMAN :: Cloning Using Duplicate Command - Retain Conversion

Feb 7, 2013

While cloning using RMAN DUPLICATE command, one can convert all files from various locations to new locations by using DB_FILE_NAME_CONVERT. One can also retain the same locations with no conversion by using NOFILENAMECHECK. My question is what if I want to convert some, and not convert others?

View 3 Replies View Related

Backup & Recovery :: RMAN Command Hang Long Time?

Mar 20, 2012

We would take backup regulary by RMAN(catalog). Last two days we could not take backup. Backup start but after take backup some datafile then rman does not do anything.

View 4 Replies View Related

RMAN-03009 / Failure Of Backup Command On ORA_DISK_2 Channel

Jul 4, 2010

when im taking backup on rman it showing the error like this

RMAN-03009:failure of backup command on ORA_DISK_2 channel
ORA-19502:write error on file "disk1/oradata/car/rm/Oalhudpe.bkp". block number 16385(block size =8192)
ORA-27072:FILE I/O ERROR
Linux Error:2:no such file directory
addittional information:4
addittional information:16385
addittional information:823296

View 2 Replies View Related

Recovery Manager (RMAN) :: Information For List And Restore Command

May 15, 2013

Version 11.2.0.1

Control file record time = 7 days

I am not using recovery catalog

RMAN> list archivelog all;

It shows archivelogs from logsequence 179 - 206

But on my o.s I have archivelogs from log sequence 104 - 206 (I have not deleted them for long 1 month). It is not showing form 104 - 178. Since control file record time is 7 days it doesnt keep old archivelogs history.(i.e from 104-206) Hence it is showing only from 179 - 206

My question is

1)If we use rman recovery catalog will these info is maintained forever until deleted. And can i see them in list command. (i.e from 104-206)
2)If i use rman catalog then from where did rman get the information of archives and backup (for list and restore command) from catalog or from control file.

View 1 Replies View Related

Data Guard :: RMAN Archive Log Backup With Delete Input Command

Mar 17, 2012

I have following query in Dataguard ..

If I want to take Rman archive log backup with delete input command , how the archive logs will be copied to standby database

For eg

I am taking archive backup as

RMAN>backup archivelog all delete input;

here consider few archives are not copied to standby database (due to nw issue) then how standby will receives these missing archives as those are deleted by rman backup at primary side.

I am not getting any document related to above query.

View 7 Replies View Related

Recovery Manager (RMAN) :: Delete Obsolete Command Not Deleting Backupset Automatically

Nov 30, 2012

I am trying to delete the backupset using Delete Obsolete command, but i am unable to get the success. As per the oracle Doc after completion of Retention Period oracle automatically deletes the backupset. I have set the retention period of 8 days.

View 7 Replies View Related

RMAN :: Change Database Name Control Files After Restore

Jul 12, 2012

I have restored database with the name DB to another database called DB01

it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it because of the name, how to solve this issue if possible? I have RMAN full backup from DB on my current server which hosting the database DB01 the initdb01.ora is ready and configured with DB01

what can I do next

ORA-01103: database name 'DB' in control file is not 'DB01'

View 5 Replies View Related

Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)

Sep 13, 2013

we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?

View 3 Replies View Related

RMAN :: RMAN-03014 / Implicit Resync Of Recovery Catalog Failed

May 29, 2013

My oracle backup via Netbackup failing with error 6 (Netbackup) and i have checked the logs please find the RMAN log file as well.

Script /opt/rman_script/st72_oracle_full.sh
==== started on Tue May 28 15:27:46 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: ST72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_FULL: 1
NB_ORA_INCR: 0

[code]....

View 2 Replies View Related

RMAN :: Encryption / Decryption When Using RMAN To Duplicate / Clone?

May 8, 2013

Given facts:

rman is used to backup database A to disk

rman is used to put those disk backups to tape

rman is used to duplicate database A to database B on another host

the duplicate process worked fine before we started testing encryption

the duplicate process worked fine with database A having an encrypted column in one table in a non-encrypted tablespace

Now, database A has an encrypted tablespace with nothing currently in it. The duplicate process now ultimately fails with ORA-19913, unable to decrypt backup.

I am not using encrypted backups, not specifying encrypt or decrypt anywhere in the duplication process. The only thing that is encrypted is the one tablespace in database A. I have the same wallet files on Host A (database A) and Host B (database B). Wallets are open. So why does the duplication process fail because the backup cannot be decrypted?

View 8 Replies View Related

SQL & PL/SQL :: Command Example In Oracle 9?

Aug 5, 2010

I want to use oracle 9 select * from tab .And use the output to issue "desc XXX " for every row of output in select statement.. .How can I do it automatically ???

View 9 Replies View Related

SQL & PL/SQL :: How To Use DEFINE Command

Jun 5, 2012

set serveroutput on
set verify off
declare
define t1='111';
begin
dbms_output.put_line(t1);
end;
/
define t1='111';
*
ERROR at line 2:
ORA-06550: line 2, column 10:
PLS-00103: Encountered the symbol "=" when expecting one of the following:

:= . ( @ % ; not null range default character

The symbol ":= was inserted before "=" to continue.

View 5 Replies View Related

SQL & PL/SQL :: Use Of RAISE Command?

Aug 31, 2011

explain to me what the "RAISE" command does in PL/SQL for the following code.

EXCEPTION
WHEN OTHERS THEN
INSERT INTO TMP_ERRCHECK(
PP_CD,
IHS_CD,

[code]...

Tried searching for some explanations but I still do not have a clue as to what the RAISE actually does. Do I even need to put it in the code?

View 3 Replies View Related

SQL & PL/SQL :: Pivot Right Command To Use?

Aug 28, 2011

I have the following table structure:

PK1,PK2,PK3,A1,B1,C1,A2,B2,C2

Which I want represent as follows:

PK1,PK2,PK3,A1,A2
PK1,PK2,PK3,B1,B2
PK1,PK2,PK3,C1,C2

Is pivot the right command to use? If so, how do I do this? Most pivot examples I've looked at use an aggregate like SUM, which is not really want I am trying to accomplish here.

View 4 Replies View Related

SQL & PL/SQL :: Update Command

Jun 7, 2011

here is my table...

id name bits

A 1 011011101 00
B 2 011011111 01
C 3 100100010 11

Here, I need to write a query to change 0 to 1 and 1 to 0 for every record value in table of bits column.

for ex: 011011101 00 of id - A must be changed to 100100010 11

similarly, 100100010 11 of id - C must be changed to 011011101 00

Now I need to write a query to update values of bits column in one shot.

View 4 Replies View Related

PL/SQL :: Use Of MOD Command In Query

Jun 7, 2012

what is the use of MOD command in query.Does it have performance benefit.

View 11 Replies View Related

Adrci Purging Of Command?

Sep 27, 2011

I am using the following command within a shell scrript to purge files with adrci

adrci exec="show homes"|grep -v : | while read file_line
do
echo "adrci purging diagnostic destination " $file_line
echo "purging ALERT older than $Minutes ..."
adrci exec="set homepath $file_line;purge -age $Minutes -type ALERT"

[code]...

Is there a command I can use to see what will be purged or what has been purged?

View 2 Replies View Related

Sqlplus Copy Command

Feb 15, 2013

i am trying to copy the data from a remote database which has Oracle 8i thru Sqlplus copy command to the local database which has Oracle 11gR2.

copy from abc/abc@remote
insert emp_new
using
select *
from emp_old
where rownum < 1001;

is it possible to copy the remote database thru sqlplus copy command ?

View 6 Replies View Related

SQL & PL/SQL :: Execute Immediate Command Error

Oct 14, 2011

I am facing a problem regarding the execute immediate command. I have created a procedure as given below

SQL> set echo on ;
SQL> set serveroutput on;
SQL> declare
2 l_var varchar2(50);
3 sqlstring varchar2(3000);
4 begin
[code].......

In this procedure the execute immediate command shows error ( if i avoid exception).I have tried other syntax too of this command
but it is showing error only.

View 13 Replies View Related

SQL & PL/SQL :: Run Command And Connection In One Line

Dec 5, 2011

I want run sql connection and command in one line , something like this ...

sqlplus "/as sysdba" 'select * from dual'

is it possible to do it in one command ?

View 3 Replies View Related

SQL & PL/SQL :: Copy Command In A Procedure

Feb 22, 2010

I got to pull 30M data into local DB from a remote DB. As of now we have procedure to perform this task using an

Insert /*+append*/ table1
select *
from rdb_view;

I observed using the copy command in sql plus has taken very less time than the procedure.Can we use the Copy command inside the PL/SQL block? I tried with dynamic SQL but It is not allowed I guess.

View 16 Replies View Related

SQL & PL/SQL :: Use FROM Clause In Update Command?

Jul 13, 2011

Can we use FROM clause in update command?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved