Help Backup Oracle Database Using RMAN Utility

Dev Shed Forums Sponsor:

February 13th, 2012, 12:44 PM

CarlosinFL

Contributing User

Join Date: Aug 2011

Posts: 51

Time spent in forums: 10 h 8 m 48 sec
Reputation Power: 2

Help Backup Oracle Database Using RMAN Utility

I'm going to backup this un-maintained Oracle 11g server in my office. I'm being told it's never been backed up and extremely critical to our success so tomorrow I'll be performing my 1st backup of the database using RMAN. My question is if I connect to the Oracle 11g database and run the:

Code:

[oracle@db1 ~]$ rman target=/

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 13 13:18:05 2012

connected to target database: CQDB (DBID=1854033249)

RMAN> shutdown immediate

using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

BACKUP DATABASET FORMAT ‘/oracle/u01/app/oracle/backup/%d-%T-%s-%P’;

My question is the above sufficient for a safe full backup? We only have the one single target database called 'cqdb' which houses several schemas. Can you tell me if this is correct? I've shut the database down so it's in a cold state so I don't think I need to configure the FRA (Flash / Fast Recovery Area) but I honestly don't know. This is my 2nd time on a Oracle DBMS.

What about the 'archivelog' files? Do I back those up? Do I need them in case a recovery? Also what about the 'controlfile'? Do I need to back those up as well as the mentioned above?

February 15th, 2012, 09:38 AM

LKBrwn_DBA

Contributing User

Join Date: Sep 2006

Posts: 751

Time spent in forums: 1 Week 2 h 56 m 5 sec
Reputation Power: 348

Quote:

Originally Posted by CarlosinFL

... Etc ...tomorrow I'll be performing my 1st backup of the database using RMAN. My question is if I connect to the Oracle 11g database and run the:

If database in archive log mode you do not need to shutdown the database, try this:

Code:

$ rman target=/
...
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/u01/app/oracle/backup/%d-%T-%s-%P';
RUN
{
  ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
  ALLOCATE CHANNEL ch2 DEVICE TYPE DISK;
  BACKUP AS COMPRESSED BACKUPSET
    DATABASE
    INCLUDE CURRENT CONTROLFILE
    PLUS ARCHIVELOG DELETE INPUT;
}

__________________

April 28th, 2012, 01:10 AM

kimipatel

Registered User

Join Date: Apr 2012

Posts: 3

Time spent in forums: 2 h 50 m 33 sec
Reputation Power: 0

Rman Back up is the Physical Backup.. Database on archive log mode. No need to Shutdown the database.. Just Give correct path.

Viewing: Dev Shed Forums > Databases > Oracle Development > Help Backup Oracle Database Using RMAN Utility

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump