#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    56
    Rep Power
    4

    Question 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?
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    858
    Rep Power
    388

    Cool


    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;
    }
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Posts
    3
    Rep Power
    0
    Rman Back up is the Physical Backup.. Database on archive log mode. No need to Shutdown the database.. Just Give correct path.

IMN logo majestic logo threadwatch logo seochat tools logo