DanBrother的部落格

Restore Oracle 11g Database from RMAN Backup (Full and Archive Logs Backup)

◎ Backed Up Data Environment:

Using RMAN to Restore A Dropped Tablespace without Resetlogs (11gR2)

##############################################

There are two SYS Packages Used by RMAN while performing the backup:

1. SYS.dbms_backup_restore
à used to create system calls to backup datafiles, control files and archived redo logs

# Perform Backup:

. oraenv
[test1]

RMAN Encrypted Backups Practice (Oracle 11g):

export ORACLE_SID=TESTDB

Clone RAC Database to a None-RAC DB From RMAN Backup Without Connect to the Source DB  (Oracle11gR2)

Alert Log:
************************************************************************
You have following choices to free up space from flash recovery area:

Rman: Ora-01008 When Connecting To Target in 11.2.0.2 [ID 1280447.1]
Bug#10414993

SQL> conn /@test9i as sysdba
已連線.
SQL> archive log list

rman_backup_arch.sh
>>

################################

rman_backup_level0.sh
>>

Restore Database Using RMAN: 

Prerequisite:
a. controlfile  copied to the db controlfile path

以下的RMAN Script 可將之前RMAN備份的Archive Log還原到新的路徑:

run {

-- Without Recovery Catalog

SQL> select 'set newname for datafile '||file_id||' to '''||replace(file_name,'SRCDB','NEWDB')||''';' from dba_data_files;   -->  取得新DB datafile的各個路徑

set oracle_sid=NEWDB