The fifth day of Oracle learning [RMAN]

Two methods to Start RMAN

1

C: \ Documents ents and Settings \ Administrator>RMAN

Recovery MANAGER: Version 10.1.0.2.0-Production

Copyright (c) 1995,200 4, Oracle.
All rights reserved.

RMAN>Connect target/

Connect to the target database: orcl (dbid = 1268391944)

RMAN>

2

C: \ Documents ents and Settings \ Administrator>RMAN
Target/

Recovery MANAGER: Version 10.1.0.2.0-Production

Copyright (c) 1995,200 4, Oracle.
All rights reserved.

Connect to the target database: orcl (dbid = 1268391944)

Change the password of SYS and system users

SQL> Conn/As sysdba

Connected.

SQL>Alter user system identified by Feng;

The user has changed.

SQL> conn system/Feng;

Connected.

SQL>Alter user SYS identified by Feng;

The user has changed.

3. connect to a remote database

C: \ Documents ents and Settings \ Administrator>RMAN
Target System/Feng @ orcl

Recovery MANAGER: Version 10.1.0.2.0-Production

Copyright (c) 1995,200 4, Oracle.
All rights reserved.

Connect to the target database: orcl (dbid = 1268391944)

RMAN>

 

Execute operating system commands

RMAN>Host;

Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C: \ Documents ents and Settings \ Administrator>

 

Execute SQL commands

RMAN>SQL'Alter system archive log all';

RMAN>Backup database;

RMAN>Backup database format 'J: \ oracle \ Bak _ % U ';

RMAN>Backup tablespace system;

SQL>Select file_id, file_name from dba_data_files;

RMAN>Backup datafile 'J: \ oracle \ bak_0qmdi87g ';

RMAN>Backup current controlfile;

RMAN>Backup archivelog all;

RMAN>Backup spfile;

RMAN>Backup backupset all;

RMAN>Backup backupset N;

RMAN>List backup of database;

RMAN>List backup of tablespace users;

RMAN>Delete backupset N;

RMAN>Show all;

RMAN>List backup;

RMAN>List backup of controlfile;

RMAN> Report need backup;

RMAN>Report obsolete;

RMAN>Crosscheck archivelog all;

RMAN>Crosscheck backup;

RMAN>Change backup of tablespace system unavailable;

RMAN>