ITPub博客

首页 > 数据库 > NoSQL > pg_rman备份恢复data下面的数据全丢了

pg_rman备份恢复data下面的数据全丢了

原创 NoSQL 作者:celestezhang 时间:2014-09-19 22:52:38 0 删除 编辑
-bash-4.1$ pg_rman backup --backup-mode=full
INFO: database backup start
NOTICE:  pg_stop_backup complete, all required WAL segments have been archived
-bash-4.1$ pg_rman backup --backup-mode=incremental --with-serverlog
INFO: database backup start
ERROR: There is no validated full backup with current timeline.Please take a full backup and validate it before doing an incremental backup.
NOTICE:  pg_stop_backup complete, all required WAL segments have been archived
-bash-4.1$ pg_rman backup --backup-mode=archive --with-serverlog
-bash-4.1$ pg_rman show -a
============================================================================
Start                Time   Total    Data     WAL     Log  Backup   Status  
============================================================================
2015-06-25 03:05:12    0m    ----    ----   301MB   1733B   488kB   DONE
2015-06-25 03:02:04    0m    ----      0B    ----    ----      0B   ERROR
2015-06-25 02:59:24    1m   411MB    ----   251MB    ----    33MB   DONE
2015-06-25 02:42:26    0m    ----    ----   184MB   2047B   299kB   DONE
2015-06-25 02:41:00    0m    ----      0B    ----    ----      0B   ERROR
2015-06-25 02:37:36    0m   411MB    ----   134MB    ----    32MB   OK
2015-06-25 01:25:22    0m    ----    ----    33MB      0B    53kB   OK
2015-06-25 01:25:11    0m    ----    ----    16MB      0B    27kB   OK
2015-06-25 01:04:24    0m    ----    16kB    33MB   3842B    58kB   OK
2015-06-25 00:59:10    0m   411MB    ----   251MB    ----    33MB   OK
2015-06-24 23:18:39   14m  2059MB    ----   167MB    ----   163MB   OK
2015-06-24 05:29:11  ----    ----    ----    ----    ----      0B   ERROR
2015-06-24 04:01:40    0m    ----   411MB   117MB    ----    30MB   OK
2015-06-24 03:52:59    1m   411MB    ----    83MB    ----    32MB   OK
2015-06-24 02:56:44    0m    ----    16kB    33MB   189kB   245kB   OK
2015-06-24 02:51:55    0m   411MB    ----    33MB    ----    32MB   OK
-bash-4.1$ pg_ctl stop
waiting for server to shut down.... done
server stopped
-bash-4.1$ ls
postgresql-Thu.log
-bash-4.1$ cd ..
-bash-4.1$ ls
backup_label.bak2  global       pg_ident.conf  pg_notify     pg_stat_tmp  pg_xlog               recovery.conf.bal
backup_label.old   logfile      pg_log         pg_replslot   pg_subtrans  postgresql.auto.conf  recovery.done
base               pg_clog      pg_log.bak     pg_serial     pg_tblspc    postgresql.conf
data.bak           pg_dynshmem  pg_logical     pg_snapshots  pg_twophase  postmaster.opts
data_bak_15.47     pg_hba.conf  pg_multixact   pg_stat       PG_VERSION   recovery.conf.bak
-bash-4.1$ cd ..
-bash-4.1$ ls
backups  backup.tar  backup.tar.bak  data  data_000  data_1bak  databak2  datadrop  datastop_bak  logfile  pgstartup.log
-bash-4.1$ mv data data1515
-bash-4.1$ pg_rman restore --recover-target-time "2015-06-25 03:05:12"
pg_rman: unrecognized option '--recover-target-time'
Try "pg_rman --help" for more information.
-bash-4.1$ pg_rman restore --recovery-target-time "2015-06-25 03:05:12"
WARNING: can't open pg_controldata file "/var/lib/pgsql/9.4/data/global/pg_control": No such file or directory
WARNING: can't open pg_controldata file "/var/lib/pgsql/9.4/data/global/pg_control": No such file or directory
INFO: validate: 2015-06-25 02:59:24 backup and archive log files by SIZE
INFO: restore complete. Recovery starts automatically when the PostgreSQL server is started.
-bash-4.1$ psql
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
-bash-4.1$ pg_ctl start
server starting
-bash-4.1$ < 2015-06-25 03:16:20.762 EDT >LOG:  redirecting log output to logging collector process
< 2015-06-25 03:16:20.762 EDT >HINT:  Future log output will appear in directory "pg_log".


-bash-4.1$ psql
psql (9.4.3)
Type "help" for help.


postgres=# \q
-bash-4.1$ psql arch
psql (9.4.3)
Type "help" for help.


arch=# select * from test
arch-# select * from test;
ERROR:  syntax error at or near "select"
LINE 2: select * from test;
        ^
arch=# select * from test;
 a 
---
 1
 2
 3
 4
(4 rows)

-bash-4.1$ cat recovery.done
# recovery.conf generated by pg_rman 1.2.11
restore_command = 'cp /arclog/%f %p'
recovery_target_time = '2015-06-25 03:05:12'
recovery_target_timeline = '5'
-bash-4.1$ ls
backup_label.bak2  global       pg_ident.conf  pg_notify     pg_stat_tmp  pg_xlog               recovery.conf.bak
backup_label.old   logfile      pg_log         pg_replslot   pg_subtrans  postgresql.auto.conf  recovery.conf.bal
base               pg_clog      pg_log.bak     pg_serial     pg_tblspc    postgresql.conf       recovery.done
data.bak           pg_dynshmem  pg_logical     pg_snapshots  pg_twophase  postmaster.opts
data_bak_15.47     pg_hba.conf  pg_multixact   pg_stat       PG_VERSION   postmaster.pid
-bash-4.1$ cd pg_log
-bash-4.1$ ls
postgresql-Thu.log
-bash-4.1$ cat postgresql-Thu.log 
< 2015-06-25 03:16:20.763 EDT >LOG:  database system was interrupted; last known up at 2015-06-25 02:59:24 EDT
< 2015-06-25 03:16:20.873 EDT >LOG:  restored log file "00000005.history" from archive
< 2015-06-25 03:16:20.873 EDT >LOG:  starting point-in-time recovery to 2015-06-25 03:05:12-04
< 2015-06-25 03:16:20.875 EDT >LOG:  restored log file "00000005.history" from archive
< 2015-06-25 03:16:20.895 EDT >LOG:  restored log file "00000005000000000000005A" from archive
< 2015-06-25 03:16:20.930 EDT >LOG:  redo starts at 0/5A000090
< 2015-06-25 03:16:20.930 EDT >LOG:  consistent recovery state reached at 0/5A0000B8
< 2015-06-25 03:16:20.952 EDT >LOG:  restored log file "00000005000000000000005B" from archive
< 2015-06-25 03:16:20.975 EDT >LOG:  restored log file "00000005000000000000005C" from archive
< 2015-06-25 03:16:20.996 EDT >LOG:  restored log file "00000005000000000000005D" from archive
< 2015-06-25 03:16:21.019 EDT >LOG:  restored log file "00000005000000000000005E" from archive
< 2015-06-25 03:16:21.019 EDT >LOG:  recovery stopping before commit of transaction 1972, time 2015-06-25 03:05:13.065482-04
< 2015-06-25 03:16:21.019 EDT >LOG:  redo done at 0/5E000028
< 2015-06-25 03:16:21.019 EDT >LOG:  last completed transaction was at log time 2015-06-25 03:02:23.487597-04
< 2015-06-25 03:16:21.043 EDT >LOG:  restored log file "00000005000000000000005D" from archive
cp: cannot stat `/arclog/00000006.history': No such file or directory
< 2015-06-25 03:16:21.047 EDT >LOG:  selected new timeline ID: 6
< 2015-06-25 03:16:21.049 EDT >LOG:  restored log file "00000005.history" from archive
< 2015-06-25 03:16:21.112 EDT >LOG:  archive recovery complete
< 2015-06-25 03:16:21.316 EDT >LOG:  database system is ready to accept connections
< 2015-06-25 03:16:21.317 EDT >LOG:  autovacuum launcher started
< 2015-06-25 03:17:12.794 EDT >ERROR:  syntax error at or near "select" at character 20
< 2015-06-25 03:17:12.794 EDT >STATEMENT:  select * from test
        select * from test;


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29898569/viewspace-1274723/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2014-09-19

  • 博文量
    39
  • 访问量
    125985