Stack Overflow
Stack Overflow

Questions tagged [rman]

rman or Recovery Manager is a CLI tool for performing backups and recoveries on an Oracle Database.

rman or Recovery Manager is a CLI tool for performing backups and recoveries on an Oracle Database.

Oracle Recovery Manager (RMAN) is available as a command-line tool and can be accessed from Oracle Enterprise Manager. It simplifies the tasks of restoring a database from backups due to disk/hardware errors, user errors, and for managing replication. It supports restoring to a point in time, or tablespace, data file, or complete database recovery.

Recommended reading on rman basics:

153 questions
0
votes
0 answers

Oracle: how to specify non-default backup location during RMAN restore

Oracle 19c on Windows. RMAN scheduled backups go to FRA here: D:\oracle\recovery. I have another backup in D:\backup\ which I want to restore. I need to be able to "tell" Rman to look into non-default location. Here is what I have so far: shutdown…
epipko
  • 473
  • 5
  • 18
0
votes
0 answers

Restore the source database changes using RMAN Incremental backup in Oracle 19C where Target Database also changes

Need to upgrade the Oracle database from 12C to 19C in different Servers using RMAN backup and restore method. DB Size is approx. 10TB and increasing on a daily basis. Below would be the steps: Install Fresh Oracle 19C in the unix server. Take RMAN…
Sangi Dan Paliwal
  • 3
  • 4
0
votes
1 answer

after restroring tablespace table or view not exists

I've Oracle CDB with PDB In the PDB I created a tablespace then I created a table over this tablespace after that, I login into RMAN for the CDB database then I make a backup using backup database ; then I drop the table using drop table table1…
Tariq Hajeer
  • 308
  • 2
  • 14
0
votes
1 answer

Is it a way to free up resources on Oracle 9i?

My Oracle 9i database is organized in "ArchiveLog" mode. I am trying to recover space because the virtual machine on which this base is installed has been badly sized, and it is reaching saturation. I have executed the command under RMAN: DELETE…
Noobe
  • 1
  • 1
0
votes
1 answer

Passing multiple arguments in vbscript

I have to pass multiple arguments in my .vbs script but the problem is the script does not get executed from windows task schedular if I pass multiple arguments separated by white spaces. I am running the script like below, cscript//nologo…
Chandra Pat
  • 19
  • 3
0
votes
0 answers

VBS script not printing the value of a variable in a file

I need to generate a RMAN backup script dynamically and stored in a file so it can be executed later to backup database and also delete the old backups older than defined retention period. I am passing the value of retention period in a variable…
Chandra Pat
  • 19
  • 3
0
votes
1 answer

Oracle rman backup schedule after a failed level 1 incremental backup

I created rman backup level 0 on monday -> succeeded , level 1 on tuesday -> succeeded ,level 1 on wednessday -> failed My doubts are 1)after the failed schedule which level (0/1/cumulative) of backup i have to take to make sure my database…
SabeekAhamed Sagabdheen
  • 13
  • 4
0
votes
0 answers

Is there a way to specify datafile 1 path when opening oracle database?

please I have copied my RMAN backup files to a new server with the same file path and oracle database name, I have taken the database to mount stage, but when I say 'alter database open resetlogs', it says error ORA-01194 file 1 needs more recovery…
Rex
  • 131
  • 1
  • 1
  • 4
0
votes
1 answer

RMAN: a fast question about single table recover

I want to get a single table accidentally dropped from db. Db is a pluggable db I have tried this but fail rman target=/ recover table myuser.persons2 OF PLUGGABLE DATABASE pdb2 until scn 37128783 auxiliary destination '/tmp/aux' datapump…
elbarna
  • 597
  • 1
  • 10
  • 26
0
votes
0 answers

RMAN-06004: Oracle error from recovery catalog database: RMAN-20299: DBMS_RCVMAN package not compatible with the recovery catalog

I found archivelog backup is failing with the below errors. RMAN> 2> 3> 4> 5> Starting backup at 01-NOV-22 current log archived RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK…
Balaji Chandramohan
  • 1
  • 1
0
votes
0 answers

Oracle db password with $ not working in rman

my oracle database user name is SYSTEM and password is smith123$ I tried to execute a backup shell script su - root -c "rman target SYSTEM/smith123$@ORCL cmdfile /home/oracle/dbDump/rman.ls " I got the folllowing error while running the above…
SabeekAhamed Sagabdheen
  • 13
  • 4
0
votes
1 answer

RMAN Config History

I know this seems kind of a strange request, but does RMAN have any history of the changes to config parameters? Seems like one of the team members has been changing the config parameters to a number of instances, and of course no one is claiming…
Landon Statis
  • 683
  • 2
  • 10
  • 25
0
votes
1 answer

Configure RMAN backup in a RAC Database

Im working on a clustered database and I'm not knowing where to setup my rman script in order to schedule rman backups. Should i setup my scripts on both databases, or on only one. My aim is to backup the full databases and keep an rman script…
Elie W
  • 1
0
votes
1 answer

I want to backup my database to a shared drive 10.20.1.159, but the RMAN is not using my configuration parameters

Please suggest how to fix the parameters so that I can write my files in the designated directory and the format I want. Below is the RMAN SHOW ALL; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY…
Elie W
  • 1
0
votes
1 answer

Oracle DB RMAN backup

Iam having a weekly full backup in my database what i need is a script that first verify the new backup if it is valid then delete the old one iam doing this for saving space on my filesystem the Oracle database version = 12c
Mohammed
  • 3
  • 4
1 2 3
…
10 11